Skip to content
logo Knowledgebase

Error: "Unable to connect to the database (error=99)" when saving in Database Setup.

Created on  | Last modified on 

Cause

The error occurs when ONLY SQL Native client 11 driver is installed on the computer.

The System Manager install comes with a SQL Native Client driver. This error will only occur you remove the SQL Native client driver and only keep the SQL Native client 11.

Resolution

To resolve the error, you will need to create your ODBC database connections using SQL Native Client 10.

Make sure ODBC is created using the ODBCAD32.exe from the Windows\System32 folder (for a 32 bit computer) and or the Windows\SysWow64 (for a 64 bit computer) folder and that the DSN has been created using the correct SQL Native client driver with preferably the sa username and password. Then visit database setup to ensure that all databases are using the new datasource with the same sa username and password tied to them.