replication server name problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » replication server name problem

replication server name problem

Rate Topic

Display Mode

Topic Options

Author

Message

spin

Posted Thursday, February 28, 2013 4:24 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 2:11 PM
Points: 80, Visits: 274

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

opc.three

Posted Thursday, February 28, 2013 9:31 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:56 PM
Points: 6,718, Visits: 11,753

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1425116

spin

Posted Thursday, February 28, 2013 9:57 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 2:11 PM
Points: 80, Visits: 274

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

opc.three

Posted Thursday, February 28, 2013 10:00 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:56 PM
Points: 6,718, Visits: 11,753

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1425155

spin

Posted Thursday, February 28, 2013 10:06 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 2:11 PM
Points: 80, Visits: 274

brilliant. and the replication is now working perfectly. thanks

Post #1425161

opc.three

Posted Thursday, February 28, 2013 11:13 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:56 PM
Points: 6,718, Visits: 11,753

You're welcome. Thanks for the feedback.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1425214

« Prev Topic | Next Topic »

Permissions