{"id":3562,"date":"2023-04-12T15:39:28","date_gmt":"2023-04-12T15:39:28","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/"},"modified":"2026-01-15T18:18:29","modified_gmt":"2026-01-15T18:18:29","slug":"creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/","title":{"rendered":"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity?"},"content":{"rendered":"

ODBC, or Open Database Connectivity, is a standardized way for outside programs to connect to database management systems. In this article, we will show you how to set up an ODBC data source connection to a Microsoft SQL Server instance on Windows.<\/p>\n

Opening the Program<\/span><\/h3>\n

The first step is to find and open the ODBC Data Sources program in Windows. This can be found in the Control Panel under Administrative Tools or under C:ProgramDataMicrosoftWindowsStart MenuProgramsAdministrative Tools. In the screenshot below, you\u2019ll notice that two versions of the program exist, one for 32-bit and one for 64-bit. The choice of program you\u2019ll want to use is the one that matches the application you\u2019re trying to connect to the database. For example, if you have a 32-bit version of excel, you\u2019ll want to use the 32-bit ODBC Data Source.<\/p>\n

\"\"<\/p>\n

Selecting a DSN Type<\/strong><\/span><\/h3>\n

After opening the program, you will see a few tabs with the name DSN (Data Source Name):<\/p>\n

User DSN:<\/strong> An ODBC data source for the specific windows user account. Other users will not be able to see the connection.<\/p>\n

System DSN:<\/strong> An ODBC data source that is system-wide and can be leveraged by any user with the proper rights.<\/p>\n

File DSN:<\/strong> An ODBC data source that is set up using files with a .DSN file extension.<\/p>\n

\"\"<\/p>\n

In this example, we will focus on setting up a new System DSN<\/strong>. To do this, click on the System DSN tab and then click on the Add button.<\/p>\n

Choosing a Driver<\/strong><\/span><\/h3>\n

After clicking the Add button, you will be prompted to pick a driver to set up your data source. Drivers allow the system to translate SQL and database functions from the application you are using to the database management system you are trying to connect to. If you do not see the driver you are looking for, don\u2019t fret, while the drivers for each database don\u2019t come pre-installed on your system, they can often be downloaded from the website associated with each database for free. In this case, we will be using the SQL Server driver to connect to our Microsoft SQL Server instance. Click \u201cFinish\u201d to begin setting up the connection.<\/p>\n

\"\"<\/p>\n

Note:<\/strong> Depending on the driver chosen, the next steps may look different, but will require similar information.<\/p>\n

Configuring the Connection<\/strong><\/span><\/h3>\n

On this screen, you\u2019ll first want to give your new DSN a meaningful name, this will be the name you use to reference the connection in your applications. There is also space to put a description of the driver, which can be used to add more details about the connection. Lastly, you\u2019ll enter the address of the SQL server you are trying to connect to. In this case, it\u2019s the SQLEXPRESS SQL Server instance that\u2019s located on the Windows server with IP address 10.3.0.4. Click \u201cNext\u201d to continue.<\/p>\n

\"\"<\/p>\n

The next step involves setting up the way the ODBC will authenticate your connection to the SQL Server. For Microsoft SQL Server, you can choose to use Windows authentication or the user authentication native to Microsoft SQL Server. If you\u2019ve chosen SQL Server authentication, which has been selected in the screenshot below, it will want you to enter a specific login here. This will not be the only login you can use to connect to the server with the ODBC connection, but it will be used to test the connection and to automatically obtain some default settings for the remainder of the ODBC configuration, if the box is checked. You\u2019ll also notice the Client Configuration button, the functionality of this is described in the next section. Once everything is set, click \u201cNext\u201d to continue.<\/p>\n

\"\"<\/p>\n

By clicking on Client Configuration in the authentication section, you will be brought to the screen below. This screen allows you to choose an alias for your server, as well as the port number and communication library being used.<\/p>\n

\"\"<\/p>\n

After you finish setting up authentication for your connection, you will land on this screen. Your first option here is to change the default database for the connection to the SQL server. This determines which group of tables the system will try to query when you don\u2019t reference the database schema in your query. If there is a specific database on the SQL Server your application will be leveraging, you\u2019ll want to pick it as your default. The second option allows you to attach a detached database to the database you\u2019ll be connecting to, but this is not always best practice to use. In addition to those options, the first two radio buttons allow you to choose whether the connection adheres to ANSI conventions and the third option will allow a mirror SQL Server to be used as a failover. Click \u201cNext\u201d to continue.<\/p>\n

\"\"<\/p>\n

Lastly, you\u2019ll want to pick some final options for the connection. Here you can choose language, translation, data encryption, and logging options. Strong encryption is highly suggested if you are connecting from outside a safe network. After you have selected the options you want, you can click \u201cFinish\u201d.<\/p>\n

\"\"<\/p>\n

Testing 1, 2, 3<\/strong><\/span><\/h3>\n

Once you click finish, you will be shown a prompt with the information that you have filled in regarding the database connection. If anything looks wrong, you can click cancel and change your selections. Otherwise, it is suggested that you try \u201cTest Data Source…\u201d. This will attempt to connect to the database using the login you had provided earlier.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

After clicking the Test Data Source button and seeing \u201cTESTS COMPLETED SUCCESSFULLY\u201d, congratulations, you have successfully set up an ODBC Data Source connection!<\/p>\n

\"\"<\/p>\n

The new ODBC connection, now be seen among the other connections:<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

ODBC, or Open Database Connectivity, is a standardized way for outside programs to connect to database management systems. In this article, we will show you how to set up an ODBC data source connection to a Microsoft SQL Server instance on Windows. Opening the Program The first step is to find and open the ODBC…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[27],"tags":[32],"class_list":["post-3562","post","type-post","status-publish","format-standard","hentry","category-quebit-value","tag-sql"],"acf":[],"yoast_head":"\nHow Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"ODBC, or Open Database Connectivity, is a standardized way for outside programs to connect to database management systems. In this article, we will show you how to set up an ODBC data source connection to a Microsoft SQL Server instance on Windows. Opening the Program The first step is to find and open the ODBC…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:39:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-15T18:18:29+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity?\",\"datePublished\":\"2023-04-12T15:39:28+00:00\",\"dateModified\":\"2026-01-15T18:18:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/\"},\"wordCount\":961,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/ODBC1-min.jpg\",\"keywords\":[\"SQL\"],\"articleSection\":[\"QueBIT Value\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/\",\"name\":\"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/ODBC1-min.jpg\",\"datePublished\":\"2023-04-12T15:39:28+00:00\",\"dateModified\":\"2026-01-15T18:18:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/ODBC1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/ODBC1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity? - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity? - QueBIT","og_description":"ODBC, or Open Database Connectivity, is a standardized way for outside programs to connect to database management systems. In this article, we will show you how to set up an ODBC data source connection to a Microsoft SQL Server instance on Windows. Opening the Program The first step is to find and open the ODBC…","og_url":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:39:28+00:00","article_modified_time":"2026-01-15T18:18:29+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity?","datePublished":"2023-04-12T15:39:28+00:00","dateModified":"2026-01-15T18:18:29+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/"},"wordCount":961,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/ODBC1-min.jpg","keywords":["SQL"],"articleSection":["QueBIT Value"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/","url":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/","name":"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/ODBC1-min.jpg","datePublished":"2023-04-12T15:39:28+00:00","dateModified":"2026-01-15T18:18:29+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/ODBC1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/ODBC1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/creating-a-microsoft-sql-server-odbc-data-source-on-microsoft-windows\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3562"}],"version-history":[{"count":1,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3562\/revisions"}],"predecessor-version":[{"id":4920,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3562\/revisions\/4920"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}