Why can I not connect my database in the JIRA Configuration Tool?

Question

Hi,

I am trying to setup Jira for the first time, i've downloaded it and installed it on my pc. Ive created an SQL database called "connecttojira", set the collation to sql latin general cp437 ci ai, created a scheme and alter database to set read committed snapshot on. Made my way to the cmd and ran as admin, cd'd into the jira bin folder and config.bat in order to open up the JIRA Configuration Tool.

Here I input all the database details:

I first set the Database type to: SQL Server (because im using sql server) then I input the connection details as follow:

Hostname: localhost, Port: 1433, Database: connecttojira, Username: sa, Password: (correct password) Scheme: dbo.

The problem I'm getting is that when I test connection with these settings I get an error saying "Could not connect to the DB: Cannot open database "connecttojira" requested by the login. The login failed."

When I type in the wrong credentials, obviously I get a wrong credential error message which means that my credentials are fine...

I'm at a loss on what to else I can do... Can anyone help me?

Nic Brough -Adaptavist- · Answer

Ok, but that doesn't tell us why your database is rejecting the log in.  You'll need to debug the database connection - why is it not letting you log in?

atal asian · Answer

I use that exact login details to log into my sql database all the time though, i've even tried to change the password and then entering the old password, it says that the password is wrong, but when i try the new password it works again and has the same error message T_T

Nic Brough -Adaptavist- · Answer

You need to configure the database to allow the connection.

As you've confirmed the parameters for the connection are correct (one thing that used to be a bug was having spurious spaces in the connection string, but I think that was fixed ages ago and a newer Jira won't allow them), then there's nothing wrong in Jira.  The database is rejecting the login.  You might have something in the database logs to tell you why it rejected the attempt to log in.