Changing NT password causes SQLServer to fail

[sheilaM99]

I'm running SQLServer on an NT 4.0 workstation using NT authentication. Today my NT password expired, so I changed it, and now SQLServer won't start because of a bad password. Is this password stored somewhere? How can I force SQLServer to accept the new NT password?

Thx,
Sheila

 

[Bernadette]

Hi There Shelia

Here is an idea of what could be causing your problem .. Check what account the SQL Server service is running under. If you have a login as say "SQLAdministrator", and you have changed the NT password on it and the SQL Server service is running under that account, it wont start.

1. Right-Click on your SQL Server
2. Select Properties
3. Select the Security tab
4. Under Startup Service Acccount Check that
the account the server is running under has the right
password (if it is not running under the System Account)

Once the startup account has the correct password, it should start ok. If this is the case you may want to check the other services like SQL Agent as well.
Hope This Helps
Bernadette

 

[JNC73]

Hi Sheila,

It might be that you use an account in SQL*Server which doesn't use the trusted connection. If you use trusted connection when you change your NT password the SQL*Server login uses imidiatly the changed password.

If trusted connection isn't used your old password is still active for SQL*Server. Change this to Trusted Connection.

JNC73