Solved

SQL and the SA password

Posted on 2016-07-21
5
39 Views
Last Modified: 2016-08-01
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
Comment
Question by:jatpahut
  • 2
  • 2
5 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41723591
yes, the information has to be there somewhere.
wich application?
any ini files or other config files in the app folder? registry entries?
1
 

Author Comment

by:jatpahut
ID: 41723645
The software is ManagerPlus a maintenance database.  So far no luck looking through the ini and config files.
0
 
LVL 77

Expert Comment

by:arnold
ID: 41724054
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
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 41724210
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
 

Author Comment

by:jatpahut
ID: 41737544
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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL: Episode III - Revenge of The Dude 24 53
query execution hang 5 29
SQL Server Designer 19 40
SQL Server 2015 Restore - doing it right 2 13
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question