Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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: 462 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
21:06, 22 Jun 2016

Tags

Classifications

Public