Error: Unable to establish database connection. [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Native error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (includes video)

When logging in users may receive the following error:

Unable to establish database connection. [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Native error: 17'.  '[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Native error: 53'.
 

Possible causes include but are not limited to:

  • Database is offline
  • Renamed database files
  • Moved the database to a new server
  • Migrated from ASA to SQL Server
For more information see Knowledgebase Solution BB144086 or For more information see Knowledgebase Solution 42647
 
Native Error 17 and 53
Try each of the following steps in the order listed below until the issue is resolved:
  1. Open the Blackbaud Management Console and confirm that your database is attached and online.  If the database is not attached, then attach your database.  If the database is offline, then bring the database online.
  2. 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, as well as UDP port 1434 (if using dynamic ports).  See How to find the port being used by SQL Server to determine the port number and protocols being used by SQL Server.
    icon of video cameraWatch videos that show you how:
    How to open a port in Windows (3:58)
    How to find the port used by SQL Server (2:37)
  3. Verify that the SQL Server service is started.
  4. Verify that the SQL Server Browser service is started on the application server if using a dynamic port for SQL Server.
  5. For additional troubleshooting steps, refer to How to troubleshoot login issues (39052.

If Blackbaud hosts your database:
Contact Support and reference this article. 

Environment

 Firewall

Was this article helpful?