Versions Compared

Old Version 29

changes.mady.by.user Emma Fullilove

Saved on

compared with

New Version Current

changes.mady.by.user Emma Fullilove

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

System Requirements

...

* While ACM supports the SQL Native Client providers SQLNCLI.1 and SQLNCLI10.1, they have reached their End of Life and are no longer available for download.

DescriptionSupported
Operating System
  • Microsoft Windows 10 (Version 22H2 or later)
  • Microsoft Windows 11
  • Microsoft Windows Server:
    • 2016, 2019 and 2022

For detailed information about Windows versions that support .Net Framework 4.7.2, see this link: .Net Framework System Requirements

Operating System
Architecture		x86 (32 Bit)
x64 (64 Bit)
.Net Framework

.Net Framework 4.7.2 or later required

Configuration Database
  • Microsoft SQL Server 2014 SP3 or newer for Express, Standard, and Enterprise editions
  • Microsoft Azure Managed Instance
  • Azure SQL Database
Database Provider
  • MSOLEDBSQL19.1
  • MSOLEDBSQL.1SQLNCLI
  • * SQLNCLI.1
  • SQLNCLI10* SQLNCLI10.1
  • SQLNCLI11

If no items appear in the "Provider" drop down in the ACM Monitor, download and install one of the following providers: MSOLEDBSQL19.1, MSOLEDBSQL.1 or SQLNCLI11 (only suggested for use with SQL Server 2012).

The installers for the providers may prompt for a Microsoft Visual C++ Redistributable for Visual Studio. More information can be found on the Installing Database Providers page.

Info
Note

AUTOSOL is aware of an issue with MSOLEDBSQL 18.6.0 and above due to the Idle Connection Resiliency feature added in that version. When saving configuration changes, you may see an error about too many parameters, or the server being unable to ‘find statement with prepared handle #’. If you encounter these errors, we suggest rolling back to MSOLEDBSQL 18.5.

This will be addressed in 9.1.2, but is available as a hotfix for 8.2 and later.



Note
titleAzure SQL Database

If you are connecting to an Azure SQL Database you must check the Azure checkbox in the server monitor when updating the database.  More information about this can be found on the Understanding the Azure SQL Database Checkbox page.

...