Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-06 : 08:05:55
|
| JD writes "I got error when I try to implement a snapshot replication from SQL Server 2000 (SP 3) to 6.5 (SP 5a). Here is what I did. 1. Create distribution database on the same machine of SQL 2000;2. Create publication with Heterogenious database;3. Specify the SQL Server 6.5 as subscriber4. Create Push Subscription on SQL Server 6.5. The Domain Admin UserId is created on both of SQL 2000 and 6.5 and run xp_grantlogin ‘Administrators’, ‘admin’.The snapshot agent works fine, but the distribution agent failed. The error is: The process could not connect to Subscriber 'FL65SQ01'. The full message is: Login failed- User: repl_publisher Reason: Remote server 'FL65SQDEV01' is not defined as a publisher.But actually, I already defined the server 'FL65SQDEV01" (SQL 2000) as publisher before I create publisher. Thanks you very much if you could give some specific information.JD " |
|
|
|
|
|
SQL Server 2000 Replication