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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-08-23 : 14:01:59
|
| GurusWhen i installed my sql server i configured it to run under a separate sqlservice account.Today i have checked that my that sqlservice account is disabled.How do i findout under which account my sql server service is running and when my account was changed?plz helpregardsNitin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-23 : 14:04:44
|
| To find out when your account changed, you'd have to talk to your server people. To see what the service is using, you can go to the Services applet in Admin Tools which is in Control Panel. You just go to the log on tab of the service to see the account. The account should be a domain account that is a member of the local admin group. It's password should never expire. The account should never be disabled.Tara Kizer |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-23 : 14:14:13
|
| TaraUnder the logon tab i can see my sqlservice account,but my account is disabled..is this possible?regardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-23 : 14:23:11
|
| Yes it's possible. You need to contact whoever is your account admin to get it enabled again. This isn't something that can be fixed in SQL Server.Tara Kizer |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-23 : 15:14:39
|
| TaraThe how come my sql server is running?if my account is disabled?RegardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-23 : 15:15:38
|
| Because SQL Server hasn't needed to use the account yet since it got disabled. It would have checked its status when it started. If you restart the service, you'll see the problem.Tara Kizer |
|
|
|
|
|
|
Sql server account