Microsoft SQL Server Connecting Database Error 500

[KinetIT]

I'm trying to configure the connection of our Jira installation to our database and when i test the connection it does so successfully, but when i go forward with it i always get an error.

It was working fine when i first installed it with the trial license, but when i tried to switch to the starter license i never could make it work.

It's error 500, with the following info:

Oops - an error has occurred

Technical details

Log's referral number: b79ebc84-8d19-497d-af3d-594c042b12d1

Cause

Referer URL: http://localhost:8080/secure/SetupDatabase!default.jspa

com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM JIRA.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (Invalid object name 'JIRA.propertyentry'.)

[Alexis Robert · Accepted solution]

Hi @KinetIT, 

I think this is a database permission issue, the "Test" button will only check if Jira can connect to the database but won't check if it has "Create Table" or "Insert xxx" rights and it's probably because it can't create the DB schema that you're getting this error.

Check user permissions and make sure it has the proper right as per this documentation.

Let me know if you have any issues, 

--Alexis