SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Transactional replication with remote distributor
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

leoroy
Starting Member

3 Posts

Posted - 12/12/2011 :  12:23:18  Show Profile  Reply with Quote
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 [RS02] 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

I did use sp_configure and made sure that the remote connections are enabled. Is there something that i'm missing here?

biswajitdas
Starting Member

USA
44 Posts

Posted - 01/11/2012 :  12:50:57  Show Profile  Reply with Quote
I think you got the resolution for this

"Ceate alias account to the distributor on the publisher to solve the issue"


Sr Sql server DBA/Artitech
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000