cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
272
Views
0
Helpful
1
Replies

Database replication problems

mreilly
Level 1
Level 1

When I go into sql enterprise manager on my publisher or subsriber and click on that sql server the name is local(not the name of the server). On the publsisher I see two server itself which name says local and the subsriber which says cmsub. On the sub I just see local. This is causing problems with my replication, how do I get the name to change to the name of the server.

1 Reply 1

jbond_c24
Level 1
Level 1

right click on (local) click "delete sql server registration" click "ok"

Right click on SQL Server Group select "New sql server registration" a wizard will popup. enter the netname of the sub and click next. Register the server using sql and windows authentication. enter the sa password and click finish. You should see the sql server register successfully. Then stop and restart the sql server agent service on the sub,

Replication should then be restored.

g'luck

James