Symptoms

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'.

Cause

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

Resolution

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