3 Replies Latest reply on Sep 24, 2008 9:12 AM by MC_Tools

    Config Wizard error after upgrade to v9

      Getting an error when trying to run the configuration wizard, the error is as follows..


       


      "Error while executing script - Cannot alter column 'PollerID' because it is "'OWGUIDCOL'  Caution: Changing any part of an object name could break scripts and stored procedures. "


       


      Any ideas?


       


       


        • Re: Config Wizard error after upgrade to v9
          tdanner

          Did you use the custom pollers in previous versions? If not, you can probably upgrade successfully if you just use SQL Management Studio to delete the CustomPollers and CustomPollerAssignments tables and let the 9.0 Configuration Wizard recreate them.

          If you do have existing custom pollers that you need to preserve, I recommend you open a support ticket.

          • Re: Config Wizard error after upgrade to v9
            MC_Tools

            We are getting an error while going through the config. wizard at this time while trying to upgrade to V 9. The error says that - "An error occurred coniguring Orion NPM Database: Login failed for user. The user is not associated with a trusted SQL server connection. Please check the config.wizard.log file for details."

            The configwizard log file says the following- 

            2008-09-24 08:28:37,855 [1] INFO  Program - Configuration Wizard Starting.
            2008-09-24 08:28:38,011 [1] DEBUG IISHelper - Parsed IIS binding string of "..............".  Address is "..............." and port is "80"
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Database Server Name - .............
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Database User -
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Use SQL Security - True
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Database Name - NetPerfMon
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Create New Database - False
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - SQL Account -
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Website IP - .......................
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Website Port - 80
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Website Folder - C:\InetPub\SolarWinds
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'Orion Network Performance Monitor Database' from 'Orion Network Performance Monitor' plugin

            will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'Orion Network Performance Monitor Website' from 'Orion Network Performance Monitor' plugin

            will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'SolarWinds Network Performance Monitor' from 'Orion Network Performance Monitor' plugin

            will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'SolarWinds Alerting Service' from 'Orion Network Performance Monitor' plugin will be

            configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'SolarWinds Syslog Service' from 'Orion Network Performance Monitor' plugin will be

            configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'SolarWinds Trap Service' from 'Orion Network Performance Monitor' plugin will be

            configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'SolarWinds Universal Device Poller' from 'Orion Network Performance Monitor' plugin will be

            configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'SolarWinds Module Engine Service' from 'Orion Network Performance Monitor' plugin will be

            configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'Orion Information Service' from 'Orion Network Performance Monitor' plugin will be

            configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'APM Database' from 'Application Performance Monitor' plugin will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'APM Website' from 'Application Performance Monitor' plugin will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'APM Job Engine Plugin' from 'Application Performance Monitor' plugin will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'Application Monitor Database' from 'Application Monitor' plugin will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'Application Monitor Website' from 'Application Monitor' plugin will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'SolarWinds Application Monitor' from 'Application Monitor' plugin will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'NetFlow Database' from 'NetFlow Traffic Analyzer' plugin will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'NetFlow Website' from 'NetFlow Traffic Analyzer' plugin will be configured.
            2008-09-24 08:28:56,729 [1] INFO  SettingsController - Component 'SolarWinds NetFlow Traffic Analyzer Service' from 'NetFlow Traffic Analyzer' plugin will be

            configured.
            2008-09-24 08:28:56,729 [1] INFO  ConfigurationProgressScene - Shutting down services ...
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "NetPerfMonService".
            2008-09-24 08:28:56,745 [5] INFO  ServiceProcessor - Service NetPerfMonService probably doesn't exist on this machine: Service NetPerfMonService was not

            found on computer '.'.
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsAlertingEngine".
            2008-09-24 08:28:56,745 [5] INFO  ServiceProcessor - Service SolarWindsAlertingEngine probably doesn't exist on this machine: Service

            SolarWindsAlertingEngine was not found on computer '.'.
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsSyslogService".
            2008-09-24 08:28:56,745 [5] INFO  ServiceProcessor - Service SolarWindsSyslogService probably doesn't exist on this machine: Service SolarWindsSyslogService

            was not found on computer '.'.
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsTrapService".
            2008-09-24 08:28:56,745 [5] INFO  ServiceProcessor - Service SolarWindsTrapService probably doesn't exist on this machine: Service SolarWindsTrapService was

            not found on computer '.'.
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsCustomPollingService".
            2008-09-24 08:28:56,745 [5] INFO  ServiceProcessor - Service SolarWindsCustomPollingService probably doesn't exist on this machine: Service

            SolarWindsCustomPollingService was not found on computer '.'.
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "OrionModuleEngine".
            2008-09-24 08:28:56,745 [5] INFO  ServiceProcessor - Service OrionModuleEngine probably doesn't exist on this machine: Service OrionModuleEngine was not

            found on computer '.'.
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "NetFlowService".
            2008-09-24 08:28:56,745 [5] INFO  ServiceProcessor - Service NetFlowService probably doesn't exist on this machine: Service NetFlowService was not found on

            computer '.'.
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "OrionAppPoller".
            2008-09-24 08:28:56,745 [5] INFO  ServiceProcessor - Service OrionAppPoller probably doesn't exist on this machine: Service OrionAppPoller was not found on

            computer '.'.
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Stopping service "SWOrionInformationService".
            2008-09-24 08:28:56,745 [5] DEBUG ConfigurationProgressScene - Configuring Plugin "Orion Network Performance Monitor" - Component "Orion Network Performance

            Monitor Database"
            2008-09-24 08:28:56,807 [5] ERROR ConfigurationProgressScene - Exception while configuring plugin Orion Network Performance Monitor component Orion Network

            Performance Monitor Database. System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
               at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
               at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
               at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,

            TdsParserStateObject stateObj)
               at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
               at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64

            timerExpire, SqlConnection owningObject)
               at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection

            owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
               at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword,

            Boolean redirectedUserInstance)
               at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo,

            String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
               at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool,

            DbConnection owningConnection)
               at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
               at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
               at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
               at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
               at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
               at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
               at System.Data.SqlClient.SqlConnection.Open()
               at SolarWinds.ConfigurationWizard.Common.DatabaseHelper.CreateConnection(String serverName, String databaseName, String user, String password, Boolean

            useSQLServerSecurity)
               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.DoConfigForComponent(IOrionConfigHost host, Int32 componentId)