HI
I am facing a very strange problem while configuring my NPM. Earlier i use to have an SQL Express express installed to my Hot standby Poller connecting locally and my main poller was connecting the same DB over the IP network.
I recently tried upgrading the SQL express to MS SQL 2005 on the same server. after uninstalling the express and intalling the SQL 2005 standard edition i was able to recover my DB and connect the primary poller over the IP network but the locally installed Hot standby is not getting connected. I tried reinstalling the complete application but everytime i stuck up on the following error. Reinstalled the complete Dot net framework , HS application but i was not able to run the configuration wizard. There has been no error during the installation. The account id used to connect the DB are the same which are used in primary poller to connect to the same database.
I have no idea about the DB connectivity so if someone can understand the issue and help me out with this.
Thanks in advance
Error faced :
Following is my configuartion logs :
2008-06-10 22:27:57,593 [1] INFO Program - Configuration Wizard Starting.2008-06-10 22:27:57,828 [1] DEBUG IISHelper - Parsed IIS binding string of "10.14.101.50:80:". Address is "10.14.101.50" and port is "80"2008-06-10 22:28:08,437 [1] DEBUG DatabaseHelper - SQL Server on "(local)" reports its edition as "Standard Edition".2008-06-10 22:28:10,375 [1] DEBUG DatabaseAccountScene - Does account "SolarWindsNPM" exist: False2008-06-10 22:28:10,375 [1] DEBUG UserAccountProcessor - Checking if user can create login.2008-06-10 22:28:27,953 [1] INFO SettingsController - Database Server Name - (local)2008-06-10 22:28:27,953 [1] INFO SettingsController - Database User - OrionDB2008-06-10 22:28:27,953 [1] INFO SettingsController - Use SQL Security - True2008-06-10 22:28:27,953 [1] INFO SettingsController - Database Name - Airtel_01_01_082008-06-10 22:28:27,953 [1] INFO SettingsController - Create New Database - False2008-06-10 22:28:27,953 [1] INFO SettingsController - SQL Account - OrionDB2008-06-10 22:28:27,953 [1] INFO SettingsController - Website IP - (All Unassigned)2008-06-10 22:28:27,953 [1] INFO SettingsController - Website Port - 802008-06-10 22:28:27,953 [1] INFO SettingsController - Website Folder - E:\InetPub\Solarwinds2008-06-10 22:28:27,953 [1] INFO SettingsController - Component 'Orion Network Performance Monitor Database' from 'Orion Network Performance Monitor' plugin will be configured.2008-06-10 22:28:27,953 [1] INFO SettingsController - Component 'Orion Network Performance Monitor Website' from 'Orion Network Performance Monitor' plugin will be configured.2008-06-10 22:28:27,953 [1] INFO SettingsController - Component 'SolarWinds Network Performance Monitor' from 'Orion Network Performance Monitor' plugin will be configured.2008-06-10 22:28:27,953 [1] INFO SettingsController - Component 'SolarWinds Alerting Service' from 'Orion Network Performance Monitor' plugin will be configured.2008-06-10 22:28:27,953 [1] INFO SettingsController - Component 'SolarWinds Syslog Service' from 'Orion Network Performance Monitor' plugin will be configured.2008-06-10 22:28:27,953 [1] INFO SettingsController - Component 'SolarWinds Custom MIB Polling Service' from 'Orion Network Performance Monitor' plugin will be configured.2008-06-10 22:28:27,953 [1] INFO SettingsController - Component 'SolarWinds Module Engine Service' from 'Orion Network Performance Monitor' plugin will be configured.2008-06-10 22:28:27,953 [1] INFO ConfigurationProgressScene - Shutting down services ...2008-06-10 22:28:27,968 [5] DEBUG ConfigurationProgressScene - Configuring Plugin "Orion Network Performance Monitor" - Component "Orion Network Performance Monitor Database"2008-06-10 22:28:27,968 [1] INFO ConfigurationProgressScene - Updating Orion database. Processing NetPerfMon.DBStructure file ... Note: The time required to upgrade the Orion database depends on the size of your database. If you have a large database this may take a while.2008-06-10 22:28:28,765 [5] ERROR ConfigurationProgressScene - Can not open connection Provider cannot be found. It may not be properly installed.2008-06-10 22:28:28,765 [5] ERROR ConfigurationProgressScene - Can not open recordset The connection cannot be used to perform this operation. It is either closed or invalid in this context.2008-06-10 22:28:28,765 [5] ERROR ConfigurationProgressScene - Operation is not allowed when the object is closed.2008-06-10 22:28:28,781 [5] ERROR ConfigurationProgressScene - Exception while configuring plugin Orion Network Performance Monitor component Orion Network Performance Monitor Database. System.Runtime.InteropServices.COMException (0x800A0E78): Operation is not allowed when the object is closed. at ADODB.ConnectionClass.Close() at SolarWinds.ConfigurationWizard.Plugin.Common.DBStructureProcessor.UpdateTableStructure(_Database dataBase, XmlNode tableNode, ConfigurationLogDelegate configLog) at SolarWinds.ConfigurationWizard.Plugin.Common.DBStructureProcessor.UpdateDatabaseStructure(_Database dataBase, String fileName, ConfigurationLogDelegate configLog) at SolarWinds.ConfigurationWizard.Plugin.Common.DBStructureProcessor.CheckDatabaseStructure(String serverName, String databaseName, String user, String password, Boolean useSQLSecurity, String fileName, ConfigurationLogDelegate log) at SolarWinds.ConfigurationWizard.Plugin.Orion.OrionMainPlugin.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log) at SolarWinds.ConfigurationWizard.Plugin.Orion.OrionMainPlugin.DoConfigure(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log) at SolarWinds.ConfigurationWizard.Plugin.Common.OrionConfigPlugin.SolarWinds.ConfigurationWizard.Common.IOrionConfigPlugin.DoConfig(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log) at SolarWinds.ConfigurationWizard.Host.ConfigurationProgressScene.DoConfigInThread()