MSSQL 2008 installed, NPM down.

rmiller

We upgraded our database from MS SQL 2000 to MS SQL 2008 today and are getting to a stuck point. Please provide assistance.

We were able to import the databases back into SQL after the install, but when trying to run the Orion Configuration Wizard we get the below errors:

 

 

 

 

 

If I enter the wrong password it gives me the following expected error:

 

 

However, when I enter the correct password or choose Windows Authentication it gives me the below error:

 

 

 

 

In full it says:

 

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

 

************** Exception Text **************

System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {10020100-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154.

   at SolarWinds.ConfigurationWizard.Common.DatabaseHelper.ValidateSQLSecurity(String serverName, String user, String password, Boolean useSQLSecurity)

   at SolarWinds.ConfigurationWizard.Host.DatabaseServerScene.DoValidateConfig(Boolean silentMode)

   .... Edited for brevity (hundreds of lines of error message)

njoylif

if this is a new install and importing DBs, you will have to create the SolarWindsNPM user and PW in the new DB environment, and set permissions properly.

I ran into this as well when I did my migration.  Hope that helps.