Orion Network Configuration Wizard problem.

Question

Hi,

I'm having trouble installing the evaluation version of NCM with SQL Express 2005. I did the SQL Express install with Mixed Mode and installed every component as well.

Here's what I entered into the configuration wizard after.

* SQL Server: (local)\SQLEXPRESS
* User SQL Server authentication: (entered sa and pw)
* Create a new database : ConfigMgmt
* Create a new account: SolarWindCM and pw

When I launch the install I get this message: An error occured configuring Orion Network Configuration Manager Database: Create failed for Login 'SolarWindsCM'.. Please Check the ConfigurationWizard.log file for details.

Here are the main error lines of the log file:

2009-07-14 11:16:23,437 [1] INFO  ConfigurationProgressScene - Creating Orion Network Configuration Manager database. Processing ConfigMgmtEngine8.DBStructure file ...

Note: The time required to upgrade the Orion Network Configuration Manager database depends on the size of your database.  If you have a large database this may take a while.

2009-07-14 11:16:23,546 [5] ERROR ConfigurationProgressScene - Error Creating Database.
2009-07-14 11:16:23,640 [5] ERROR ConfigurationProgressScene - Error adding sample Policy Reports
2009-07-14 11:16:23,640 [1] INFO  ConfigurationProgressScene - Updating Orion Network Configuration Manager database. Updating user account ...
2009-07-14 11:16:23,640 [5] DEBUG UserAccountProcessor - Creating user login account "SolarWindsCM" on "(local)\SQLEXPRESS" for database "ConfigMgmt"
2009-07-14 11:16:23,640 [5] ERROR ConfigurationProgressScene - Exception while configuring plugin Orion Network Configuration Manager Main Plugin component Orion Network Configuration Manager Database. Microsoft.SqlServer.Management.Smo.FailedOperationException: Create failed for Login 'SolarWindsCM'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: The database 'ConfigMgmt' does not exist. Supply a valid database name. To see available databases, use sys.databases.

Have you ever seen this problem before?

Thanks,

FerlandD · Answer

Ok I found out what was the problem, I deleted the NCM software, reinstalled it and tried to create a database with the same name again.

It worked when I entered a different new name for the database.

Derek · Answer

I'd recommend opening a support ticket and provide the diagnostics.  The errors appear to be permission related, however you've entered your SA account.  Can you confirm that the ConfigMgmt database was created within SQL Express?  Can you also email me the ConfigurationWizard logs? Thanks