This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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

GoldTipu over 10 years ago

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

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 .

- If you have the following Error .

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.

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.