[Last Call] Learn how to a build a cloud-first strategyRegister Now


SQL Server 2000 - Login Password Change causing access problems

Posted on 2007-10-05
Medium Priority
Last Modified: 2008-01-09
Hi Experts,
I hope one of you can help with this problem.
I changed the password for a Login ('DBAgent') in SQL Server 2000 under Security - Logins. I can now access the databases related to the Login in Query Analyzer by supplying  the Login name and new password, but when i try to login (using my unchanged database username and password) via a custom front end app, i get the following error:

Error handler: -2147217843 Login failed for user 'DBAgent'

I'm afraid I'm new to SQL Server and don't understand how SQL Server Logins are related to database users, so have no idea how to fix this problem..Can anyone point me in the right direction please?

Thanks in advance for any advice,

Question by:Triona
LVL 11

Assisted Solution

by:Goodangel Matope
Goodangel Matope earned 180 total points
ID: 20020463
how is your front end application connecting to the database? Is it using a datalink? You also need to make sure that it is using the same authentication (SQL Server Authentication) that you use when you log on using query analyzer.

Author Comment

ID: 20020736
There's the crux..i just have an exe for the front end. It was developed before my time in the company by someone who is no longer around. Can't find any documentation on it. I know nothing about it.
So, it sounds like i need to try to hunt down the developer rather look for a solution within SQL server? Not good!
LVL 27

Accepted Solution

ptjcb earned 195 total points
ID: 20021706
Yes, sorry, but you need to find the developer. He or she may have hard-coded the password into the application. I would not be surprised.

The app may be using a INI file. You might search the hard drive for that and see what was saved. If the DBAgent password is kept there, then it would be easy to change it. But that is a best case scenario.


Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

829 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