In the Description section, enter Simba SQL Server ODBC Driver.In the ODBC Administrator, select the Drivers tab.If the ODBC Administrator is not already installed on your computer, it can be downloaded from the following link: ODBC Administrator Tool for Mac OSX v1.0.

If the ODBC Administrator is not found, navigate to the Utilities folder and locate the application. In the search box, type ODBC Administrator.For more information, see Drivers & Activation on the Tableau website. Microsoft SQL Server or Azure Synapse Analyticsĭownload and install the Microsoft SQL Server driver for the Mac.This is particularly important if the server is also concurrently running an instance of the Microsoft Desktop Engine (MSDE). Your database administrator should be able to tell you whether the latest service pack has been applied. NOTE: if the only message you see is 'Port Scan has completed', then the server is not listening on that port, or the port is not reachable from your Mac! Contact your database administrator or network support staff to determine the correct port or to have the port opened on your organization's network equipment.įinally, the latest service packs from Microsoft should be applied to the SQL Server. When you use the Port Scan tool to scan the default port 1433, you should see a message that says: Use the Port Scan tool of the Network Utility application to verify your server is listening on the port you have configured, and the port is reachable from your Mac. If you get this message immediately, then you either have the wrong port or the port is being blocked by the network equipment (such as a router or firewall). Use the Ping and Trace Route tools of the Network Utility application in the /Applications/Utilities folder to verify you can reach your server's IP address. If you get this message after waiting more than 60 seconds, then you either have the wrong IP address for the server or the server is not reachable from your Mac.

Odbc administrator for mac