Symptoms

Cannot configure database. access is denied. Inner Exception: SOAP Server Application Faulted occurs when creating a database via Web UI.

Cause

The issue can be caused by the lack of the permission or browser not running under the administrator.

Resolution

The following permissions are required for DB creation in MS SQL.

• CREATE ANY DATABASE (required to create a new database)
• SECURITYADMIN (required to create a new user under whose account the Application Server is running)

• EXECUTE ON SCHEMA::DBO
• SELECT ON SCHEMA::DBO

• DB_DATAREADER
• DB_DATAWRITER (DBInitFill)
• DB_DDLADMIN
• ALTER ON DATABASE::<DB_NAME> (required for specifying the recovery model and enabling Snapshot isolation)
• EXECUTE ON SCHEMA::DBO
• GRANT EXECUTE ON SCHEMA::DBO
• DB_BACKUPOPERATOR (required for creating backups and restoring the database)
• DB_ACCRESSADMIN (required for adding users to the database)
• DB_SECURITYADMIN (required for managing database permissions)

Please try to do the following:

1. Create an SQL login with the corresponding permissions (see above);
2. Switch login mode for SQL Server to Mixed authentification.
   
3. Run browser as Administrator.
   
   Please note. Launching Microsoft Edge in administrator mode might fail despite selecting the "Run as administrator" option. Try another browser like Chrome/Firefox.
   
   During Database creation specify the newly created SQL login:
   
4. Create a Database.