September 12, 2005 at 10:44 am
I've been trying to implement SQL Server 2000 Transactional Replication between 2 servers within our environment.
Both of these servers have the exact same SQLServerVersion/Service Pack combinations.
I've made sure that both servers have the named database on them (in this case ssurgo).
I've made sure that the logins/users/roles/permissions for the database on both servers are the same.
I configure one machine NCGCCERT01 as the distributor and publisher. No Problem
I then create the publication with articles from the ssurgo database. Problem
This is when the 'red x' icon shows up in the replication tree of the distributor.
Adding a push subscription doesn't change this.
A copy and paste of the error is below...
Does anyone have any feedback on the most likely source of this error ? Apart from installing SPA3 (already done)
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 203
Date: 9/12/2005
User: N/A
Computer: NGCGCERT01
Description: Subsystem Message - Job 'NCGCCERT01-ssurgo-ssurgo-1' (0XB0047NF9876E3F32A96187124C6B4477), step 2 - The replication agent is not
registered properly. Rerun SQL Server setup.
September 13, 2005 at 5:34 pm
September 14, 2005 at 8:42 am
Thanks for your reply.
I found the following article and sure enough this was the issue.
http://support.microsoft.com/default.aspx?scid=kb;en-us;811008
Some sort of dll registry error had occured in the installation of that server
(it had not been used for replication before this week)
Regards
David
September 14, 2005 at 7:25 pm
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply