August 22, 2002 at 6:37 am
Hello everyone,
I am running SQL 2000 using Windows Authentication. For security reasons, I would like to change the password on SQL. Can I easily do this in Active Directory on the PDC? Will SQL work with the new password, or is there something else that I need to do inside of SQL. This type of things always gives me problems on trying to figure out the logons. Is there anything that I can read to further assist me with things like this? I have ready the BOL, but it still seems a little confusing to me.
Thanks so much for all your help today. Have a good one.
Andrew
How long a minute is....
Depends on what side of the bathroom door you are on.
How long a minute is....
Depends on what side of the bathroom door you are on.
August 22, 2002 at 8:42 am
If I understood you correctly, you want to change the password of the domain user that SQL is running as. After you've changed the password, just make sure to update the password SQL uses either in SQLEM->Actual server->Properties->Security tab->Startup SQL in this account, or in Services in Administrative Tools (Control panel). Remember to change SQL Agent as well if it is running as the same user.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
August 22, 2002 at 9:01 am
Chris is right if that's what you mean. If you are changing a user's access password, you don't do anything in SQL.
BTW, this is why I use separate accounts for each SQL Server. HAte to have things start failing because I missed a pwd.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply