Steps to Create a user permissions to access the SCCM database in Microsoft SQL Server
Step-1: Create a SQL Login
- In SQL Server Management Studio, expand Security
- Right-click Logins → New Login…
- Create a User and Enter Password
- Ensure SQL Authentication is selected
- Set Default Language = English
- Click OK
Step-2: Create a Database User for the SCCM Database
- Expand Databases
- Locate the SCCM database (name begins with CM_)
- Expand Security → Users
- Right-click Users → New User
- Add the user which we created in the step1.
Step-3: Grant Execute Permission.
- Right-click the CM_* SCCM database → Properties
- Select Permissions
- Choose the User you have Created.
- Enable the Execute permission
- Click OK.
Step-4: Add Roles to the User.
- Go to Databases → CM_* SCCM database → Security → Users
- Right Click on the user and select Properties.
- Select Membership
- Select db_datareader
Step-5: Validate user mapping and assigned database roles.
- Security → Logins
- Right Click on the user
- Select User Mapping.
- Confirm the user having the roles.
IN Servicenow:
