I have changed the computer name of the server where sql server 2008 r2 is installed. Old name is WIN-OUJEKRMGXXX and new server name is KASURDYYY When i configure replication following error occurs:
SQL Server Replication requires actual server name to make a connection to the server ... Specify the actual server name, WIN-OUJEKRMGXXX
i updated the server name in sql server in order to resolve the issue. i run following queries
sp_dropserver WIN-OUJEKRMGXXX
sp_addserver KASURDYYY, local
but still same error occurs
i checked the server name :
select @@SERVERNAME returns value WIN-OUJEKRMGXXX
select SERVERPROPERTY('SERVERNAME') returns value KASURDYYY
need help.
Aucun commentaire:
Enregistrer un commentaire