Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL is not working when i chage windows Password

Author  Topic 

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-07-26 : 05:38:25
Hi there.

if i change the windows (i am using Win2000 Advanced server) password , SQL server is not working. But i want to change windows password due admin purposes but at the same time sql should work without changing sql password. what i will do.

Please anyone can help me in this regards....

Thanx a lot

by
yasi

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-26 : 05:40:06
Do you have any errors to report here?

Franco
Go to Top of Page

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-07-26 : 05:53:42
Hello Franco

After changing Windows password, sql server is not working due to logon failure.
error is logon failure.
Thanx in advance
by
yasi
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-26 : 06:02:08
If you use Mixed mode authentication and you change your password at the Windows level you don't have to end up in logon failure.
Please check if you use mixed mode authentication.


Franco
Go to Top of Page

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-07-26 : 06:04:37
Hi Franco
yes. I used Mixed Mode authentication only in all SQL server.

thanx in advance

by
yasi
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-26 : 06:08:15
Is your Windows User correctly coded on the SQL Server box under security?

Franco
Go to Top of Page

dragan
Starting Member

17 Posts

Posted - 2005-07-26 : 08:14:20
Yasin,

Why not use SQL authentication?
R-click your server in Enterprise Manager, Edit SQL server registration properties. In there select 'Use SQL server authentication'.

Later
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-26 : 08:19:12
dragan read yasin's first post.

Franco
Go to Top of Page

dragan
Starting Member

17 Posts

Posted - 2005-07-26 : 08:30:48
What I understood was that when he changes the OS admin password, SQL stops working. Then when you asked him about Mixed mode authentication I assumed the problem was actually authentication.

Perhaps I misunderstood. In that case, sorry ...

Later
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-26 : 08:35:33
No problem dragan, I think he just need to change Windows password due to some admin purpose like he said.
Strange thing is that he has logon failure.

Franco
Go to Top of Page

dragan
Starting Member

17 Posts

Posted - 2005-07-26 : 08:39:35
But now, is he experiencing SQL or OS logon failure or is his problem fixed?
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-07-26 : 08:41:16
What account is the sql service running as? It is probably the same account for the password you just changed. Update the service to use the new password for that account and re-start it.

- Jeff
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-26 : 08:41:51
For what I know he still experiencing OS logon failure, so it's not fixed.

Franco
Go to Top of Page

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-07-26 : 09:46:45
Hello Fraco
Still i have the same prob. Any soln.
thanx
by
yasi
Go to Top of Page

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-07-26 : 09:48:36
Hi all
I tried using windows authentication mode also, but still not yet.

thanx

by
yasi
Go to Top of Page

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-07-26 : 09:48:41
Hi all
I tried using windows authentication mode also, but still not yet.

thanx

by
yasi
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-26 : 10:37:44
Let's say this:
In my environment there is a domain account(DOMAIN\SQL-Service)that I use for SQL Server service. This also is a Windows account.
As jsmith8858 said if you change the password of this particular account and you use this account to login, you need to restart SQL Server in order to be able to login to the Server.
Otherwise if you use another Windows account and this account is coded on the SQL Server box, then you can change the password and still be able to login.
Can you please explain what is your situation with more detail?

Franco
Go to Top of Page

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-07-26 : 13:42:46
Hello franco

Here i use sql account. Now I want to change windows password, If it is , sql server is encounts an error as follows "Service didnot start due to log on failure" when i restart the server.

thanx in advance

by
yasin
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-07-26 : 14:02:38
Yasin,

Go to Administrative Tools..Services. Double click MSSQLSERVER service and go to log on tab. Do you see the account? You need to change the pwd in there when you change its password in Windows. You should also do this for the SQLSERVERAGENT service.

BTW, you should be using a domain account that has local admin privileges for both of these services. The password should never expire. It should not be an account that anyone uses. It should only be used for these services. When you need to change its password, you'll need to update these services and restart them.

Tara
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-07-26 : 15:04:21
I wonder how many more times we will have to repeat this until it sinks in ....

- Jeff
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-27 : 02:30:06
patience....

Franco
Go to Top of Page
    Next Page

- Advertisement -