Problem:

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. Specify the actual server name, ‘SQLVMSQL02’. (Replication.Utilities)

Scenario:

1. We configured database mirroring on 2 SQL Server instances.

2. We changed the computer name from SQLVM to SQL2K5.

3. We tried launching the Database Mirroring monitor, but we got the following error:

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. Specify the actual server name, 'SQLVMSQL02'. 
(Replication.Utilities)

If you just look at the error, it sounds a bit misleading because we don’t have replication configured in either of the servers.

Resolution:

-- 1. drop old server/instance name
EXEC sp_dropserver [sqlvmsql01] 
GO
 
-- 2. add newserver/instance name
-- local meaning we're adding the local machine
EXEC sp_addserver [mysql2k5sql01], local 
GO
 
-- 3. Restart SQL Server service

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)
Be Sociable, Share!
  • Tweet

Related posts:

  1. Script to Drop/Recreate CHECK Constraints …
  2. How to Drop All Stored Procedures in Your Database …
  3. Script to Drop/Recreate Default Constraints …
  4. Script to Drop/Recreate Unique Indexes …
  5. Resolving “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” …
  6. Issue: Length of LOB data to be replicated exceeds configured maximum 65536 …

YARPP