You have a System Center 2012 Service Manager infrastructure that contains a single server named
Server1. You plan to use a new account named Service1 as the Operational Database Account. You
plan to configure Server1 to use a new account named Service1 as the logon account for the System
Center Data Access Service. You need to identify which roles must be assigned to Service1. Which
two roles should you identify? (Each correct answer presents part of the solution. Choose two.)
A.
the Microsoft SQL Server configsvc_users database role
B.
the Service Manager Advanced Operators User Role Profile
C.
the Service Manager Workflows User Role Profile
D.
the Service Manager Administrators User Role Profile
E.
the Microsoft SQL Server db_ddladmin fixed database role
F.
the Microsoft SQL Server sdk_users database role
Explanation:
If the user account for the Operational Database Account in System Center 2012 – Service
Manager changes, you must make the following changes:
• (D) Add the new account to the Service Manager Administrators user role for both the
Service Manager and data warehouse management servers
• (F) Create a SQL Server logon account for the new user on computers hosting
Service Manager databases. On the computer hosting the Service Manager database, assign the new
user to the skd_users (F) and configsvc_users roles.
• Make the new account a local administrator on the Service Manager computers.
• Make the new user account the logon account for the Service Manager Data Access Service
and Service Manager Management Configuration services, and then restart these services.
How to Change the User Credentials for the Operational Database Account