Categories
Microsoft Replication SQL Server

SQL Server – “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, ‘{old_name}’. (Replication.Utilities)”

If network name or server name is changed and you want to setup the server for replication you’ll receive the following error message:

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, ‘{old_name}’. (Replication.Utilities)

To get the Current Server Name (Instance Name) run these two queries in Microsoft SQL Server Management Studio that return old_name

[sourcecode language=”sql”]
sp_helpserver
select @@servername
[/sourcecode]

Solution:

Run this:

[sourcecode language=”sql”]
sp_dropserver ‘old_name’
go
sp_addserver ‘new_name’,’local’
go
[/sourcecode]

then start Command Prompt Window (Start -> Run -> cmd) and execute the following command:

net stop mssqlserver
net start mssqlserver

to restart SQL Server Service.

Did my solution solve your problem?

One reply on “SQL Server – “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, ‘{old_name}’. (Replication.Utilities)””

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.