When I try to establish a connection to SQL Server in Navicat, I get an error message saying "SQL Server ODBC Driver is required." What should I do?

Apply OS: macOS, Linux

Apply Product: Navicat BI, Navicat BI Viewer

The Microsoft ODBC Driver for SQL Server (version 17 or 18) is required to establish direct connections to Microsoft SQL Server instances.

macOS

Installation Instructions

1. Go to https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver17
2. Follow to install unixODBC
3. Follow to install ODBC driver
4. Restart Navicat and test the connection

Linux

Installation Instructions

1. Go to https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver17
2. Follow to install unixODBC
3. Follow to install ODBC driver
4. Restart Navicat and test the connection