We have a test environment that we hardly use but will be going forward.
I am trying to write some ODBC readers in Excel to extract data from the environment but the password I have written down is failing with "login failed for user test_dbo". Test_dbo is the correct user name.
Somewhat frustratingly, at some point in SSMS I must have told it to remember the password so that if I try to connect to the server I am logged right in! Except of course, I have no idea what the password is.
Is there a way to recover the password (I don't want to overwrite it in case there's a process somewhere that relies on it).