Replication Error - SQL Server replication requires the actual server name to make connection to the server | SansSQL

Wednesday, January 11, 2012

Replication Error - SQL Server replication requires the actual server name to make connection to the server

Sometimes when we try to configuration relpication we might receive the below error which says that "SQL Server replication requires the actual server name to make connection to the server"

This can happen during the situations
  1. When you are connected to the server in object explorer using the IP address
  2. When the actual server host name hosting the SQL server database engine is changed
In the first case we can solve this issue by connecting to the server with the host name.

In the second case, to fix the issue we need to update the system catalogs by dropping and adding the server and restarting the SQL Server services. The updation of system catalogs can be done using the below queries.

USE master 
GO
EXEC sp_dropserver 'OldServerName'

USE master 
GO
EXEC sp_addserver 'NewServerName',local

3 comments:

yangamuniprasad said...

Very nice post sandesh. keep post like this errors and scenarios..

Thanks,
Prasad

Anonymous said...

How do you connect to a server over the internet without a VPN, without IP address/URL, without an alias, using a hostname (and in my case with a port specified) ?

Sandesh Segu said...

Without access to server you cannot connect to it. You should be inside the LAN or you should have access through VPN to connect to the server.

Post a Comment