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

"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 alternative name are not supported. Specify the actual server name, 'XXXXXX'. (Replication.Utilities)"

This error has been observed on a server that had been renamed after the original installation of SQL Server, and where the SQL Server configuration function ‘@@SERVERNAME’ still returned the original name of the server. This can be confirmed by:


select @@SERVERNAME
go
Solution:

1) sp_dropserver old-server-name
go
sp_addserver real-server-name, LOCAL
go


2)Restart SQL Server Service


Comments