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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2002-11-21 : 09:23:50
|
| What would happen if I changed the password of the account that SQL Service runs under then did not stop and start the service until later? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-21 : 09:42:35
|
| The change won't take effect until the restart at which time you run the risk of everything not working.Commonly tested by a server crash combined with password expiry.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-21 : 12:39:06
|
| As long as you change the password in the service, you shouldn't have any problems. The only problem that I can think of is that when you change the password in the service, it doesn't check to see if the password is correct. So if you typed the password incorrect and your server crashes in the middle of the night, SQL Server will not start after the reboot. You should always stop and start the service after a password change just so that you know it is correct. |
|
|
|
|
|
|
Changing Services Password.