Various Microsoft Windows user groups are set up on the SCRM 2006 computer when SCRM 2006 is installed and on SMS data sources when they are added to SCRM 2006.
SCRM 2006 User Groups
During setup, the following local Windows user groups are created on the SCRM 2006 server:
- SC DW Administrators
- SC DW SMS DTS
- SC DW DTS
- SC DW Readers
- SC DW Viewers
 Note |
|---|
| If you are not a member of the local Administrators group, you must supply your own credentials when creating or changing a DTS job that synchronizes MOM data. |
When the MOM server and MOM operational database are installed on different computers, the local system account cannot be used to execute the MOM DTS job. In this case, you can use a domain account with sufficient privileges that is not the local system account. Alternatively, install the MOM server and the MOM operational database on the same computer.
The following table provides an overview of SCRM user groups and the tasks each user group can perform. These user groups are granted implied permissions to the System Center Data Warehouse by their membership to SQL roles on the SCRM 2006 server.
| Task | SC DW Administrators | SC DW SMS DTS | SC DW DTS | SC DW Viewers | SC DW Readers |
|---|---|---|---|---|---|
|
Add SMS data source |
Yes |
No |
No |
No |
No |
|
Add MOM data source |
Yes |
No |
No |
No |
No |
|
Schedule an SMS DTS job |
Yes |
Yes |
No |
No |
No |
|
Schedule a MOM DTS job |
Yes |
No |
Yes |
No |
No |
|
Schedule grooming jobs |
Yes |
No |
No |
No |
No |
|
View all Admin consoles |
Yes |
Yes |
Yes |
Yes |
No |
|
Execute stored procedures (Reporting) |
Yes |
No |
No |
No |
Yes |
SCRM 2006 DW Readers Account
The local account, SC DW Readers, is created during setup. The user performing the setup needs to supply a password for this account. After the account is created, it is added to the local SCRM user group SC DW Readers. When SQL Reporting Services is set up to use a single account to connect to the database, the SC DW Readers account can be used. Any other account in the SC DW Readers user group can also be used.
SMS Server User Groups
When an SMS data source is added, a user group SC DW SMS DTS is created on the SMS server that hosts the SMS data source. This user group has permission to read from the SMS database and permission to write back SMS data, such as watermark information.
MOM Server User Groups
The SCRM setup program does not need to create any user groups on MOM servers because SC DW DTS is created when MOM 2005 is installed.