Issues when create linked servers

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

General SQL Server Forums

New to SQL Server Programming

Issues when create linked servers

Author

Topic

yang_xdx
Starting Member

3 Posts

Posted - 2009-05-14 : 13:43:53

I install two 2005 instance in one PC(assume named A,B. ). Now, I created a linked servers from A to B and all connect using user 'sa' to connect to B(I have enabled user 'sa' in B). But when I excute a query like 'select * from B.DB_name.DBO.Table_name', there's will be an error message
"OLE DB provider "SQLNCLI" for linked server "localhost" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "localhost" 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.".
Msg 2, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [2]. "

The the instance configurations are following:
server: windows xp pro sp4
db: sql server 2005 Enterprise Evaluation Edition. All log on as 'Built-in account and using Local System'. All enable "shared Memory" and "Named Pipes" protocol.(I tried to enable "TCP/IP and VIA" protocol but after that, I can not start up database.)
If you need furthure information, I will pleasure to provide.

All reply will be appreciate

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-14 : 14:07:13

have you enabled remote connections options from surface configuration manager?