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. Server alias and IP address are not supported
Address or any other backup name. 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 server 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'
Go
Sp_addserver 'current _ computer_name ', 'local'
In this case, run select @ servername again, and the null value may be obtained. Restart sqlserver
Service, 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