Link to home
Create AccountLog in
Avatar of actmanre
actmanre

asked on

Administrator Password Change

I changed the windows administrator user password and now the ODBC connections to our sql server do not work.
ASKER CERTIFIED SOLUTION
Avatar of lasmith05
lasmith05
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
looks like its the administrator sccoount that is running windows.

go to services,look for the sql server service and change the password.

Under "Administrative Tools" you may need to go into "Services" and sort by the column "Log On As". If any of them have "Administrator" listed then you will need to go into that service and type in the new password and try starting the service. If this is the issue, you can create another local user with administrative privileges and use that for the services that need to be started by an admin account. Hope this helps.
Avatar of actmanre
actmanre

ASKER

"You must change the MSSQLServer service account in SQL Server Enterprise Manager for the Microsoft Search service to stay synchronized."

How do I do this?
I meant -it looks like its your Administrator account that is running SQL Server.

After changing the administrators password -you'll need to change the password in the SQL Server service account settings.

SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
When I go into the 'Log on' tab there is a password already, but it shows 15 characters, where as the old admin password was only 10 characters. I am wondering why they look different. Could there be two separate passwords, even though changing the one separate windows admin password affected the sql server access? If i change the password for all 3 services to the new password I have for the windows admin, is anything else required?