SQL Server 2000 - Login Password Change causing access problems

Posted on 2007-10-05
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
    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

    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

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    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.
    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.
    Viewers will learn how the fundamental information of how to create a table.

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now