MSSQL and a new installation

[Robert Egan]

I have a brand new installation with an MSSQL database and Windows authentication. I already know you cannot use the wizard with this type of configuration. You have to let it create an H2 database, stop the service, and edit the dbconfig.xml by hand. I have done this as follows:

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

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>mssql</database-type>
  <schema-name></schema-name>
  <jdbc-datasource>
    <url>jdbc:sqlserver://#######:1433;databaseName=jiradb;integratedSecurity=true</url>
    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
    <username></username>
    <password></password>
    <pool-min-size>30</pool-min-size>
    <pool-max-size>30</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
    <pool-max-idle>30</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
  </jdbc-datasource>
</jira-database-config>

This is from atlassian-jira.log on startup

2022-03-23 21:05:29,152+0000 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from E:\Atlassian\Jira\dbconfig.xml
2022-03-23 21:05:29,228+0000 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigHandler] Trying to get encrypted password from xml and decrypt it
2022-03-23 21:05:29,230+0000 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigHandler] Database password decryption not performed.

2022-03-23 21:05:41,358+0000 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is not yet configured. Enqueuing Database Checklist Launcher on post-database-configured-but-pre-database-activated queue
2022-03-23 21:05:41,358+0000 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is not yet configured. Enqueuing Post database-configuration launchers on post-database-activated queue

And presumably, this is the reason I get secure/SetupMode!default.jspa, which is what I'm trying to bypass.

I am somewhat stumped. Why does it look for a password when integratedSecurity=true?

Additional info: JIRA is running as a service under the SYSTEM user. Perhaps this is the real problem?

Any advice would be appreciated.