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>