Welcome to Free GIS Tutorial blog. Today, I am going to show you how to create a new SQL Server ODBC Connection on Windows 10. Why you should know this thing? There are many GIS software that supports many databases but needs ODBC to work. For example, in Micromine, and Mapinfo Professional, we can import or link data in SQL Server with the help of ODBC. On my previous tutorial, you may learn how to create a new MySQL ODBC Connection.
Steps to Create a New SQL Server ODBC Connection
First, open Control Panel | Administrative Tools | ODBC Data Sources (32bit) or ODBC Data Sources (64 bit). If your software is 64 bit, then you need to create the new DSN with the 64 bit one.
On the User DSN tab, click Add button. Then, select SQL Server from the list.
Click Finish. Then, the Create a new data source wizard will open up.
Type the name of the new data source in the “Name” section. Type the IP address of the SQL Server and port in the Server area. If you have different port than the default (1433), you must enter with the following format:
ipaddress,port
For example:
192.168.100.50,14330
Click Next and select the SQL Server authentication method.
On the next window, you can specify the default database to use
Click Next to change some advanced settings. Leave it as is if you don’t know what to do.
Click Finish and you are done.