Cannot configure database. Connection to database failed with error: Login failed for user ..
Check connection settings and try again. Connection to database failed with error: Login failed for user 'FCUser'.. Check connection settings and try again.
You need this information when receiving the error above in the Administration & Monitoring Console during the creation or moving of the database.
The reason for incorrect behavior is that the user does not have appropriate permissions.
Please note, you should use a user account that has DBA permissions for Microsoft SQL Server (see here).
The user must have the following permissions:
- CREATE DATABASE, CREATE ANY DATABASE or ALTER ANY DATABASE to create a database
- ALTER ANY LOGIN to create a new user
- db_accessadmin and db_securityadmin permissions to the new database to provide db_owner permissions to the user under whose account the Application Server is running. Under this account, first the Description.sql and then the DBInitFill.sql script will be executed. The scripts are located on the computer where the Application Server is installed at <IIS Root Directory (the default location is “C:\inetpub\wwwroot”)>\FlexiCapture12\Server. The first script creates a database and the second populates it with data. The Upgrade*.sql files, which can be found in the same folder, are not used when creating a new database.