SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


2008 distributor and 2005 publisher (Transactional Replication)


2008 distributor and 2005 publisher (Transactional Replication)

Author
Message
Dpac
Dpac
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 129
Hi,

I have configured distributor on Sql server 2008 and I'm trying to create a a publication on a server ( sql server 2005). I get the following error when i try to create a publication through the sql server 2008 ssms .

SQL Server could not connect to the Distributor using the specified password.

Connection to server [Serv1] failed.

OLE DB provider "SQLNCLI" for linked server "8xxxxxxxxA-Bxxx-xxxx-xxxx-xxxxxxxxx" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "8xxxxxxxxA-xxxx-xxxx-xxxxx-xxxxxxxxxxx" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

The sql server versions are :

9.00.1399.06 RTM
Enterprise Edition (64-bit) (Sql server 2005) publisher

9.00.3042.00 SP2
Developer Edition (64-bit) (Sql server 2005)- publisher

10.50.1600.1 RTM
Standard Edition (64-bit) (sql server 2008)- Distributor
Any pointers would be greatly appreciated.
Thanks,
Leo
nvkumar12
nvkumar12
SSC Veteran
SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)

Group: General Forum Members
Points: 215 Visits: 184
from the above mentioned publisher,which version of 2005 are you using. is it Dev or Enterprise.
Suresh B.
Suresh B.
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12030 Visits: 5330
Dpac (12/8/2011)
...this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

Check whether remote connection is enabled or not.
Divine Flame
Divine Flame
SSCrazy Eights
SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)

Group: General Forum Members
Points: 9277 Visits: 2818
Dpac (12/8/2011)
Hi,

SQL Server could not connect to the Distributor using the specified password.

Connection to server [RS02] failed.

OLE DB provider "SQLNCLI" for linked server "8xxxxxxxxA-Bxxx-xxxx-xxxx-xxxxxxxxx" returned message "Login timeout expired".


Try adding a host file entry in the publisher for distributor server. Likewise add a host file entry in distributor server for publisher server. That may resolve your issue.

P.S. I am assuming that you are providing the correct password which you have set during the replication configuration.


Sujeet Singh
Dpac
Dpac
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 129
I had to create an alias to the distributor on the publisher to solve the issue. Thanks
Divine Flame
Divine Flame
SSCrazy Eights
SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)SSCrazy Eights (9.3K reputation)

Group: General Forum Members
Points: 9277 Visits: 2818
Glad to hear this :-)


Sujeet Singh
Suresh B.
Suresh B.
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12030 Visits: 5330
Dpac (12/12/2011)
I had to create an alias to the distributor on the publisher to solve the issue. Thanks

Thanks for posting the solution. It will help others.
DBASnoozer
DBASnoozer
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 205
I'm having the same issue. Can you explain how you created an alias?

Thanks.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search