Try each of the following steps in the order listed below until the issue is resolved:
- Check to see if the Windows firewall is enabled on the database server. If enabled, then verify that the port number that SQL Server is using is opened in the firewall. See How to find the port being used by SQL Server to determine the port number and protocols being used by SQL Server.
- If using a dynamic port for SQL Server, then confirm that the SQL Server Browser service is started on the database server.
- Verify that the SQL Server service is started on the database server.
- Check the authentication mode being used by SQL Server. If using Windows only authentication, then grant the Windows account(s) the required permissions or switch the authentication mode to mixed mode. Blackbaud does not have a specific recommendation regarding which authentication mode to use. NOTE: By default, SQL Server installs in Windows only authentication mode.
- If the database is attached to a full version of SQL Server, verify that the instance has been configured for use with Blackbaud databases:
- For additional troubleshooting steps, refer to How to troubleshoot login issues.