Posted - 12/12/2011 : 12:23:18
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 :
Enterprise Edition (64-bit) (Sql server 2005) publisher
Developer Edition (64-bit) (Sql server 2005)- publisher
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?