May 13, 2008 at 8:09 am
hi guys i have a linked sql server but everytime i try to connect I get this error:
OLE DB provider "SQLNCLI" for linked server "Sql2008" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "SQl2008" 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 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
I added the same linked sql server to another server the exact same way and i get no errors, any idea why?
these are the steps i took
Server Objects
Linked servers, new linked server
sql server
Be made using the login's current security context.
May 13, 2008 at 9:04 am
Real basic question here:
It looks like you are trying to connect to 2008? If so, I assume it is a new installation? Did you run the surface are config to allow remote connections?
May 13, 2008 at 9:07 am
sorry that is a fictious name, it is sql server 2005
May 13, 2008 at 10:03 am
Please confirm if you have enabled remote connections for the destination server which you are trying to query. Also check if you have created proper aliases for connecting to the remote server from the source server. What is the Sql Server port number for both the source and destination servers..
[font="Verdana"]- Deepak[/font]
May 13, 2008 at 10:16 am
yes i have allowed remote connections to the destination server. can you tell me how to check for the port number? also, do you why then when i connect from other server with this destination server it does work?
I am using servername.master.dbo.sysprocesses
May 13, 2008 at 10:35 am
Are you able to connect to your destination server from your source server using SSMS or Query analyzer. You can check the port number in the Sql Server configuration manager > Sql Server protocols > double click TCP/IP and see the port number.
If its 1433 which is the default port its fine otherwise you need to create an alias in the destination server to connect to it from source server.
[font="Verdana"]- Deepak[/font]
May 13, 2008 at 11:10 am
Try setting up security with sql login on both server.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply