I am doing work for a client who uses SQL Server 2000. I told them I need to log into the server as the Windows user the SQL Service is running as so that I can set up some drive mappings and such that they need the server to have. However, they informed me they lost the password and have no idea what it might be. Even spending an hour guessing brought them no closer to the password.
I've never had to change the password for the SQL Service User and if I have them do this I want to make sure there isn't anything special or out of the ordinary that needs to happen. Do I just have them change the password, and then in Enterprise Manager... right click on the server, go to Properties and then go to the security tab and change the password to the new one there? Then do the same thing for the SQL Agent?
It just seems all too straightforward for me.
What am I missing?
Thanks!
Craig
I've never had to change the password for the SQL Service User and if I have them do this I want to make sure there isn't anything special or out of the ordinary that needs to happen. Do I just have them change the password, and then in Enterprise Manager... right click on the server, go to Properties and then go to the security tab and change the password to the new one there? Then do the same thing for the SQL Agent?
It just seems all too straightforward for me.
What am I missing?
Thanks!
Craig