SQL Server 2000 - Login Password Change causing access problems
Posted on 2007-10-05
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,