症状

When trying to install Confluence using MS SQL Server, it fails with the following stack trace in the atlassian-confluence.log:

2012-12-24 09:54:34,533 ERROR [http-8090-5] [hibernate.tool.hbm2ddl.SchemaExport] execute CREATE TABLE permission denied in database 'confluence'.

原因

The error is thrown due to the fact that the database user does not have CREATE table rights on the Confluence database. 

ソリューション

Change the membership of this user to be "db_owner" so that Confluence is able to perform necessary database tasks during the installation