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 lotbyyasi |
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-26 : 05:40:06
|
Do you have any errors to report here?Franco |
|
|
yasin
Yak Posting Veteran
68 Posts |
Posted - 2005-07-26 : 05:53:42
|
Hello FrancoAfter changing Windows password, sql server is not working due to logon failure.error is logon failure.Thanx in advancebyyasi |
|
|
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 |
|
|
yasin
Yak Posting Veteran
68 Posts |
Posted - 2005-07-26 : 06:04:37
|
Hi Francoyes. I used Mixed Mode authentication only in all SQL server.thanx in advancebyyasi |
|
|
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 |
|
|
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 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-26 : 08:19:12
|
dragan read yasin's first post.Franco |
|
|
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 |
|
|
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 |
|
|
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? |
|
|
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 |
|
|
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 |
|
|
yasin
Yak Posting Veteran
68 Posts |
Posted - 2005-07-26 : 09:46:45
|
Hello FracoStill i have the same prob. Any soln. thanxbyyasi |
|
|
yasin
Yak Posting Veteran
68 Posts |
Posted - 2005-07-26 : 09:48:36
|
Hi allI tried using windows authentication mode also, but still not yet.thanxbyyasi |
|
|
yasin
Yak Posting Veteran
68 Posts |
Posted - 2005-07-26 : 09:48:41
|
Hi allI tried using windows authentication mode also, but still not yet.thanxbyyasi |
|
|
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 |
|
|
yasin
Yak Posting Veteran
68 Posts |
Posted - 2005-07-26 : 13:42:46
|
Hello francoHere 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 advancebyyasin |
|
|
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 |
|
|
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 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-27 : 02:30:06
|
patience....Franco |
|
|
Next Page
|