Transactional replication with remote distributor

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Transactional replication with remote distributor

Author

Topic

leoroy
Starting Member

3 Posts

Posted - 2011-12-12 : 12:23:18

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

44 Posts

Posted - 2012-01-11 : 12:50:57

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources