February 28, 2013 at 4:24 am
Hi
i am getting an error when i try to configure replication distibution....
SQL Server is unable to connect to server 'SQL-SRV'.
------------------------------
ADDITIONAL INFORMATION:
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...
Steps:
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?
Thanks
February 28, 2013 at 9:31 am
It is safe to use the dropserver/addserver method. All that does is change the underlying entry available in sys.servers.
SELECT * FROM sys.servers WHERE is_linked = 0
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 28, 2013 at 9:57 am
I tried this...
sp_dropserver 'SQL5-SVR'
go
sp_addserver 'SQL-SRV', LOCAL
go
but when i run this...
select @@SERVERNAME
it still gives the wrong name (SQL5-SVR)
???
February 28, 2013 at 10:00 am
Did you stop and start the SQL server service?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 28, 2013 at 10:06 am
brilliant. and the replication is now working perfectly. thanks
February 28, 2013 at 11:13 am
You're welcome. Thanks for the feedback.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply