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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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?
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.
After changing the administrators password -you'll need to change the password in the SQL Server service account settings.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
go to services,look for the sql server service and change the password.