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?
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?