"Cannot configure database. access is denied. Inner Exception: SOAP Server Application Faulted" error when creating a MS SQL database in Flexicapture 12.

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

Resolution

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

When creating a new database:

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

When connecting to an existing database:

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

When installing patches, connecting to, and using the database:

  • 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.
    mceclip0.png
  3. Run browser as Administrator.

    Please note. If you are using Edge, it might not be started under administrator, even if you did that. Try another browser like Chrome/Firefox.

    During DB creation specify the newly created SQL login:
    mceclip1.png
  4. Create a DB.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.