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; } } }

Confluence MS SQL Server connection with Microsoft Authentication Mode

Marc Becker_c1agy2

Hello,

I have installed confluence. After I set up the Database Connection (MS SQL 2014) I get the following message at every start of confluence:

HTTP Status 500 - com.atlassian.spring.container.ComponentNotFoundException: Failed to find component: Error creating bean with name 'i18NBean' defined in class path resource [i18NContext.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.atlassian.confluence.util.i18n.I18NBean]: Factory method 'getI18NBean' threw exception; nested exception is java.util.concurrent.CompletionException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

type Exception report

message com.atlassian.spring.container.ComponentNotFoundException: Failed to find component: Error creating bean with name 'i18NBean' defined in class path resource [i18NContext.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.atlassian.confluence.util.i18n.I18NBean]: Factory method 'getI18NBean' threw exception; nested exception is java.util.concurrent.CompletionException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

description The server encountered an internal error that prevented it from fulfilling this request.

exception

note The full stack trace of the root cause is available in the Apache Tomcat/8.0.43 logs.

Apache Tomcat/8.0.43

Accepted answers

Shannon S

Marc,

It seems that Nic might be unavailable right now, but could you confirm the permissions are correct according to our setup guide for MS SQL? I've seen this error before when the user didn't have the right permissions.

If that doesn't work, let me know, and I can help from here.

Regards,
Shannon

All comments

Nic Brough -Adaptavist-

What version of Confluence are you running, and what Java?

Also, is this a new install or an upgrade?

And, finally, how did you "set up the database connection"?

Marc Becker_c1agy2

Hello!

I want to upgrade from a trial installation to a production. The version is 6.3.3.

I have uninstalled the trial installation, moved the folders to a temp directory and installed a new instance with 6.3.3

I tried to set up the database connection with jdbc and the following connection string:

<property name="hibernate.connection.url">jdbc:jtds:sqlserver://LSDB02:1433/confluence</property>
<property name="hibernate.connection.username">ConfluenceUser</property>

Java is not installed on the server.

Nic Brough -Adaptavist-

Ok, so you're using the internal Java for Confluence.Could you tell us how you set up the connection? In the ui during the clean install?

Marc Becker_c1agy2

after the clean install the browser started for some settings. there i set the licence key and after this the connection to the database

Shannon S

Hi Marc,

Just a note, in order to make this thread easier to read, make sure to reply in the box directly below Nic's replies, and not the one below Suggest an answer.

This way, Nic can more easily follow your process in order and be able to provide you with helpful answers.

Regards,

Shannon

Marc Becker_c1agy2

after the clean install the browser started for some settings. there i set the licence key and after this the connection to the database

Marc Becker_c1agy2

Hi Shannon, thank you for your note. It was a misclick

Marc Becker_c1agy2

could it help to upgrade to the newest version?

Shannon S

No worries, Marc! I just want to make sure the thread is easy to interpret if another user runs into the same problem.

Regards,

Shannon

Marc Becker_c1agy2

Hi Nic! I have upgraded to 6.4.3

Database Connection Test in Startup was successfully but i still get the same error. Could you please help me?

Marc Becker_c1agy2

i uninstalled the old installation, deleted the old folders and installed confluence

Shannon S

Marc,

If that doesn't work, let me know, and I can help from here.

Regards,
Shannon

Marc Becker_c1agy2

Hi Shannon,

i set my db-user as a sysadmin for the whole SQL Server, not just for the confluence database. After this everything works.

Thank you!

Best regards,

Marc

Shannon S

Glad to hear, Marc!

Take care, and kind regards.

Shannon

Welcome!

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

Quick Links

Find more posts tagged with

confluence