Preparing the SCCM SQL Database
 |
The SoftwareCentral installer will grant these permissions when running the SCCM check. If the installer is unable to grant these permissions, you may do it manually as follows: |
SoftwareCentral needs to be able to query the SCCM’s SQL database directly and therefor needs read and execute permissions on the database. SoftwareCentral uses a SQL login for this operation.
To create the SQL login start the Microsoft SQL Server Management Studio.
|
Locate the Security folder. Right-click security and choose “New Login…” from the context-menu.
|
|
|
Click Search and find the SCCM_SWC_ADMIN account created in section 1. Make sure you selected “Windows authentication”. Make sure that the default language for the login is set to English and press OK.
|
|
|
Locate the SCCM’s database. The name will start with “CM_”
|
|
|
Assign “db_datareader” to the SCCM_SWC_ADMIN account
|
|
|
Right-Click the SCCM database and choose “Properties” from the context-menu.
|
|
|
Choose Permissions and grant the SCCM_SWC_ADMIN database user Execute permissions on the SCCM database and click OK.
|
|
