NT Account Password Change 1

[DrSql]

I have local SQL intsnace in my PC. It was runing with my NT UserID and password. Yesterday I changed the password and now instane topeed running and if I start the instance gives me an error, "Service did not start due to a logon failure". I forgot my SA password also, what would be my alternatae option.

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[SQLBill]

Change your NT password back to what it was when everything worked.

Apparently you have the MSSQLServer and SQLServerAgent services set to run using your login. This is a bad thing to do. Create a new login for the services; it could even be called something like sqlservices. Give that login any permissions needed for SQL Server to run.

Change the SA password.

Then lastly, change your NT password again.

-SQLBill

Posting advice: FAQ481-4875

 

[DrSql]

Thanks Bill directing me to answer. I ended up changing the password Logon on SQLService.

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.