SQL Server replication requires the actual server name to make a connection to the server. Specify 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.