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

WIN2008 R2 installed on the server, and then did not care about the machine name, installed the SQL2008 R2 database, configure the AD domain when the machine name was modified.

Then, when you start to configure Database mirroring synchronization, you first try the database replication publication, which indicates that SQL Server replication requires the actual server name to connect to the server. Connecting through a server alias, IP address, or any other alternate name is not supported. Please specify the actual server name ..., as shown in the following figure.

Online Check the next, a classmate summed up that is the machine name is wrong, this just remembered to have actually modified the machine name, but this time the link database in the case of the IP or alias form of the address. Well, the solution is as follows:

1. Check server (machine) name, execute in database default instance or unnamed instance:

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

2. The server name and the actual computer name that are found in the above SQL query are not met, execute the following:

3. Perform step 1 again and discover that the server name has not changed or is displayed as a null value, restarting the SQL Server service. Finally, perform step 1, and the server name appears normal.

Note: If you have more than one instance, each instance will go through the 3 steps above.