SQL Server replication requires an actual Server name to connect to the Server

The WIN2008 R2 installed on the server does not care about the machine name. After the SQL2008 R2 database is installed, the machine name is changed when the AD domain is configured.

Then, when you start configuring database image synchronization, you first try to copy and publish the database. The result shows that "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... ", as shown in.

After checking the information on the Internet, some students concluded that the machine name is incorrect. This reminds me that the machine name was modified before, but the instance linked to the database uses an IP address or an alias. Okay. The solution is as follows:

1. Check the server (MACHINE) Name and run the following command in the default database instance or non-named database instance:

Use mastergoselect @ servername; select serverproperty ('servername ')

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

Sp_dropserver 'old _ server_name 'gosp _ addserver' current _ computer_name ', 'local'

3. Execute Step 1 again. If the server name is not changed or is displayed as null, restart the SQLSERVER service. Perform Step 1. The server name is displayed normally.

NOTE: If multiple instances exist, each instance must go through the preceding three steps.