nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Upgrade from JIRA SERVER 7.3.8 to 7.7.0. Connecting to SQL database fails after uppgrade.

Sven Liang Jensen

Hi,

I need to upgrade several JIRA server databases to latest version. We plan to merge some of them and buy more licenses on one larger database rather than having many 10-user databases.

I get problems connecting to the SQL 2014 database after you have uppdated your driver:

You'd want to change it to:

<url>jdbc:sqlserver://sqlserver_hostname:1433;databaseName=jiradb</url>

<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

I have edited manually dbconfig.xml since we do not want to install JAVA on our server. I have also tried to delete the dbconfig.xml and get various error messages trying to connect to server following your suggested syntax:

ELNO1SQL01/jiraagilenew:1433;databaseName=jiraagilenew;domain=delta.corp and

ELNO1SQL01/jiraagilenew:1433;databaseName=jiraagilenew

This syntax worked with server version 7.3.8 (other driver)

ELNO1SQL01:1433/jiraagilenew;domain=delta.corp

Fast reply appreciated since the license for some of the databases I need to merge expires soon.

Best regards,

Sven Liang Jensen

Accepted answers

All comments

Ash_kida48

JIRA 7.7 requires Microsoft JDBC 6.2.1 Driver for SQL Server. Are you using the same driver?

somethingblue

Hi Sven,

Can you tell me what kind of errors you get?

Please provide a screenshot of the error on the Database setup screen and enable detailed SQL logging and provide a snippet of the logs that show the error when you attempt to connect.

Cheers,

Branden

Sven Liang Jensen

1.jpg was displayed when I uppgraded an 7.3.8 server version that was ok. I could access the SQL database (same as I later tried to connect to) before the upgrade

I tried to edit manually (I don't like JAVA on our server) dbconfig.xml according to your instructions for manually edit. Think I got it right, but can not connect

Then I deleted the dbconfig to manually reconnect in 2.jpg and 3jpg.

I then installed JAVA just to get similar error messages

Sven Liang Jensen

It is not possible to enable logging from inside JIRA when I can not log in. The link to detailed logging enabling is not possible to follow with the problem I have

Sven Liang Jensen

I downloaded and installed JDBC 6.2

Still don't work

Sven Liang Jensen

https://confluence.atlassian.com/jirakb/using-integrated-security-with-mssql-for-jira-939494383.html

SQL Integrated Sequrity. Following this procedure and changing the log-in on JIRA Service solved the problem.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-core

database