SQL Server replication requires an actual Server name to connect to the Server. Error Solution

The following exception occurs during the configuration of Transactional Replication in SQL Server 2005/2008.

Exception information: Replication. Utilities
----------

SQL Server replication requires an actual Server name to connect to the Server. Connection by server alias, IP address, or any other backup name is not supported. Specify the actual server name "xxxxxxx ".

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 alternate name are not supported.

Exception:

Solution:

1. Check the SQL Server Name:

SELECT @ SERVERNAME

2. If the server name obtained from the preceding SQL query does not match the actual computer name, perform the following steps:

Sp_dropserver 'old _ server_name '-- previous name
GO
Sp_addserver 'current _ computer_name ', 'local' -- new name

In this case, run SELECT @ SERVERNAME again, and the NULL value may be obtained. Restart the SQLSERVER service and run the query statement again to obtain the real name of the SERVER.

 

========================================================== ========

 

Error
The server 'lc04 'cannot be deleted because it is used as the Publishing Server during replication. (Microsoft SQL Server, error: 20582)

Solution

Select * from msdb. dbo. MSdistpublishers
Delete from msdb. dbo. MSdistpublishers
Select * from msdb. dbo. MSdistpublishers
Exec sp_droplinkedsrvlogin 'lc04 ', null
Exec sp_dropserver 'lc04 ', 'droplogins'
Exec sp_addserver 'mssqlserver ', 'local'
Restart SQLServer Service