{"id":3307,"date":"2014-10-06T12:01:06","date_gmt":"2014-10-06T10:01:06","guid":{"rendered":"https:\/\/badgemaker.info\/?page_id=3307"},"modified":"2014-10-06T12:03:41","modified_gmt":"2014-10-06T10:03:41","slug":"1-configuring-microsoft-sql-server-data-source","status":"publish","type":"page","link":"https:\/\/badgemaker.info\/en\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/","title":{"rendered":"1. Configuring a Microsoft SQL Server data source"},"content":{"rendered":"

1. Configuring a Microsoft SQL Server data source<\/strong><\/p>\n

After selecting Microsoft SQL Server as the type of data source, you are able to fill in all information required to connect to the server.<\/p>\n

Server: Path or IP address to the server. If the server is hosted on another system in the network, it can be either addressed as \\\\servername or the IP address of the server (see item \u201cA<\/b>\u201d in the screenshot below).<\/p>\n

Information such as the database name (or name of the view) username and password will be provided by your database administrator. Note that in order to be able to work with a Microsoft SQL Server, an active network connection must be available.<\/p>\n

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

1. Configuring a Microsoft SQL Server data source After selecting Microsoft SQL Server as the type of data source, you are able to fill in all information required to connect to the server. Server: Path or IP address to the server. If the server is hosted on another system in<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":2627,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"page-user-guide.php","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-3307","page","type-page","status-publish","hentry"],"yoast_head":"\nConfiguring a Microsoft SQL Server data source<\/title>\n<meta name=\"description\" content=\"Configuring a Microsoft SQL Server data source\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configuring a Microsoft SQL Server data source\" \/>\n<meta property=\"og:description\" content=\"Configuring a Microsoft SQL Server data source\" \/>\n<meta property=\"og:url\" content=\"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/\" \/>\n<meta property=\"og:site_name\" content=\"BadgeMaker\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BadgeMakersoftware\/\" \/>\n<meta property=\"article:modified_time\" content=\"2014-10-06T10:03:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2014\/10\/bmc_03.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@BadgeMaker_\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/1-configuring-microsoft-sql-server-data-source\\\/\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/1-configuring-microsoft-sql-server-data-source\\\/\",\"name\":\"Configuring a Microsoft SQL Server data source\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/1-configuring-microsoft-sql-server-data-source\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/1-configuring-microsoft-sql-server-data-source\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/bmc_03.png\",\"datePublished\":\"2014-10-06T10:01:06+00:00\",\"dateModified\":\"2014-10-06T10:03:41+00:00\",\"description\":\"Configuring a Microsoft SQL Server data source\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/1-configuring-microsoft-sql-server-data-source\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/1-configuring-microsoft-sql-server-data-source\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/1-configuring-microsoft-sql-server-data-source\\\/#primaryimage\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/bmc_03.png\",\"contentUrl\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/bmc_03.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/1-configuring-microsoft-sql-server-data-source\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BadgeMaker User Guide\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/BadgeMaker-UserGuide-V2.11.18-September-2025.pdf\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Add-Ons\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"BadgeMaker Connect\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Setting up BadgeMaker Connect\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/add-ons\\\/badgemaker-connect-2\\\/setting-badgemaker-connect\\\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"1. Configuring a Microsoft SQL Server data source\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/\",\"name\":\"BadgeMaker\",\"description\":\"ScreenCheck presents BadgeMaker ID software\",\"publisher\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#organization\",\"name\":\"ScreenCheck\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"ScreenCheck\"},\"image\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/BadgeMakersoftware\\\/\",\"https:\\\/\\\/x.com\\\/BadgeMaker_\",\"https:\\\/\\\/www.linkedin.com\\\/showcase\\\/9493265\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL1iI8MU-A2RbWyYGzpVRow\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configuring a Microsoft SQL Server data source","description":"Configuring a Microsoft SQL Server data source","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:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/","og_locale":"en_US","og_type":"article","og_title":"Configuring a Microsoft SQL Server data source","og_description":"Configuring a Microsoft SQL Server data source","og_url":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/","og_site_name":"BadgeMaker","article_publisher":"https:\/\/www.facebook.com\/BadgeMakersoftware\/","article_modified_time":"2014-10-06T10:03:41+00:00","og_image":[{"url":"https:\/\/badgemaker.info\/wp-content\/uploads\/2014\/10\/bmc_03.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@BadgeMaker_","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/","url":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/","name":"Configuring a Microsoft SQL Server data source","isPartOf":{"@id":"https:\/\/badgemaker.info\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/#primaryimage"},"image":{"@id":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/#primaryimage"},"thumbnailUrl":"https:\/\/badgemaker.info\/wp-content\/uploads\/2014\/10\/bmc_03.png","datePublished":"2014-10-06T10:01:06+00:00","dateModified":"2014-10-06T10:03:41+00:00","description":"Configuring a Microsoft SQL Server data source","breadcrumb":{"@id":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/#primaryimage","url":"https:\/\/badgemaker.info\/wp-content\/uploads\/2014\/10\/bmc_03.png","contentUrl":"https:\/\/badgemaker.info\/wp-content\/uploads\/2014\/10\/bmc_03.png"},{"@type":"BreadcrumbList","@id":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/1-configuring-microsoft-sql-server-data-source\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/badgemaker.info\/"},{"@type":"ListItem","position":2,"name":"BadgeMaker User Guide","item":"https:\/\/badgemaker.info\/wp-content\/uploads\/2025\/09\/BadgeMaker-UserGuide-V2.11.18-September-2025.pdf"},{"@type":"ListItem","position":3,"name":"Add-Ons","item":"https:\/\/badgemaker.info\/userguide2\/add-ons\/"},{"@type":"ListItem","position":4,"name":"BadgeMaker Connect","item":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/"},{"@type":"ListItem","position":5,"name":"Setting up BadgeMaker Connect","item":"https:\/\/badgemaker.info\/userguide2\/add-ons\/badgemaker-connect-2\/setting-badgemaker-connect\/"},{"@type":"ListItem","position":6,"name":"1. Configuring a Microsoft SQL Server data source"}]},{"@type":"WebSite","@id":"https:\/\/badgemaker.info\/en\/#website","url":"https:\/\/badgemaker.info\/en\/","name":"BadgeMaker","description":"ScreenCheck presents BadgeMaker ID software","publisher":{"@id":"https:\/\/badgemaker.info\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/badgemaker.info\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/badgemaker.info\/en\/#organization","name":"ScreenCheck","url":"https:\/\/badgemaker.info\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/badgemaker.info\/en\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"ScreenCheck"},"image":{"@id":"https:\/\/badgemaker.info\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BadgeMakersoftware\/","https:\/\/x.com\/BadgeMaker_","https:\/\/www.linkedin.com\/showcase\/9493265\/","https:\/\/www.youtube.com\/channel\/UCL1iI8MU-A2RbWyYGzpVRow"]}]}},"_links":{"self":[{"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages\/3307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/comments?post=3307"}],"version-history":[{"count":3,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages\/3307\/revisions"}],"predecessor-version":[{"id":3310,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages\/3307\/revisions\/3310"}],"up":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages\/2627"}],"wp:attachment":[{"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/media?parent=3307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}