Problem Definition

During the database configuration setup, if the user configured JIRA to use a database user with Default Database configured on MSSQL server, JIRA will not know that on the MSSQL server side, it's actually using the Default Database of the user.

For example:

1. JIRA DB configuration:
   • <url>jdbc:jtds:sqlserver://10.60.3.37:1433;instance=SQLEXPRESS/MOG</url>.
   • <username>moga</username>.
2. In the SQL Server, I do not have any MOG database.
3. In the SQL Server also, I have set the DB user moga configured MOGA1 as the Default Database.
4. During the installation, JIRA did not complain that the database does not exist.
5. After setting up JIRA, the MOGA1 database which was empty, now it has all the JIRA tables and data.

Which means, despite the database does not exist, JIRA will use the DB user's Default Database even though in the dbconfig.xml file is pointing to another database.

Suggested Solution

Documentation update:

By default, the Default Database for DB users will be master. The documentation on Connecting JIRA to SQL Server will need an update to highlight that users should not alter the Default Database value for any DB users.