Creating ODBC Connections on OS X
Connecting to SQL Server from an OS X computer requires a 3rd party ODBC driver. If you do not already have an ODBC driver that you use then we recommend you look at OpenLink ODBC drivers for Microsoft SQL Server. OpenLink sells commercial ODBC drivers that work in our tests. Demos are available so you can verify that the drivers work on your system.
When connecting to your SQL Server database with the admin tool or ScreenSteps Desktop you will need to connect via a DSN. If you are not familiar with how to create a DSN then follow the instructions in this lesson. These instructions show how to create a new System DSN using the iODBC Data Source Administrator that comes with OpenLink's driver.
Note that any computer that tries to connect to ScreenSteps Workgroup will need to have the ODBC driver installed.
Add System DSN
Configure Data Source
From the Connection pane enter the host where your SQL Server is located as well as the database name. For the user name use the user account you created in the previous lesson (1).
After you finish configuring the settings switch to the Test tab (2).