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 |
|
InfraDBA
Starting Member
38 Posts |
 Posted - 2010-12-18 : 18:53:10
|
| Hi all,sorry for the simplicity of this question but I want to know if the SQLServerMSSQLUser$ComputerName$MSSQLSERVER group has to be present there in SQL server login so as to enable sqlserverservice to run? |
|
|
InfraDBA
Starting Member
38 Posts |
Posted - 2010-12-19 : 04:25:36
|
| Please reply!!!!!I coundln't find much in BOL... |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-12-19 : 11:45:28
|
| When you installed SQL Server, did you use a domain user (recommended) - and is that domain user a part of the local administrators group (not recommended)?If the domain user is not a part of the local administrators group (recommended), then yes - you need those groups available for the service accounts running those services to have access to the instance.Jeff |
|
|
|
InfraDBA
Starting Member
38 Posts |
Posted - 2010-12-20 : 00:12:14
|
| let me if Ive understood your answer.If the service account is in local admin group then the group need not be there in SQL login.If the account is domain user and not in local admin group then the $groups should be present in SQl login.Please correct me. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-12-20 : 16:19:15
|
| Yes - that is correct. Basically, there is no reason to remove those groups from SQL Server. And, you really don't want to remove them from windows - since those groups also manage file access and rights.Jeff |
|
|
|
InfraDBA
Starting Member
38 Posts |
Posted - 2010-12-20 : 17:20:00
|
| Absolutely...It was just a doubt..Thanks...Highly appreciate it....:-) |
|
|
|
|
|
|
SQLServerMSSQLUser$ComputerName$MSSQLSERVER