Post reply

errors with linked server

  • May 13, 2008 at 8:09 am

    #125195

    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

    #814568

    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

    #814574

    sorry that is a fictious name, it is sql server 2005

  • May 13, 2008 at 10:03 am

    #814636

    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

    #814647

    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

    #814664

    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

    #814681

    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