November 14, 2007 at 9:31 am
Greetings,
I'm having a tough time getting replication working. I am using the same server to perform all 3 replication roles (I don't have any say so in this decision). I can create the publication just fine but my problem is subscribing to it. Every time I try to run the log reader it throws and exception. I tried running it manually from the commandline with the verbose output option set to to and get an error when it attempts to run select @@SERVERNAME.
FWIW, I'm trying to setup replication for SQL Server 2000 databases using SQL Server 2005 management studio. Also the 2000 databases have SP 2 installed. Should I upgrade them to SP 4?
Thanks in advance for any help you can provide.
November 15, 2007 at 2:19 pm
Problem solved. Upgrading to service pack 3 solved it.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply