0 Replies Latest reply on Oct 10, 2018 4:33 PM by wlouisharris

    NPM configurationwizard.exe -silent issues

    wlouisharris

      1)We are trying to automate the configurationwizard.exe for servers that already have Solarwinds installed.

       

      2)We are running the command:

       

      c:\Program Files (x86)\SolarWinds\Orion>ConfigurationWizard.exe -silent -cfg:"si

      lent-config.xml"

       

      3)We get an error referencing the SQL authentication failed; however we are using known good credentials. 

       

      2018-10-10 17:17:07,836 [1] ERROR SWEventLogging - Service was unable to open new database connection when requested.

      SqlException: Login failed for user 'solarwindsorionqa'.

      Connection string - Data Source=WSQADS057;Initial Catalog=master;User ID=solarwindsorionqa;Password=*******;Pooling=False

      2018-10-10 17:17:07,839 [1] ERROR ConfigurationProgressScene - Exception while configuring plugins.

      System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'solarwindsorionqa'.

       

      4)I am copying the silent-config.xml leaving out the credentials.  One item we do not want to run is the section I highlighted.  We do not want to create the user; we are running configuration wizard on server and DB that already has the user.

      I omitting the line I highlighted but it doesn't work.

       

      <?xml version="1.0" encoding="utf-8"?>

      <SilentConfig>

         <Host>

         <Info>

      <ReconfigureDatabase>True</ReconfigureDatabase>

      <ReconfigureWebsite>True</ReconfigureWebsite>

      <ReconfigurePermissions>True</ReconfigurePermissions>

      <Database>

         <CreateNewDatabase>False</CreateNewDatabase>

         <UseSQLSecurity>True</UseSQLSecurity>   <!-- True for SQL authenticaiton to DB. Needs sa user. False for Windows authenticaiton -->

         <UseExistingSqlAccount>True</UseExistingSqlAccount>

         <DatabaseName>SolarWindsOrion</DatabaseName>   <!-- Database name that will be created. Default "SolarWindsOrion" -->

         <DatabasePath>

         </DatabasePath>

         <ServerName>Server1</ServerName>

         <InstanceName>DB1</InstanceName>

         <User>solarwindsorionqa</User>   <!-- User name to access DB. For SQL authentication sa. For Windows authenticaiton Administrator -->

         <UserPassword></UserPassword>

        <Account>solarwindsorionqa</Account>   <!-- Database user that will be created. Default "SolarWindsOrionDatabaseUser" -->

         <AccountPassword></AccountPassword>

         <NeedSQLServerSecurity>False</NeedSQLServerSecurity>

         <NeedToChangeSAPassword>False</NeedToChangeSAPassword>

         <SAPassword>

         </SAPassword>

         <AddServiceDependencies>False</AddServiceDependencies>

         <RemoveServiceDependencies>False</RemoveServiceDependencies>

         <FailureInfo>

         </FailureInfo>

      </Database>

      <Website>

         <Folder>H:\InetPub\SolarWinds</Folder>

         <Address>(All Unassigned)</Address>

         <Port>443</Port>

         <ApplicationName>SolarWinds NetPerfMon</ApplicationName>

         <LaunchWebConsole>False</LaunchWebConsole>

         <ConfigurationSkipped_IISNotInstalled>False</ConfigurationSkipped_IISNotInstalled>

         <EnableWindowsLogin>False</EnableWindowsLogin>

               </Website>

      </Info>

         </Host>

         <Plugins>

            <!-- <Plugin Assembly="" AssemblyFile="" FactoryType=""  /> -->

         </Plugins>

      </SilentConfig>