Link to home
Avatar of James Lipko
James Lipko

asked on

SQL and the SA password

I had forgotten my SA password so I changed it.  Since then the third party database does not open and displays a message that it can no longer connect to the database.  Apparently the software uses the SA account to connect to the database.  I do not have maintenance on the software so the company wants $ to tell me how I can connect using a different user, or change the SA password so the software can connect.  I am wondering if this is a generic connection issue and can be solved by changing the password in an ini file.  The connecting information has to be somewhere, right?  
Thanks,
Jim
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

yes, the information has to be there somewhere.
wich application?
any ini files or other config files in the app folder? registry entries?
Avatar of James Lipko
James Lipko

ASKER

The software is ManagerPlus a maintenance database.  So far no luck looking through the ini and config files.
Often, if the connection string is not in the ini files, launching of the app with the correct argument might be required. Check the registry to see if those credentials are therein.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
After looking at every file imaginable on the PC, I turned to the original install document, and there was the suggested sa password.  I put it in and Bingo I was in the database, hopefully this can help someone else in the future.  Thanks for the reply's!