"SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported."
Cause : the server name has been changed after SQL Server Installation
Resolution : You can change the server name in SQL server by using the code below; Execute in SSMM.
sp_dropserver 'old_server_name'(Ex : oldserver\instance)
GO
sp_addserver 'current_computer_name'Ex : newserver\instance), 'local'
Thursday, July 7, 2011
SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any....
Subscribe to:
Post Comments (Atom)
Subscribe To This Web Site
Posts
Comments
No comments:
Post a Comment