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

2008 distributor and 2005 publisher (Transactional Replication) Expand / Collapse
Author
Message
Posted Thursday, December 8, 2011 9:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:16 AM
Points: 4, Visits: 122
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
Post #1218734
Posted Thursday, December 8, 2011 10:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 30, 2014 10:44 AM
Points: 23, Visits: 181
from the above mentioned publisher,which version of 2005 are you using. is it Dev or Enterprise.
Post #1219061
Posted Friday, December 9, 2011 1:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
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.
Post #1219117
Posted Friday, December 9, 2011 2:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 1,315, Visits: 2,527
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
Post #1219168
Posted Monday, December 12, 2011 2:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:16 AM
Points: 4, Visits: 122
I had to create an alias to the distributor on the publisher to solve the issue. Thanks
Post #1220480
Posted Monday, December 12, 2011 9:53 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 1,315, Visits: 2,527
Glad to hear this


Sujeet Singh
Post #1220582
Posted Monday, December 12, 2011 10:11 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
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.
Post #1220591
Posted Monday, July 22, 2013 6:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 4, 2014 4:57 PM
Points: 1, Visits: 119
I'm having the same issue. Can you explain how you created an alias?

Thanks.
Post #1476318
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse