i am getting an error when i try to configure replication distibution....SQL Server is unable to connect to server 'SQL-SRV'.
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, 'SQL5-SVR'. (Replication.Utilities)
so i did some looking and it seems that the sql server was once called SQL5-SVR.
i was led ...here...
to rename the server instance. i am reluctant to do this on my production db without knowing the consequences.
i then found this...
Read the error message and remember SERVERNAME which is in quotes.
Run Sql Server Configuration Manager on publisher/distributor side;
Expand Sql Native 10.0 Configuration\Aliases node;
Create new alias which name exactly SERVERNAME from 1. It is should be a NetBIOS machine name or NetBIOS\instance_name for named instances.
Specify another options for alias (port, server and protocol).
Repeat 4 and 5 for 32bit native client.
Test. Run Management Studio on the same machine and try connect to the server (specify alias as server name).
Repeat 2 - 7 for all client machines where Management Studio will be used for replication setup.
but this doesn't seem to work either. Is there way for me to get round this?