{"id":2174,"date":"2020-06-09T18:36:12","date_gmt":"2020-06-09T10:36:12","guid":{"rendered":"https:\/\/www.wesbytes.com\/guide\/?post_type=kb&#038;p=2174"},"modified":"2026-03-17T15:01:53","modified_gmt":"2026-03-17T07:01:53","slug":"connect-to-ms-sql-server-database","status":"publish","type":"kb","link":"https:\/\/www.servergigabit.com\/guide\/kb\/connect-to-ms-sql-server-database","title":{"rendered":"Connect to MS SQL Server Database"},"content":{"rendered":"<h3><strong>Connect to MS SQL Server Database<\/strong><\/h3>\n<table id=\"table1\" border=\"1\" width=\"445\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr bgcolor=\"#ccccff\">\n<td style=\"text-align: center;\"><strong>Connection String<\/strong><\/td>\n<\/tr>\n<tr bgcolor=\"#ffffea\">\n<td style=\"text-align: center;\">\u201cProvider=SQLOLEDB; \u201d &amp; _<br \/>\n\u201cData Source = SQLServerIP,SQLServerPortNumber; \u201d &amp; _<br \/>\n\u201cInitial Catalog = YourDatabaseName; \u201d &amp; _<br \/>\n\u201cUser ID = YourDatabaseUserID; \u201d &amp; _<br \/>\n\u201cPassword = YourDatabasePassword\u201d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p dir=\"ltr\"><b>You can use sample code below to connect to your <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\" rel=\"nofollow noopener\" target=\"_blank\">MS SQL<\/a> Server\u2019s database:<\/b><\/p>\n<p dir=\"ltr\">ConnectionString = \u201cProvider=SQLOLEDB; Data Source = 72.18.131.233,1533; \u201d &amp; _<br \/>\n\u201cInitial Catalog = Northwind; \u201d &amp; _<\/p>\n<p dir=\"ltr\">\u201cUser ID = SampleUser; \u201d &amp; _<\/p>\n<p dir=\"ltr\">\u201cPassword = SamplePassword\u201d<\/p>\n<p dir=\"ltr\">Set Conn = Server.CreateObject(\u201cADODB.Connection\u201d)<br \/>\nConn.ConnectionString = ConnectionString<br \/>\nConn.Open<\/p>\n<p>For more information, you can refer to the following articles. <a href=\"https:\/\/www.servergigabit.com\/guide\/kb\/microsoft-ole-db-provider-for-sql-server-error-80040e4d\/\">Microsoft OLE DB Provider for SQL Server error \u201880040e4d\u2019<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Connect to MS SQL Server Database Connection String \u201cProvider=SQLOLEDB; \u201d &amp; _ \u201cData Source = SQLServerIP,SQLServerPortNumber; \u201d &amp; _ \u201cInitial Catalog = YourDatabaseName; \u201d &amp; _ \u201cUser ID = YourDatabaseUserID; \u201d &amp; _ \u201cPassword = YourDatabasePassword\u201d &nbsp; You can use sample code below to connect to your MS SQL Server\u2019s database: ConnectionString = \u201cProvider=SQLOLEDB; Data Source = 72.18.131.233,1533; \u201d &amp;&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[52],"kbtag":[1301],"class_list":["post-2174","kb","type-kb","status-publish","hentry","kbtopic-microsoft-sql","kbtag-ms-sql-server"],"_links":{"self":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/comments?post=2174"}],"version-history":[{"count":7,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2174\/revisions"}],"predecessor-version":[{"id":4534,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2174\/revisions\/4534"}],"wp:attachment":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/media?parent=2174"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=2174"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtag?post=2174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}