Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Database replication problems

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
New Member

Re: Database replication problems

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

113
Views
0
Helpful
1
Replies
CreatePlease login to create content