Support‎ > ‎

Error: [DBNETLIB] SQL Server does not exist or access denied.

Source: Microsoft OLE DB Provider for SQL Server
Number: -2147467259
Error: [DBNETLIB] [ConnectionOpen (Connect().]SQL Server does not exist or access denied

when first time running ERPro Desktop Client on a workstation.


Either
1. Make sure the SQL Server NameSystem DatabaseSQL User ID and SQL User Password is correct.


2. Allow Remote Connection if the SQL Server installed is Express Edition
3. Turn off Windows Firewall of the SQL server or Create SQL Server exceptions in Windows Firewall

4. Make sure the SQL Server Browser Service is running

If this is not the first time running HRPro Desktop Client on a workstation. 
  1. Make sure the SQL Server is not down
  2. The SQL Server NameSystem DatabaseSQL User ID and SQL User Password is correct
  3. The SQL connection is not blocked by the workstation firewall or SQL server firewall
  4. Make sure the SQL Server Browser Service is running
  5. The system database and application database is accessible.


See also