Sharepoint Products Configuration Wizard-CREATE DATABASE permission denied

Add dbcreator Role to SP Account

When you run the SharePoint Products Configuration Wizard for the first time, you get the following error:

Configuration Failed

System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database ‘master’.

This means that the domain account you specified to connect to the SQL Server does not have permissions to create the SharePoint config database. So go to your SQL Server and add the dbcreator role to your SharePoint Service account.

Add dbcreator Role to SP Account

Please don’t make the SharePoint Service account elevated to domain admin level in AD or SysAdmin in SQL Server! It’s not necessary!

Be the first to comment

Leave a Reply

Your email address will not be published.