Issue
When creating a new SQL Server service instance, the following error occurs:
VALIDATION A connection was successfully established with the server, but could not connect to the database supplied or database could not be found.
Resolution
The error is typically related to a lack of sufficient permissions on the database in SQL Server. The following permissions are required: data reader, data writer, and execute. Depending on the nature of the stored procedures, DBO permissions may also be necessary.