Login failed for SQL logins

  • This is a long shot , but have you tried restarting the sql server services.

    Jayanth Kurup[/url]

  • Hi,

    Recently , i faced similar issue.

    If i have understood your problem clearly...u might have faced error message "login failed for so and so credentials"

    The solution that i could tell you is...login to ssms as admin and under login tab add user details who is facing problem while login.

    then exit ssms and login with user credentials.

    This should work.

  • You may also want to start a sqlprofiler trace on your sqlinstance capturing all login info an all oledb errors to get more detail on what's going wrong.

    ( keep it short to not disrupt ongoing operations to much on your server )

    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 - 16 through 17 (of 17 total)

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