Post reply

Linked Server Problem

  • October 9, 2009 at 3:51 am

    #142406

    Respected All

    I am getting error when creating linked server

    OLE DB provider "SQLNCLI" for linked server "BLRBR" returned message "Login timeout expired".

    OLE DB provider "SQLNCLI" for linked server "BLRBR" 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 10061, Level 16, State 1, Line 0

    TCP Provider: No connection could be made because the target machine actively refused it.

    Remote server to which i am creating linked server is sql server 2005 express edition

    and server from where i am creating linked server is sql server 2005 64 bit standard edition

    I have checked that firewall is off , sql server browser is running because i am using dynamic port and "allow remote connection to this server " is checked.

    TCP port is enabled.

    I tried a lot on google but did not get any solution ,Why this error is coming.

    Can somebody tell me what is the actual cause , where i am doing mistake

    Thanks

    Ghanshyam

  • October 9, 2009 at 5:00 am

    #1063968

    Did you check the network connections between your servers and are you able to ping to the remote server ? Did you try with assigning a staic port to the remote server? if it is not the default 1433 then you need to specify the port number too in the Datasource parameter of sp_addlinkedserver proc.

    ..

  • October 9, 2009 at 5:12 am

    #1063970

    I have checked with ping command and both are connection

    I also use port no like this 122.45.34.12\sqlexpress,4567 in sp_addlinkedserver

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply