Accessing two SQL servers in C# application

• rajeev_vandakar-782919

  SSC Eights!

  Points: 871

  More actions

  September 2, 2010 at 5:22 am

  #144951

  Hi all,

  we want to connect two different SQL servers in our application (in C#). With Linked server, unless we manually run some query (like SELECT * ....) in T-SQL query browser the linked server will not get initiated and can't be used in application. And with OPENDATASOURCE method, it works fine only if we use system IP address (TCP/IP). With system name (Named pipe if am not wrong) this method some time fails as follows:

  ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [5].

  ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".

  ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "SQLNCLI" for linked server "(null)" 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.".

  what me be wrong here? Any suggestions please.

  __

  Rajeev

  Bengaluru - 40.