Confluence MS SQL Server connection with Microsoft Authentication Mode

[Marc Becker]

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

[Shannon S · Accepted solution]

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

[Marc Becker]

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

[Marc Becker]

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]

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

[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]

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]

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]

could it help to upgrade to the newest version?

[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]

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]

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