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 |
|
schuhtl
Posting Yak Master
102 Posts |
 Posted - 2004-12-10 : 11:39:13
|
| About a month ago I had a server go down and we had to start over from scratch. The on-call dba at the time did not restore the master database and did not configure sql server 2000 to run under a domain account like he should have. Once I relieved the on-call dba I just created new logins and granted the correct permissions to the new logins. I also tried to change the service account from the local system to a domain account but when I did all of the user databases showed as SUSPECT? Since there were no jobs/packages that needed to domain privileges at the time I just changed the service account back to the local system account and everything was fine with the user databases. I now need to correct the issue so what should try first? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-10 : 11:49:39
|
| Sounds like the domain account doesn't have permission on the directories that hold the database files.==========================================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. |
 |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2004-12-10 : 11:52:55
|
| The domain account is in the local admin group. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-10 : 11:55:27
|
| Does it say anything in the event log or sql server log?==========================================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. |
|
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2004-12-10 : 12:02:47
|
| I quickly looked through the logs and could not find any critical errors. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-13 : 02:06:10
|
| is the builtin/administrator group still existing on the security tab?the account you'll be using must already be added as user in the database and with sa privilege.delete the builtin/administrator group, then change the services account, restart the services.--------------------keeping it simple... |
|
|
|
|
|
|
Suspect database