Learn how to Add SCCM Server Computer Account to SQL Login. Also, this post might help you to learn how to add Sys Admin Access to a ConfigMgr server computer account.
To complete this activity, the user account should have sysadmin access to SQL DB. More details are available in the following sections. More details about ConfigMgr primary server and Secondary server installation details are available in the following posts.
- New ConfigMgr Primary Server Installation Step by Step Guide | SCCM
- SCCM Secondary Server Installation Guide | Step by Step | ConfigMgr
Add Computer Account to SQL Login
- Launch SQL Management Studio.
- Right-Click on the login folder.
- Click on New Login.
- Enter the login name from the General tab.
- Enter the SCCM server name details with $ symbol
- Domain\SCCMServer_Name$ => MEMCM\CMMEMCM$
NOTE! – The search option shall not work in the SQL management studio.
Add Sys Admin Role to Server Computer Account
- Launch SQL Management Studio.
- Right-Click on the computer account.
- Select Properties.
- Click on Server Roles
- Select the Server role is used to grant server-wide security privileges to a user (in this case SCCM server computer account).
- Select the check-mark for Sys Admin.
- Click OK to complete the task.
Results
As you can see, the SCCM server account is available in SQL management studio.
Resources
- SQL Server-Level Roles
Is there a way to set SCCM up with a separate SQL using a network account rather than the SCCM Server Computer account?
Can you elaborate a bit … what is the concern with the system account? The SPN is also needed for this connectivity … from a security perspective it’s more secure than the service accounts?