Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tocroi72
Yak Posting Veteran
89 Posts |
 Posted - 2004-08-06 : 09:38:20
|
| Hi all,I changed my window logon password and therefore my SQL doesn't start because i used window login instead of the SQL login. Please advise me how to change setting in the SQL server so it recognize my new password. Thanks |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-08-06 : 10:05:16
|
| If you are just talking about a logon password then changing your NT password should not break SQL server. If you're talking about the service logon password, then go to tools -- admin -- services, find the SQL SERVER service and change the password in there.-------Moo. :) |
 |
|
|
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2004-08-06 : 10:09:38
|
| Somehow i changed the window logon password and it broke the sql connection. Anyway, i found answer on microsoft website. All i have to do after changing the password is go to Control pannel - services- MSSQLServer - change the password in there also.Thanks for the response. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-06 : 13:08:53
|
| Make sure you change it for any other service using that account also.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Window authentication - Change Password