SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL is not working when i chage windows Password
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

yasin
Yak Posting Veteran

India
68 Posts

Posted - 07/26/2005 :  05:38:25  Show Profile  Send yasin an AOL message  Reply with Quote
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

Switzerland
255 Posts

Posted - 07/26/2005 :  05:40:06  Show Profile  Reply with Quote
Do you have any errors to report here?

Franco
Go to Top of Page

yasin
Yak Posting Veteran

India
68 Posts

Posted - 07/26/2005 :  05:53:42  Show Profile  Send yasin an AOL message  Reply with Quote
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

Switzerland
255 Posts

Posted - 07/26/2005 :  06:02:08  Show Profile  Reply with Quote
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

India
68 Posts

Posted - 07/26/2005 :  06:04:37  Show Profile  Send yasin an AOL message  Reply with Quote
Hi Franco
yes. I used Mixed Mode authentication only in all SQL server.

thanx in advance

by
yasi

Edited by - yasin on 07/26/2005 06:05:41
Go to Top of Page

franco
Constraint Violating Yak Guru

Switzerland
255 Posts

Posted - 07/26/2005 :  06:08:15  Show Profile  Reply with Quote
Is your Windows User correctly coded on the SQL Server box under security?

Franco

Edited by - franco on 07/26/2005 06:09:40
Go to Top of Page

dragan
Starting Member

South Africa
17 Posts

Posted - 07/26/2005 :  08:14:20  Show Profile  Reply with Quote
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

Switzerland
255 Posts

Posted - 07/26/2005 :  08:19:12  Show Profile  Reply with Quote
dragan read yasin's first post.

Franco

Edited by - franco on 07/26/2005 08:19:31
Go to Top of Page

dragan
Starting Member

South Africa
17 Posts

Posted - 07/26/2005 :  08:30:48  Show Profile  Reply with Quote
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

Switzerland
255 Posts

Posted - 07/26/2005 :  08:35:33  Show Profile  Reply with Quote
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

South Africa
17 Posts

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

jsmith8858
Dr. Cross Join

USA
7423 Posts

Posted - 07/26/2005 :  08:41:16  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
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

Switzerland
255 Posts

Posted - 07/26/2005 :  08:41:51  Show Profile  Reply with Quote
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

India
68 Posts

Posted - 07/26/2005 :  09:46:45  Show Profile  Send yasin an AOL message  Reply with Quote
Hello Fraco
Still i have the same prob. Any soln.
thanx
by
yasi
Go to Top of Page

yasin
Yak Posting Veteran

India
68 Posts

Posted - 07/26/2005 :  09:48:36  Show Profile  Send yasin an AOL message  Reply with Quote
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

India
68 Posts

Posted - 07/26/2005 :  09:48:41  Show Profile  Send yasin an AOL message  Reply with Quote
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

Switzerland
255 Posts

Posted - 07/26/2005 :  10:37:44  Show Profile  Reply with Quote
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

India
68 Posts

Posted - 07/26/2005 :  13:42:46  Show Profile  Send yasin an AOL message  Reply with Quote
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

USA
37133 Posts

Posted - 07/26/2005 :  14:02:38  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
7423 Posts

Posted - 07/26/2005 :  15:04:21  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
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

Switzerland
255 Posts

Posted - 07/27/2005 :  02:30:06  Show Profile  Reply with Quote
patience....

Franco
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000