SSMS connection credentials - password change

  • Thank you for reading this:

    I was logged into an instance in another domain executing SSMS with Run As ... with the correct credentials.  Later, I RPC'd to a computer in that same domain where I was told my password was expiring tomorrow, so I changed it.  I had not disconnected my authenticated session from my laptop SSMS session.  I did disconnect, but now, when I try to execute SSMS with those credentials, it fails saying username/pwd incorrect. If I use my old pwd, SSMS will launch, but the pwd is incorrect when trying to establish a connection to a server in that domain.

    • There is no entry in Windows Credential
    • I had directory services check the SPN
    • I have uninstalled/reinstall SSMS

    Thoughts?  TIA

  • My guess is that the domain controller your system is using hasn't been updated yet - so it has the old credentials, but the SQL Server instance you are trying to access is connected to a different domain controller that has been updated.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • I forgot to mention I did this two weeks ago and I have been on PTO since figuring the updates to the SPN and everything else should be propagated by now.

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

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