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

Enhancement on JIRA:

Check if the DB user has any Default Database configured in MSSQL Server. If it is anything other than master throw a warning to say that this is not a recommended configuration.