PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
8 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL and the SA password
Posted on 2016-07-21
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
Thanks,
Jim
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
yes, the information has to be there somewhere.
wich application?
any ini files or other config files in the app folder? registry entries?
wich application?
any ini files or other config files in the app folder? registry entries?
The software is ManagerPlus a maintenance database. So far no luck looking through the ini and config files.
Active today
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.
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Course of the Month8 days, 13 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.