Categories
Sql Server

SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name

SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name

SQL Server replication requires the actual server name

Today i am trying to create a replication publication, and i got the above mentioned error(SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name).

Issue:

This error has been observed on a server that had been renamed after the original installation of SQL Server means(Installation time instance name is ABC and after installation we have changed it to ABC1).

Solution:

First of all execute the following query.

SELECT @@SERVERNAME

It will display name of the server.It is different from your current instance name.So now follow the below solution to overcome this error.

Now run following query in the mentioned sequence.

sp_dropserver 'oldserver_name'
go
sp_addserver 'newserver_name', local
go

Where oldserver_name is name displayed by first query.