Post reply

Linked Server connection failure with DB Mirroring

  • December 24, 2015 at 8:08 pm

    #323530

    Here is my issue

    Principal Server:-ServerA

    Mirror Server:-ServerB

    ClientServer:-ServerC

    Linked server is configured to connect a Database named DB1 with server and failover partner configured as

    ServerA and Server B respectively.

    EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServer',@srvproduct=N'', @provider=N'SQLNCLI10', @provstr=N'Server=ServerA;FailoverPartner=ServerB;Network=dbmssocn', @catalog=N'DB1'

    Linked server connection fails and not recognizing the mirror server ( after failover)

    though failoverpartner param set.

    After Recycling Client SQLServer,linked server is able to connect the mirror server.

    Is this related to provider cache(SQLNCLI10)?

  • December 27, 2015 at 12:38 pm

    #1848187

    Hard to say without the complete verbatim error message. Connection failures go through Winsock, and if it raises an error (such as Network Name Not Found) the problem does not concern the provider.

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

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