Knowledge Base FAQ Item #7750125

Q7750125: When I open the ActiveXperts Reports and Graphs Configuration Tool, I get an error: "Unable to connect [Driver={SQL Server};Server=sqlserver01;UID=ax_sql_admin;pwd=**************], error 0x80004005, Unspecified error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security Error". What should I do?

This is most likely caused by the fact that your SQL server requires TLS (Transport Layer Security). If TLS is enabled on the SQL Server, the {SQL Server} driver on the ActiveXperts monitoring server won't work; you must use the {SQL Server Native Client} driver instead.
The {SQL Server Native Client} may already be installed on your system; if not, you can download it from the Microsoft web site.

We recommend the following steps:

• First, start the ActiveXperts Reports and Graphs Configuration Tool, and revert to the original SQL Compact Edition statistical database. You can do so by pressing the [Migrate Database] button. Since you migrated to SQL Server, it will prompt you to revert;
• Press the [Migrate Database] button once more. It will start a wizard to migrate to MS SQL Server or MySQL Server. Choose 'MS SQL Server' and press [Next];
• In the 'Use Driver' selection box, select 'SQL Server Native Client'. If this driver is NOT listed, it is not installed. You can download it from the Microsoft site, install it, and restart the database migration wizard;
• Complete the remaining steps