An error occurred configuring SolarWinds Network Configuration Manager Database: The SELECT permission was denied on the object

Version 2

    Configuration Wizard Error while running NCM Configuration Wizard on Migrated DB .

     

    An error occurred configuring SolarWinds Network Configuration Manager Database:

    NCM Configuration Wizard Logs can be found under following default path.

     

    C:\ProgramData\Solarwinds\Cirrus\Logging\NcmConfigurationWizard.log

     

    ncmee.JPG

     

    ERROR ConfigurationProgressScene - Error while executing script - The SELECT permission was denied on the object 'Options', database 'ConfigMgmt', schema 'dbo'.

    The DELETE permission was denied on the object 'Options', database 'ConfigMgmt', schema 'dbo'..



    Resolution :

    Step # 1

    - Created Manual User Account for NCM Under SQL Server Security and User .

    - Connect to the SQL Server using SQL Studio Mgmt Console .

    - Expand up to Security > logins > Right Click Logins  > New Login > Select "SQL Server Authentication "  chose any " Password" for that user .

    (Uncheck  Enforce password policy  )

    - Select Your NCM Database under "Default database"

    Select "English" under "Default Language :

    Now click on User Mapping > (tick) your NCM DB >

    Click browse "Button" under "Default Schema" Click on Browse > select

    [dbo] > OK > OK

    Now tick "db_owner" under "database role membership for . (leave the public ticked as well )

    Click OK now the new NCM user is been created .

    ncm1.JPG

    ncm2.JPG

     

    - If you have the following Error .


    erroncmdb.JPG

    Simply Expand the NCM DB > Security > User > Delete the NCM User mentioned in the above Error in this case its "SolarWindsNCMUser"

    Follow the Step#1 again above .

    and Run the NCM Configuration Wizard again.
    -

     

     

    Step # 2.

    Start > Run > Regedit >

    Navigate to the Registry

    HKEY_LOCAL_MACHINE>Software>Wow6432Node>SolarWinds.Net>Configuration Manager>Wizard>ConfiguredModules

    Duble Click on "KEY" 2 change the value data "True"

    Once Done.

    ncm3.JPG

     

    Step # 3

    Re run NCM Configuration Wizard.

    Start > All programs > SolarWinds Network Configuration Manager > SolarWinds NCM Configuration Wizard  >

    Select > Database & Services > Next > Select New SQL Server  (Provide the New NCM User & credentials you just created under step 1 ) > Next > Select the NCM Database and complete the Configuration Wizard.