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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2006-03-21 : 07:12:51
|
| What Server Roles should has Windows user which I want to use to start SQL Server (cluster). With minimum permissions. |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-03-21 : 08:18:02
|
| Use a dedicated Domain service account if you want to authenticate against any member server in the domain else use a dedicated local account but you will need the following:1) Grant the account logon as a service right.2) Give the service permission to read and modify sql server files.3) Alter the registry to access several registry keys.4) Give the account permission to modify .mdf .ndf and .ldf filesElse the easier way is to grant this account local administrator rights to this server. |
 |
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2006-03-21 : 09:11:01
|
| I asked what Server roles I must give to this account. Of course it is dedicated domain service account. But I don't want to give to this account sysadmin rights. |
|
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-03-21 : 09:17:39
|
| dunno; perhaps I would help further if you had a better attitude.but can't be bothered now. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-21 : 09:53:11
|
SA  --------------------keeping it simple... |
|
|
|
|
|
|
User to start SQL Server