Wiseindy
How to add MS SQL server as an ODBC data source? - Wiseindy Explorer
https://wiseindy.com/blog/windows/how-to-add-ms-sql-server-as-an-odbc-data-source/

How to add MS SQL server as an ODBC data source?

Contents
  1. What you need:
  2. Step 1:
  3. Step 2:
  4. Step 3:
  5. Step 4:
  6. Step 5:
  7. Step 6:
  8. Step 7:
  9. Step 8:
  10. Step 9:
  11. Further reading

ODBC stands for Open Database Connectivity. It is an API that allows you to access database systems. This connection was developed with an aim to make it independent of database systems and operating systems.

In this quick guide, we will see how a connection can be established to a Microsoft SQL server on your network.

What you need:

  • A Microsoft SQL Server (MS SQL) on the network.
    • In this case, we will be connecting to a server running Microsoft SQL Server 2005.
  • A normal PC on the network.
    • In this example, I'll be using a workstation running Windows 7.

Step 1:

Click the Start button. Either navigate to Administrative Tools > Data Sources (ODBC) or simply search for ODBC.

Windows 7 Start menu: Administrative Tools > Data Sources (ODBC)  How to add ODBC data source - Microsoft SQL Server

Step 2:

In the ODBC Data Source Administrator window, click Add.

ODBC Data Source Administrator: click Add to create a new data source

Step 3:

Since we are going to be connecting to MS SQL Server 2005, select SQL server in the Create New Data Source window. Click Next.

Create New Data Source window with the SQL Server driver selected

Step 4:

Type a Name for your data source. Next, enter the Server hostname or IP address. Click Next.

New data source to SQL Server: enter a name and the server

Step 5:

Select With SQL Server authentication using a login ID and password entered by the user.

Enter the Login ID and Password for your SQL server. Click Next.

Choose SQL Server authentication and enter the login ID and password

Step 6:

Leave all settings as default and click Next.

SQL Server data source wizard: default database settings, click Next

Step 7:

Leave all settings as default and click Finish.

SQL Server data source wizard: default language and logging settings, click Finish

Step 8:

A window will pop up asking you whether you want to test the connection or not. Click Test Data Source... If all goes well, you should see a TESTS COMPLETED SUCCESSFULLY! message. Click OK.

ODBC Microsoft SQL Server Setup summary with the Test Data Source button

SQL Server ODBC Data Source Test showing TESTS COMPLETED SUCCESSFULLY

Step 9:

Your new ODBC data source has been successfully added. Now you can use this data source in different applications to connect and access data from your SQL server.

ODBC Data Source Administrator listing the new SQL Server data source

Further reading

https://msdn.microsoft.com/en-us/library/ms811006.aspx

Header photo by qubodup (CC0, via Flickr)

Keywords:connectiondatabasedatabase connectionmicrosoftms sqlmssqlodbcsqlsql serverGuides

Guestbook