Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

replication server name problem Expand / Collapse
Author
Message
Posted Thursday, February 28, 2013 4:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:25 AM
Points: 116, Visits: 402
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
Post #1424984
Posted Thursday, February 28, 2013 9:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:52 PM
Points: 7,079, Visits: 12,569
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
Post #1425116
Posted Thursday, February 28, 2013 9:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:25 AM
Points: 116, Visits: 402
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)

???
Post #1425154
Posted Thursday, February 28, 2013 10:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:52 PM
Points: 7,079, Visits: 12,569
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
Post #1425155
Posted Thursday, February 28, 2013 10:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:25 AM
Points: 116, Visits: 402
brilliant. and the replication is now working perfectly. thanks
Post #1425161
Posted Thursday, February 28, 2013 11:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:52 PM
Points: 7,079, Visits: 12,569
You're welcome. Thanks for the feedback.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1425214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse