If you get an error message similar to the following, Flow cannot connect to its own database.
There could be a few reasons for this:
- The SQL Server is not running on the server that is configured in the instance properties.
- The server that is configured in the instance properties does not exist.
- The database that is configured in the instance properties does not exist on the server stipulated.
- The Username and Password combination that are configured in the instance properties are not valid SQL credentials to connect to the database, or they have not been given the requisite access to the database (DB_READER & DB_WRITER), or they have been entered incorrectly.
- If no Username and Password have been configured in the instance properties, Flow will use integrated security to connect to the database. Confirm that the logged in account has access to the database.