"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:
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:
Solution:
select @@SERVERNAME
go
1) sp_dropserver old-server-name
go
sp_addserver
real-server-name, LOCAL
go
2)Restart SQL Server Service
Comments