Microsoft SQL Server ODBC Setup

Owned by Aryn Wiebe
Last updated: Sept 03, 2024
3 min read

How to set up a new ODBC data source for Microsoft SQL Server on Windows:

  1. Download the latest drivers from the Microsoft ODBC download site.

  2. Run the installer and accept the defaults.

Iguana may not always support the very latest version of the Microsoft SQL Server ODBC drivers, so you can simply download an earlier version if necessary. This is particularly true if you are not able to use the the latest version of Iguana.

If you need to know which versions of Microsoft SQL Server are supported by the version of Iguana you are using please contact us at support@interfaceware.com.

  1. On your Windows machine, search “ODBC” to find ODBC Data Sources (64 bit). Right Click and choose Run as Administrator to open the ODBC Data Source Administrator.

  1. Open the System DSN tab and click Add.

  1. Choose the latest SQL Server ODBC driver and click Finish.

  1. Enter the ODBC credentials:

    • Use any Name and Description you prefer.

    • Enter the Network Name of the SQL Server in the Server field:

    • Click Finish to create the ODBC data source.

Once the data source is created, the ODBC Microsoft SQL Server Setup window opens to list the chosen settings. The ODBC source will use all the standard defaults which will work in most cases. Click Test Data Source to test the connection.

If unsuccessful, you may need to speak to your DBA (database administrator) about changing these if necessary. To make changes, go to the ODBC Data Source Administrator and click Configure.

There are a few settings that you may need to change:

  1. Integrated Security (default): Sometimes you might want to use a SQL Server user and password instead of the default Integrated Security to connect to a Microsoft SQL Server database. To change to a user login, select SQL Server Authentication, enter User and Password.

  2. Database: You can specify the database that you want to use by default.

  3. Incorrect port number: SQL Server defaults to port 1433, but a different port can be used. Speak to your database administrator (DBA) or network administrator.

In IguanaX, Settings > Database confirm the ODBC library has been detected and loaded correctly.

If not, click Edit to manually add the ODBC shared library path. If you don’t know the location, you can search for the odbc32.dll