Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Configuration Manager (NCM) > ERROR ConfigurationProgressScene - Error while executing script - The SELECT permission was denied on the object 'Options', database 'ConfigMgmt' schema 'dbo'

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

Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 1,855 Votes: 0 Revisions: 6

Overview

The following error occurs while running NCM configuration wizard after migration database / upgrade:

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'.. Please check the ConfigurationWizard.log for details.

 

 

Environment

NCM 7.2 and earlier

Cause 

Database user permission schema is not configured properly and the permission changed after the database migration.

 

Resolution

  1. Create a Manual User Account for NCM under SQL Server Security and User:

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

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

        (Deselect Enforce password policy )

    c. Select Your NCM Database under Default database.

    d. Select English under Default Language.

    e. Now click on User Mapping > (select) your NCM DB.

    f. Click the browse button under Default Schema. Click on Browse > select

       [dbo] > OK > OK

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

    h. Click OK now the new NCM user is been created.




    If you get the following error, expand the NCM DB > Security > User > Delete the NCM User mentioned in the above Error in this case its "SolarWindsNCMUser".

    Repeat step 1 and the rerun Configuration Wizard.

  2. Edit the registry.

    a. Go to Start > Run > Regedit.
    b. Navigate to the Registry
        HKEY_LOCAL_MACHINE>Software>Wow6432Node>SolarWinds.Net>Configuration   Manager>Wizard>ConfiguredModules

    c. Double Click on "KEY" 2 change the value data "True"

  3. Rerun NCM Configuration Wizard:

    Go to 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.

 

Last modified

Tags

Classifications

Public