I have a SQL 2005 clustered server which is returning a Null value for @.@.servername. I find the server entry in sysservers. I have replication configured on this so i am not able to do a Sp_dropserver & sp_addserver as this acts as a publisher. The configured merge repication stopped working because of this issue and I am not able to delete replication as the the delete option uses @.@.servername which returns a null value. So I am struck in a loop.
Any advice is appreciated.
thanks
For a machine to be considered local, srvid = 0 in sysservers. Can you check on this?
Can a simple reboot of the nodes fix the problem? Otherwise how did you get into this state, considering you have replication set up properly already?
|||Hi,
Have you rename the virtual server name or the participating node name?
Peng
No comments:
Post a Comment