ActiveXperts Network Monitor KB - Reports and Graphs - Statistical Database / MS SQL
'Reports and Graphs - Statistical Database / MS SQL' Knowledge Base Articles
| Q7750010 | Which database driver do you recommend to use with Microsoft SQL Server? |
| It is strongly recommended to use the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). This provider will be updated by Microsoft with the most recent server features going forward. It also supports encryption standards, whereas other Microsoft providers don't. ActiveXperts fully supports MSOL ... | |
| Q7750020 | How to install the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)? |
| The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is recommended by Microsoft, but it is NOT installed by default on most Server platforms. For installation guidelines, please use the following URL:https://learn.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql- ... | |
| Q7750022 | I try to install the "Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)" database driver, but the installer keeps giving me the message: "This application requires Microsoft Visual C++ Redistributable for Visual Studio 2022 (x64/x86, version 14.34 at minimum)." |
| See FAQ #7750020. ... | |
| Q7750024 | What would a typical MS SQL Server based connection string look like? |
| For the statistical database, a typical MS SQL based connection string would look like this: Provider=MSOLEDBSQL19Server=192.168.31.27Uid=saPwd=mysecretpasswordEncrypt=noTrust Server Certificate=TrueDatabase=ActiveXpertsNM ... | |
| Q7750110 | Can I migrate the statistical database to MS SQL Server Express Edition? If yes, how can this be done? |
| Yes, MS SQL Express Edition is supported. For a list of suppported SQL Express versions, see FAQ #7750115 Migration to MS SQL Server Express Edition can be done in the same way as migrating to MS SQL Server, with only one difference: you MUST specify the instance ID of the SQL Server Expr ... | |
| Q7750115 | Which versions of Microsoft SQL Express are supported? |
| ActiveXperts Network Monitor supports the latest versions of Microsoft SQL Express. ActiveXperts Network Monitor v.2022 and v.2023 have full support for the following SQL Express versions: Microsoft SQL Express 2022 Microsoft SQL Express 2019 Microsoft SQL Express 2017 ... | |
| Q7750117 | Which database driver should I select for my Microsoft SQL Express statistical database? |
| ActiveXperts Network Monitor supports the following database drivers for Microsoft SQL Express: Microsoft SQL Express 2022: {MSOLEDBSQL} {SQL Server} Mcrosoft SQL Express 2017 and 2019: {MSOLEDBSQL} {SQL Server} {SQL Server Native Client} NOTE: ActiveXperts does NOT ... | |
| 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 Cli ... | |
| Q7750127 | What is the maximum size of a Microsoft SQL Server Compact Edition (SQL CE) database? |
| The maximum size of a 'Microsoft SQL Server Compact Edition (SQL CE)' database is 4 GB. SQL CE is designed as an embedded database engines. The size limits are relatively small compared to MS SQL Server and MySQL, which can handle much larger databases. If you require a larger database size, ... |
Contact Support
If you cannot find an answer to your question(s) in our Knowledge Base, or if you need additional information or assistance, please contact our Customer Support using the Contact Support form:
Contact Support »