application not connecting to secondary

  •  

    Hi

    the application which  has the connection string of the listener configured connects to node S01  but when failed over to S02  it  does not connect

    there are no applicable error in the SQL logs and windows logs

    please let me know

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • What is the actual error message ?

    Do you have monitoring for succeeded and failed connections ( in this case especially on S2 ) ?

    When using a SQLUser, how did you create that use on both instances ?

    ( should be "create on S1" and then copy ( including SID ) to S2 ) ( I use DBATools to copy such accounts )

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

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

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