- Verify the SQL Server service is running on the server and attempt to login at the server
- Determine the server's IP address and then attempt to PING the SQL server by IP address and by server name (DNS name) from a command prompt
- If the PING by IP address fails, contact a qualified IT professional for assistance with TCPIP
- If the IP Ping connects but the PING by server name fails or reports a different IP address than the one found on the server, contact a certified IT professional to address the name resolution problem on the DNS server, or, as a temporary fix, add information to the HOSTS file of problem machines
- Verify the authentication method being used by SQL Server and ensure it is Mixed Mode
- If a firewall exists between the web server and the SQL server, verify the correct port number is opened in the firewall
- Telnet the port being used by SQL Server to verify the connection is possible
- If Telnet connects, set the connection string to manually use this port
- If Telnet fails, contact a qualified IT professional for assistance troubleshooting the telnet utility
Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.