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.
Author |
Topic |
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2010-02-21 : 03:48:12
|
Im trying to connect another server using linked server option but when i try to coneect it gives the following error...OLE DB provider "SQLNCLI" for linked server "abcd" returned message "Login timeout expired".OLE DB provider "SQLNCLI" for linked server "abcd" 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 53, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [53]. OLE DB provider "SQLNCLI" for linked server "abcd" returned message "Invalid connection string attribute".Please help.. |
|
Kristen
Test
22859 Posts |
Posted - 2010-02-21 : 04:06:08
|
" SQL Server does not allow remote connections"In SSMS Right click the server, choose Properties, find "Connections" and check the "Allow remote connections" option" Named Pipes Provider"I recommend that you use TCP/IP and not Named Pipes |
|
|
|
|
|