{"id":57416,"date":"2021-12-30T11:00:00","date_gmt":"2021-12-30T16:00:00","guid":{"rendered":"https:\/\/jumpcloud.com\/?p=57416"},"modified":"2024-02-08T11:39:29","modified_gmt":"2024-02-08T16:39:29","slug":"domainless-access-to-ms-sql-server-tutorial","status":"publish","type":"post","link":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial","title":{"rendered":"Domainless Access to MS SQL Server Tutorial"},"content":{"rendered":"\n<p>Traditionally, there have been two options to authenticate into Microsoft\u2019s SQL Server: Integrated Windows Authentication (managed by Active Directory) or SQL Server\u2019s built-in authentication scheme. The first requires a domain controller, while the latter sends (encrypted) credentials over the wire when its \u201cForce Encryption\u201d flags are configured. In both cases, there is additional IT management overhead required to get users access to this particular server.&nbsp;<\/p>\n\n\n\n<p>There\u2019s now a third method: local group access through JumpCloud and Integrated Windows Authentication. It enables remote users to work with SQL Server without passing credentials around the web <em>and<\/em> without the need for users to run their access requests over a VPN and through the domain controller.<\/p>\n\n\n\n<p>This article is a follow-up to a previous example that discusses <a href=\"https:\/\/jumpcloud.com\/blog\/use-windows-file-sharing-within-a-domainless-environment\">domainless Windows File Sharing<\/a>. The methods are similar, except in this example IT administrators in smaller organizations gain the additional advantage of enabling DBAs to work with SQL Server without having to stand up a domain controller. The DBA gains access to SQL Server with the same credentials they use to log into their devices and cloud services, with a single managed identity that integrates with fully-supported Windows authentication methods and SQL Server. This is all possible without the introduction of any software other than the JumpCloud agent.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"692\" height=\"390\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/05\/1.2-21.png\" alt=\"\" class=\"wp-image-63572\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2022\/05\/1.2-21.png 692w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2022\/05\/1.2-21-300x169.png 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<p>This tutorial outlines the steps involved to create and manage local user groups for SQL Server through the JumpCloud console in addition to outlining how to harden Integrated Windows Authentication (NTLM) for better security. You can also monitor access logs for any suspicious events with <a href=\"https:\/\/jumpcloud.com\/platform\/directory-insights\">Directory Insights<\/a>. JumpCloud accounts are a prerequisite for this workflow.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Prerequisites<\/h3>\n\n\n\n<ul>\n<li>Have a JumpCloud account (you can <a href=\"https:\/\/jumpcloud.com\/signup\">sign up for a JumpCloud Free account<\/a> if you don\u2019t have one yet)<\/li>\n\n\n\n<li><a href=\"https:\/\/support.jumpcloud.com\/support\/s\/article\/agent-deployment1\">Deploy agents<\/a> on your server and workstations\n<ul>\n<li>Workstations do not need to be Professional editions of Windows<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/support.jumpcloud.com\/support\/s\/article\/Binding-Users-to-Devices\">Add devices to JumpCloud and bind users to device<\/a><\/li>\n\n\n\n<li>Ensure that NTLM isn\u2019t disabled<\/li>\n\n\n\n<li>Create a User Group for SQL admins in JumpCloud<\/li>\n\n\n\n<li>Know your local user names<\/li>\n\n\n\n<li>[Optional] Have a VPN set up (ideally utilizing a <a href=\"https:\/\/support.jumpcloud.com\/support\/s\/article\/getting-started-radius1#:~:text=JumpCloud's%20cloud%2Dbased%20RADIUS%20service,users%20can%20access%20specific%20resources.\">RADIUS<\/a> service) for remote users<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/powershell\/module\/microsoft.powershell.localaccounts\/new-localgroup?view=powershell-5.1\" rel=\"nofollow\">Create a Local Group<\/a><\/h3>\n\n\n\n<code>\nNew-LocalGroup -Name &#8220;SQLServerUsers&#8221;\n<\/code>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"692\" height=\"650\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/05\/2.2-18.png\" alt=\"\" class=\"wp-image-63573\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2022\/05\/2.2-18.png 692w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2022\/05\/2.2-18-300x282.png 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/powershell\/module\/microsoft.powershell.localaccounts\/add-localgroupmember?view=powershell-5.1\" rel=\"nofollow\">Add User to the Local Group:<\/a>&nbsp;<\/h3>\n\n\n\n<p>(After the user was created in JumpCloud)<\/p>\n\n\n\n<code>\nAdd-LocalGroupMember -Group &#8220;SQLServerUsers&#8221; -Member &#8220;yourname&#8221;\n<\/code>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"692\" height=\"650\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/05\/3.2-7.png\" alt=\"\" class=\"wp-image-63574\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2022\/05\/3.2-7.png 692w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2022\/05\/3.2-7-300x282.png 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Select Users and Groups within SQL Server<\/h2>\n\n\n\n<p>Open Security &gt; Logins in the SQL Server Management Studio GUI or &lt;your server&gt;\\Databases\\&lt;your database&gt;\\Security\\<\/p>\n\n\n\n<ul>\n<li>Click New User<\/li>\n\n\n\n<li>Navigate to the General page and search for your local user group<\/li>\n\n\n\n<li>Click Object Types and Select Groups within the dialog box, and click Ok.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"692\" height=\"390\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/05\/4.2-4.png\" alt=\"\" class=\"wp-image-63576\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2022\/05\/4.2-4.png 692w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2022\/05\/4.2-4-300x169.png 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Hardening NTLM<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/windows\/security\/threat-protection\/security-policy-settings\/network-security-lan-manager-authentication-level\" rel=\"nofollow\">Harden NTLM Using PowerShell<\/a>&nbsp;<\/h3>\n\n\n\n<code>\nGet-ItemProperty -Path &#8216;HKLM:\\SYSTEM\\CurrentControlSet\\Control\\Lsa\\&#8217; -Name &#8216;LmCompatibilityLevel&#8217;\n\nNew-ItemProperty -Path &#8216;HKLM:\\SYSTEM\\CurrentControlSet\\Control\\Lsa\\&#8217; -Name &#8216;LmCompatibilityLevel&#8217; -Value 5 -Force\n<\/code>\n\n\n\n<p>You may also consider disabling WLAN for remote users <em>only<\/em>. Disabling this on PCs have use WLAN for their proxy configuration on a LAN could disrupt internet access.<\/p>\n\n\n\n<code>\nHKLM\\SYSTEM\\CurrentControlSet\\Services\\WinHttpAutoProxySvc\\Start\nREG_DWORD4\n<\/code>\n\n\n\n<h3 class=\"wp-block-heading\">Conditional Access<\/h3>\n\n\n\n<p>JumpCloud\u2019s <a href=\"https:\/\/support.jumpcloud.com\/support\/s\/article\/Device-Trust-Certificates\">Device Trust<\/a> limits which devices may access applications and other resources through SSL\/TLS certificates. It\u2019s fundamental to <a href=\"https:\/\/support.jumpcloud.com\/support\/s\/article\/Configuring-Conditional-Access-Policies\">conditional access<\/a>, which can further secure access to resources via geofencing and other measures such as requiring MFA. These features are included in the JumpCloud platform without additional services required. JumpCloud also provides <a href=\"https:\/\/jumpcloud.com\/blog\/what-is-patch-management\">policies<\/a> to ensure that Windows updates are applied and not delayed, which helps to ensure that any high-priority security patches are delivered to your Windows endpoints.<\/p>\n\n\n\n<p>Monitoring also helps to ensure that your configuration isn\u2019t being misused.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Directory Insights<\/h3>\n\n\n\n<p>JumpCloud <a href=\"https:\/\/jumpcloud.com\/platform\/directory-insights\">Directory Insights<\/a> provides an audit trail of user logins so unauthorized attempts will be noticed and you\u2019ll be alerted. Directory Insights is a component of the platform and has no additional cost to access.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Try JumpCloud<\/h2>\n\n\n\n<p>Don&#8217;t take our work for it: test it out. Get started with a\u00a0<a href=\"https:\/\/jumpcloud.com\/platform\">free 30 Day Trial<\/a>\u00a0of JumpCloud.<\/p>\n\n\n\n<p><em>Special thanks to&nbsp;<\/em><a href=\"https:\/\/www.linkedin.com\/in\/idanmashaal\/\"><em>Idan Mashaal<\/em><\/a><em>&nbsp;at Plus500<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enable remote users to work with MS SQL Server over a VPN without using a domain controller or passing credentials over the web.<\/p>\n","protected":false},"author":150,"featured_media":43767,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_oasis_is_in_workflow":0,"_oasis_original":0,"_oasis_task_priority":"","inline_featured_image":false,"footnotes":""},"categories":[23,2781,42],"tags":[2536,2607],"collection":[2778,2779,2777],"platform":[],"funnel_stage":[3014],"coauthors":[2535],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.9 (Yoast SEO v22.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Domainless Access to MS SQL Server Tutorial - JumpCloud<\/title>\n<meta name=\"description\" content=\"Enable remote users to work with MS SQL Server over a VPN without using a domain controller or passing credentials over the web.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Domainless Access to MS SQL Server Tutorial\" \/>\n<meta property=\"og:description\" content=\"Enable remote users to work with MS SQL Server over a VPN without using a domain controller or passing credentials over the web.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial\" \/>\n<meta property=\"og:site_name\" content=\"JumpCloud\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-30T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-08T16:39:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"780\" \/>\n\t<meta property=\"og:image:height\" content=\"442\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Worthington\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Worthington\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#article\",\"isPartOf\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial\"},\"author\":{\"name\":\"David Worthington\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/person\/185ca12034835ee50ee17b100abdfb2e\"},\"headline\":\"Domainless Access to MS SQL Server Tutorial\",\"datePublished\":\"2021-12-30T16:00:00+00:00\",\"dateModified\":\"2024-02-08T16:39:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial\"},\"wordCount\":631,\"publisher\":{\"@id\":\"https:\/\/jumpcloud.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png\",\"keywords\":[\"domainless enterprise\",\"SQL Server\"],\"articleSection\":[\"Best Practices\",\"How-To\",\"News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial\",\"url\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial\",\"name\":\"Domainless Access to MS SQL Server Tutorial - JumpCloud\",\"isPartOf\":{\"@id\":\"https:\/\/jumpcloud.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#primaryimage\"},\"image\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png\",\"datePublished\":\"2021-12-30T16:00:00+00:00\",\"dateModified\":\"2024-02-08T16:39:29+00:00\",\"description\":\"Enable remote users to work with MS SQL Server over a VPN without using a domain controller or passing credentials over the web.\",\"breadcrumb\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#primaryimage\",\"url\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png\",\"contentUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png\",\"width\":780,\"height\":442},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jumpcloud.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Domainless Access to MS SQL Server Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jumpcloud.com\/#website\",\"url\":\"https:\/\/jumpcloud.com\/\",\"name\":\"JumpCloud\",\"description\":\"Daily insights on directory services, IAM, LDAP, identity security, SSO, system management (Mac, Windows, Linux), networking, and the cloud.\",\"publisher\":{\"@id\":\"https:\/\/jumpcloud.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jumpcloud.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jumpcloud.com\/#organization\",\"name\":\"JumpCloud\",\"url\":\"https:\/\/jumpcloud.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png\",\"contentUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png\",\"width\":598,\"height\":101,\"caption\":\"JumpCloud\"},\"image\":{\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/person\/185ca12034835ee50ee17b100abdfb2e\",\"name\":\"David Worthington\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/person\/image\/d9acf1381c6e5b50c0f50d47b7b05411\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a6dde901b469c9005c22973e42038d62?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a6dde901b469c9005c22973e42038d62?s=96&d=mm&r=g\",\"caption\":\"David Worthington\"},\"description\":\"I'm the JumpCloud Champion for Product, Security. JumpCloud and Microsoft certified, security analyst, a one-time tech journalist, and former IT director.\",\"sameAs\":[\"https:\/\/jumpcloud.com\/blog\",\"david.worthington@jumpcloud.com\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Domainless Access to MS SQL Server Tutorial - JumpCloud","description":"Enable remote users to work with MS SQL Server over a VPN without using a domain controller or passing credentials over the web.","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:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial","og_locale":"en_US","og_type":"article","og_title":"Domainless Access to MS SQL Server Tutorial","og_description":"Enable remote users to work with MS SQL Server over a VPN without using a domain controller or passing credentials over the web.","og_url":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial","og_site_name":"JumpCloud","article_published_time":"2021-12-30T16:00:00+00:00","article_modified_time":"2024-02-08T16:39:29+00:00","og_image":[{"width":780,"height":442,"url":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png","type":"image\/png"}],"author":"David Worthington","twitter_card":"summary_large_image","twitter_misc":{"Written by":"David Worthington","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#article","isPartOf":{"@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial"},"author":{"name":"David Worthington","@id":"https:\/\/jumpcloud.com\/#\/schema\/person\/185ca12034835ee50ee17b100abdfb2e"},"headline":"Domainless Access to MS SQL Server Tutorial","datePublished":"2021-12-30T16:00:00+00:00","dateModified":"2024-02-08T16:39:29+00:00","mainEntityOfPage":{"@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial"},"wordCount":631,"publisher":{"@id":"https:\/\/jumpcloud.com\/#organization"},"image":{"@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#primaryimage"},"thumbnailUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png","keywords":["domainless enterprise","SQL Server"],"articleSection":["Best Practices","How-To","News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial","url":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial","name":"Domainless Access to MS SQL Server Tutorial - JumpCloud","isPartOf":{"@id":"https:\/\/jumpcloud.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#primaryimage"},"image":{"@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#primaryimage"},"thumbnailUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png","datePublished":"2021-12-30T16:00:00+00:00","dateModified":"2024-02-08T16:39:29+00:00","description":"Enable remote users to work with MS SQL Server over a VPN without using a domain controller or passing credentials over the web.","breadcrumb":{"@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#primaryimage","url":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png","contentUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2020\/01\/active-directory-database.png","width":780,"height":442},{"@type":"BreadcrumbList","@id":"https:\/\/jumpcloud.com\/blog\/domainless-access-to-ms-sql-server-tutorial#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jumpcloud.com\/"},{"@type":"ListItem","position":2,"name":"Domainless Access to MS SQL Server Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/jumpcloud.com\/#website","url":"https:\/\/jumpcloud.com\/","name":"JumpCloud","description":"Daily insights on directory services, IAM, LDAP, identity security, SSO, system management (Mac, Windows, Linux), networking, and the cloud.","publisher":{"@id":"https:\/\/jumpcloud.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jumpcloud.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jumpcloud.com\/#organization","name":"JumpCloud","url":"https:\/\/jumpcloud.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/","url":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png","contentUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png","width":598,"height":101,"caption":"JumpCloud"},"image":{"@id":"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jumpcloud.com\/#\/schema\/person\/185ca12034835ee50ee17b100abdfb2e","name":"David Worthington","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/#\/schema\/person\/image\/d9acf1381c6e5b50c0f50d47b7b05411","url":"https:\/\/secure.gravatar.com\/avatar\/a6dde901b469c9005c22973e42038d62?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a6dde901b469c9005c22973e42038d62?s=96&d=mm&r=g","caption":"David Worthington"},"description":"I'm the JumpCloud Champion for Product, Security. JumpCloud and Microsoft certified, security analyst, a one-time tech journalist, and former IT director.","sameAs":["https:\/\/jumpcloud.com\/blog","david.worthington@jumpcloud.com"]}]}},"_links":{"self":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/posts\/57416"}],"collection":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/users\/150"}],"replies":[{"embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/comments?post=57416"}],"version-history":[{"count":3,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/posts\/57416\/revisions"}],"predecessor-version":[{"id":105571,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/posts\/57416\/revisions\/105571"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/media\/43767"}],"wp:attachment":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/media?parent=57416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/categories?post=57416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/tags?post=57416"},{"taxonomy":"collection","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/collection?post=57416"},{"taxonomy":"platform","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/platform?post=57416"},{"taxonomy":"funnel_stage","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/funnel_stage?post=57416"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/coauthors?post=57416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}