locked
LINKED SERVER problem with MSSQL server configured as HA RRS feed

  • Question

  • LINKED SERVER problem with MSSQL server configured as HA



    1. Configure the server to which the HA configuration is connected.

      I have a problem and have switched to Standby, but the LINKED SERVER is not functioning abnormally.





    I created it on the LINKED SERVER created by ATCIVE

    If you perform a connection test on STANDBY

    An error occurred while decrypting. (Microsoft SQL Server, Error: 15466).





    If you attempt to create a new one, an error will occur as shown below.

    Could not open database "XXX" requested from login. Login failed.

    User "sa" could not sign in. (Microsoft SQL Server, error: 4060)



    How do I use LINKED SERVER normally when HA configuration of MSSQL is done?



    DB server information 2008R2.
    Thursday, March 22, 2018 5:14 AM

All replies