WIN2008 R2 installed on the server, and then did not care about the machine name, after installing the SQL2008 R2 database, configure the ad domain to modify the machine name.
Then, when you start configuring Database mirroring synchronization, try the following database replication publication, and the result is "SQL Server replication requires an actual server name to connect to the server." Connections through server aliases, IP addresses, or any other alternate names are not supported. Please specify the actual server name ... "as shown in.
Online check, there are students summed up that is the machine name is not correct, this just remember before you did modify the machine name, but this link in the database is an instance of the IP or alias form address. OK, here's the solution:
1. Check the server (machine) name and execute it in the default or non-named instance of the database:
use master go select @@servername; select serverproperty( ‘servername‘ ) |
2. If you find that the server name and the actual computer name are not met by the SQL query above, perform the following:
3. Perform step 1 again to find that the server name has not changed or is displayed as null to restart the SQL Server service. Finally, step 1 is performed and the server name is displayed correctly.
Note: If there are multiple instances, each instance will go through each of the 3 steps individually.
SQL server replication requires an actual server name to connect to the server