Symptoms

While attempting to create a new FlexiCapture 12 database or the Application server may encounter errors as below:

Cannot configure database. Query timeout expired Inner Exception: SOAP Server Application Faulted

Repeating the creation attempts shows the message as:

Cannot configure database. Database '<databaseName>' already exists. Choose a different database name. Inner Exception: SOAP Server Application Faulted

and attempts to connect to this database fail with the following error:

Cannot configure database. Could not find stored procedure 'Settings_GetValue'. in method { call Settings_GetValue(?, ?, ?, ?, ?, ?, ?, ?) } Inner Exception: SOAP Server Application Faulted

Cause

The database was created, but the Application Server cannot connect to it. The reason for such behavior is incorrect permissions used to create the database.

Resolution

Check if FlexiCapture 12 IIS Application pools are running on behalf of the default Network Service account:

If they are, restart the Application pools on behalf of the domain user with sufficient permissions over the domain and SQL Server instance. Then try creating the FlexiCapture database via Administration And Monitoring Station. As another option, try creating the FlexiCapture database manually and connect to it in the Administration And Monitoring Station.

After the database is created and connected to the FlexiCapture Application Server, switch FlexiCapture Application pools back to the Network Service account if such settings are preferred.

You can find information on how to manually create a new MS SQL database in FlexiCapture 12 in the following article.