Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 60
  • Last Modified:

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
0
James Lipko
Asked:
James Lipko
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, the information has to be there somewhere.
wich application?
any ini files or other config files in the app folder? registry entries?
1
 
James LipkoAuthor Commented:
The software is ManagerPlus a maintenance database.  So far no luck looking through the ini and config files.
0
 
arnoldCommented:
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.
1
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
From here
http://www.managerplus.com/support/faq

What is the connections file and where is it found?
The connections file holds the information for the client computer to connect to the server.
The connections file is normally found in the user’s appdata folder.
Start > Run > %appdata% > click OK > ManagerPlus
The connections file can also be moved into the installation directory (for example:    C:\Program Files\ManagerPlus ) so that it will be computer specific instead of windows user profile specific.
1
 
James LipkoAuthor Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now