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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-27 : 08:18:51
|
| Brian writes "I am trying to run the SQL services (SQL2000 sp3) with a local "user" account. Windows 2000 is running in standalone mode . The only way I can get the "server" service to start is by making the "user" a memebr of the local "administrators group". The "agent service" starts under either scenario.(encounterd an unexpected error while checking the sector size for tempdb.mdf; create database failed some file names listed coul;d not be created; warning problem creating all tempdb files)I am new to SQL and could be asking a bad question but, several articles state that you should run the services under the same account and make that account a "user account" and not a member of the "administrator group" If this step is not needed, I can leave the services running under an administrator account.Thank you for any assistance in pointing me in the right direction" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-27 : 12:03:43
|
| The SQL Server service should be configured to run using a domain account if the server will ever need to talk to another SQL Server or configured with a local account. Either way, the account should be an administrator on the machine. But the service should still be able to start with a regular user account. If you want to go this route, then you will need to give the account the appropriate permissions. I am not sure what the appropriate permissions are as this is not the recommended approach. You will need to have a look at MS' knowledge base to figure this one out. |
 |
|
|
|
|
|
SQL service fails;error problem activating all tempdb