Installation/Configuration Issue Confluence - Installing on Windows using SQL Server

[Colin Hunt]

I intitally installed the trial version of confluence on my server and everything installed and worked great. After evaluating I then uninstalled the trial and proceeded to install the Production version with a license I purchsed.

I am installing the Confluence v6.3.1 on my server that is Microsoft Server 2012 and my database I am connecting to is a SQL 2012 database. The database has been setup as per the specifications for using confluence with SQL Server. 

When I step through the wizard after the configuring the database section the wizard continues to process and then I get the below error message. It appears the that the setup/configuration is able to create the database tables in the database. I have also granted, for testing purposes after multiple fails, that everyone has full writes on both the Confluense folder in Program Files\Atlassian and the Program Files\Atlassian\Application Data\Confluence.

PLEASE can someone provide some useful guidance on why the original install would work and how I can get a licensed version installed and working.

I have also included the error if I stop and restart the service and view the site.

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.beans.factory.BeanCreationException: Error creating bean with name 'tenantedTransactionManager' defined in class path resource [databaseSubsystemContext.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantedLocalSessionFactoryBean5' defined in class path resource [productionDatabaseContext.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: premature SessionFactory initialisation, Hibernate properties have not yet been persisted in confluence.cfg.xml

ERROR RECIVED AFTER RESTARTING SERVICE:

A system error has occurred — our apologies!

Cause

com.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.IllegalStateException: Spring Application context has not been set
    at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)

caused by: java.lang.IllegalStateException: Spring Application context has not been set
    at com.atlassian.spring.container.SpringContainerContext.getComponent(SpringContainerContext.java:48)

[Nic Brough [Adaptavist]]

There's several ways to provoke this problem, but you've already checked for many of them

The ones I'd check over next:

• Check that the installer has not done something bad with the database driver - there should be driver in <install>/confluence/WEB-INF/lib
• If you have anti-virus, that might be blocking access to files in the confluence install.
• Can the server resolve its own hostname?
• Is there enough memory to run the installer?  It can fail lilke this if there's not enough
• What Java is the process using?  Has it picked up a version outside the installation?

[Colin Hunt]

Thank you Nic for the suggestion. I was able to determine that one of the reasons was the the sql server user did not have all the permissions required to complete the install configuration. The user was able to create the tables but then failed.

After adding the additional permissions all was good.

[Pavel Tananykhin]

Wjat additional permissions did you add?