SQL Server Management Studio – “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, ‘…'”.

When you try to access to your replication with SQL Server Management Studio show 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, ‘{server name}’. (Replication.Utilities)

Solution:

Use {server name} specified to reconnect to SQL Server Management Studio.

Did my solution solve your problem?

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

sp_helpserver
select @@servername

Solution:

Run this:

sp_dropserver 'old_name'
go
sp_addserver 'new_name','local'
go

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?