{"id":15,"date":"2022-09-21T08:00:00","date_gmt":"2022-09-21T06:00:00","guid":{"rendered":"https:\/\/www.syntera.ch\/blog\/?p=15"},"modified":"2023-10-12T08:09:47","modified_gmt":"2023-10-12T06:09:47","slug":"connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication","status":"publish","type":"post","link":"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/","title":{"rendered":"Connecting Power BI to remote SQL Server from outside the domain with Windows authentication"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-post-author has-medium-font-size\"><div class=\"wp-block-post-author__avatar\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=48&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&#038;d=mm&#038;r=g 2x' class='avatar avatar-48 photo' height='48' width='48' \/><\/div><div class=\"wp-block-post-author__content\"><p class=\"wp-block-post-author__byline\">LEAD DATA ENGINEERING<\/p><p class=\"wp-block-post-author__name\">Dominic Schranz<\/p><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-outermost-social-sharing alignright has-small-icon-size has-icon-color is-style-logos-only is-content-justification-left is-layout-flex wp-container-outermost-social-sharing-is-layout-fc4fd283 wp-block-outermost-social-sharing-is-layout-flex\"><li style=\"color: #1a4548; \" class=\"outermost-social-sharing-link outermost-social-sharing-link-linkedin has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2022%2F09%2F21%2Fconnecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication%2F&#038;title=Connecting%20Power%20BI%20to%20remote%20SQL%20Server%20from%20outside%20the%20domain%20with%20Windows%20authentication\" aria-label=\"Share on LinkedIn\" rel=\"noopener nofollow\" target=\"_blank\" class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M19.7,3H4.3C3.582,3,3,3.582,3,4.3v15.4C3,20.418,3.582,21,4.3,21h15.4c0.718,0,1.3-0.582,1.3-1.3V4.3 C21,3.582,20.418,3,19.7,3z M8.339,18.338H5.667v-8.59h2.672V18.338z M7.004,8.574c-0.857,0-1.549-0.694-1.549-1.548 c0-0.855,0.691-1.548,1.549-1.548c0.854,0,1.547,0.694,1.547,1.548C8.551,7.881,7.858,8.574,7.004,8.574z M18.339,18.338h-2.669 v-4.177c0-0.996-0.017-2.278-1.387-2.278c-1.389,0-1.601,1.086-1.601,2.206v4.249h-2.667v-8.59h2.559v1.174h0.037 c0.356-0.675,1.227-1.387,2.526-1.387c2.703,0,3.203,1.779,3.203,4.092V18.338z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tShare on LinkedIn\t\t<\/span>\n\t<\/a>\n<\/li>\n\n\n<li style=\"color: #1a4548; \" class=\"outermost-social-sharing-link outermost-social-sharing-link-mail has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"mailto:?subject=Connecting%20Power%20BI%20to%20remote%20SQL%20Server%20from%20outside%20the%20domain%20with%20Windows%20authentication&#038;body=Connecting%20Power%20BI%20to%20remote%20SQL%20Server%20from%20outside%20the%20domain%20with%20Windows%20authentication%20&mdash;%20https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2022%2F09%2F21%2Fconnecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication%2F\" aria-label=\"Email this Page\"  class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M20,4H4C2.895,4,2,4.895,2,6v12c0,1.105,0.895,2,2,2h16c1.105,0,2-0.895,2-2V6C22,4.895,21.105,4,20,4z M20,8.236l-8,4.882 L4,8.236V6h16V8.236z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tEmail this Page\t\t<\/span>\n\t<\/a>\n<\/li>\n\n\n<li style=\"color: #1a4548; \" class=\"outermost-social-sharing-link outermost-social-sharing-link-whatsapp has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"https:\/\/api.whatsapp.com\/send?text=Connecting%20Power%20BI%20to%20remote%20SQL%20Server%20from%20outside%20the%20domain%20with%20Windows%20authentication%20&mdash;%20https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2022%2F09%2F21%2Fconnecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication%2F\" aria-label=\"Share on WhatsApp\" rel=\"noopener nofollow\" target=\"_blank\" class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M 12.011719 2 C 6.5057187 2 2.0234844 6.478375 2.0214844 11.984375 C 2.0204844 13.744375 2.4814687 15.462563 3.3554688 16.976562 L 2 22 L 7.2324219 20.763672 C 8.6914219 21.559672 10.333859 21.977516 12.005859 21.978516 L 12.009766 21.978516 C 17.514766 21.978516 21.995047 17.499141 21.998047 11.994141 C 22.000047 9.3251406 20.962172 6.8157344 19.076172 4.9277344 C 17.190172 3.0407344 14.683719 2.001 12.011719 2 z M 12.009766 4 C 14.145766 4.001 16.153109 4.8337969 17.662109 6.3417969 C 19.171109 7.8517969 20.000047 9.8581875 19.998047 11.992188 C 19.996047 16.396187 16.413812 19.978516 12.007812 19.978516 C 10.674812 19.977516 9.3544062 19.642812 8.1914062 19.007812 L 7.5175781 18.640625 L 6.7734375 18.816406 L 4.8046875 19.28125 L 5.2851562 17.496094 L 5.5019531 16.695312 L 5.0878906 15.976562 C 4.3898906 14.768562 4.0204844 13.387375 4.0214844 11.984375 C 4.0234844 7.582375 7.6067656 4 12.009766 4 z M 8.4765625 7.375 C 8.3095625 7.375 8.0395469 7.4375 7.8105469 7.6875 C 7.5815469 7.9365 6.9355469 8.5395781 6.9355469 9.7675781 C 6.9355469 10.995578 7.8300781 12.182609 7.9550781 12.349609 C 8.0790781 12.515609 9.68175 15.115234 12.21875 16.115234 C 14.32675 16.946234 14.754891 16.782234 15.212891 16.740234 C 15.670891 16.699234 16.690438 16.137687 16.898438 15.554688 C 17.106437 14.971687 17.106922 14.470187 17.044922 14.367188 C 16.982922 14.263188 16.816406 14.201172 16.566406 14.076172 C 16.317406 13.951172 15.090328 13.348625 14.861328 13.265625 C 14.632328 13.182625 14.464828 13.140625 14.298828 13.390625 C 14.132828 13.640625 13.655766 14.201187 13.509766 14.367188 C 13.363766 14.534188 13.21875 14.556641 12.96875 14.431641 C 12.71875 14.305641 11.914938 14.041406 10.960938 13.191406 C 10.218937 12.530406 9.7182656 11.714844 9.5722656 11.464844 C 9.4272656 11.215844 9.5585938 11.079078 9.6835938 10.955078 C 9.7955938 10.843078 9.9316406 10.663578 10.056641 10.517578 C 10.180641 10.371578 10.223641 10.267562 10.306641 10.101562 C 10.389641 9.9355625 10.347156 9.7890625 10.285156 9.6640625 C 10.223156 9.5390625 9.737625 8.3065 9.515625 7.8125 C 9.328625 7.3975 9.131125 7.3878594 8.953125 7.3808594 C 8.808125 7.3748594 8.6425625 7.375 8.4765625 7.375 z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tShare on WhatsApp\t\t<\/span>\n\t<\/a>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<p>As an external employee or consultant, you sometimes have to connect to on-premises data from a remote location. We recently ran into troubles while connecting to a MS SQL Server from a machine which was not in the same domain as the SQL Server. The user credentials and the VPN connection was in place but using Windows authentication, the following error occurred:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"496\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image.png\" alt=\"\" class=\"wp-image-16\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image.png 940w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-300x158.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-768x405.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><figcaption class=\"wp-element-caption\">Windows authentication with alternate credentials error<\/figcaption><\/figure>\n\n\n\n<p>Activating database credentials on the SQL Server for this account was not an option so we had to find a different solution. <\/p>\n\n\n\n<hr class=\"wp-block-separator alignwide has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-left\">The Solution<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">1.  Add hosts file entry<\/h4>\n\n\n\n<p>If you want to use the resolved name of your SQL Server instead of the IP address, make sure you have added the respective entry in your hosts file located at: <em>&#8220;C:\\Windows\\System32\\drivers\\etc\\hosts&#8221;<\/em><\/p>\n\n\n\n<p>The entry should contain the private IP address of the SQL Server and the corresponding name. In our case, the entry was added like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-1.png\" alt=\"\" class=\"wp-image-17\" style=\"width:644px;height:80px\" width=\"644\" height=\"80\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-1.png 537w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-1-300x37.png 300w\" sizes=\"auto, (max-width: 644px) 100vw, 644px\" \/><figcaption class=\"wp-element-caption\">hosts file mapping entry<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">2.  Install Power BI Desktop<\/h4>\n\n\n\n<p>This step requires the Power BI Desktop installation directly from the Microsoft Download Center. <a rel=\"noreferrer noopener\" href=\"https:\/\/aka.ms\/pbiSingleInstaller\" target=\"_blank\">Download Power BI Desktop<\/a><\/p>\n\n\n\n<p>After installing Power BI Desktop, locate the PBIDesktop.exe file. Without changing the default installation path, it is located at: <br><em>&#8220;C:\\Program Files\\Microsoft Power BI Desktop\\bin\\PBIDesktop.exe&#8221;<\/em><\/p>\n\n\n\n<p>Copy the path and write it down for later.<\/p>\n\n\n\n<p class=\"has-background\" style=\"background-color:#8dd2fc66\">The Power BI Desktop installation from the Microsoft Store<strong> does not work <\/strong>in this case.<\/p>\n\n\n\n<div class=\"wp-block-group is-layout-flow wp-block-group-is-layout-flow\">\n<h4 class=\"wp-block-heading\">3.  Connect your VPN Software<\/h4>\n\n\n\n<p>Make sure you are connected with your VPN software to the network from which the SQL Server is accessible.<\/p>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">4.  Run Power BI as a different user<\/h4>\n\n\n\n<p>We now want to run Power BI Desktop with the credentials for the Windows authentication on the SQL Server. This is possible using the runas command-line tool with the parameter &#8220;\/netonly&#8221; which indicates that the user information specified is for remote access only. Open a new command prompt window and type in:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>runas \/netonly \/user:&#91;domain]\\&#91;user] &#91;path\\to\\PBIDesktop.exe]<\/code><\/pre>\n\n\n\n<p>Where <br><strong>[domain]<\/strong> is the domain in which the user to authenticate with resides,<br><strong>[user]<\/strong> is the username which you want to use for authentication and<br><strong>[path\\to\\PBIDesktop.exe]<\/strong> is the copied path from step 2.<\/p>\n\n\n\n<p>In our case the command looks like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"244\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-3-1024x244.png\" alt=\"\" class=\"wp-image-20\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-3-1024x244.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-3-300x71.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-3-768x183.png 768w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-3.png 1092w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Command Prompt with the runas command<\/figcaption><\/figure>\n\n\n\n<p>You will be prompted for the password. You can copy paste or just type it in. CMD will not show what you have typed in so just press enter after providing your password. After this step, Power BI Desktop will start up.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">5.  Connect to SQL Server<\/h4>\n\n\n\n<p>In Power BI Desktop, click on &#8220;Get Data&#8221; and select &#8220;SQL Server&#8221;. Put in the IP address or the name of the server from step 1.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"482\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-4.png\" alt=\"\" class=\"wp-image-24\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-4.png 940w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-4-300x154.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-4-768x394.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><figcaption class=\"wp-element-caption\">Get Data from SQL Server<\/figcaption><\/figure>\n\n\n\n<p>For the authentication choose Windows and select \u201cUse my current credentials\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"447\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-7.png\" alt=\"\" class=\"wp-image-27\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-7.png 940w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-7-300x143.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-7-768x365.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><figcaption class=\"wp-element-caption\">Credentials for SQL Server<\/figcaption><\/figure>\n\n\n\n<p>If everything went right, you are now connected to the SQL Server<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"545\" height=\"258\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-8.png\" alt=\"\" class=\"wp-image-28\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-8.png 545w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image-8-300x142.png 300w\" sizes=\"auto, (max-width: 545px) 100vw, 545px\" \/><figcaption class=\"wp-element-caption\">Connected SQL Server<\/figcaption><\/figure>\n\n\n\n<p>There are of course many other reasons why the connection is not possible, regardless of the authentication method. MS SQL works with TCP port 1433 so make sure it is not blocked.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As an external employee or consultant, you sometimes have to connect to on-premises data from a remote location. We recently ran into troubles while connecting to a MS SQL Server from a machine which was not in the same domain as the SQL Server. The user credentials and the VPN connection was in place but [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[10,6,8],"class_list":["post-15","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","tag-authentication","tag-power-bi","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Connecting Power BI to remote SQL Server from outside the domain with Windows authentication - Syntera<\/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:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting Power BI to remote SQL Server from outside the domain with Windows authentication - Syntera\" \/>\n<meta property=\"og:description\" content=\"As an external employee or consultant, you sometimes have to connect to on-premises data from a remote location. We recently ran into troubles while connecting to a MS SQL Server from a machine which was not in the same domain as the SQL Server. The user credentials and the VPN connection was in place but [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/\" \/>\n<meta property=\"og:site_name\" content=\"Syntera\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-21T06:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-12T06:09:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image.png\" \/>\n<meta name=\"author\" content=\"Dominic Schranz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dominic Schranz\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/\",\"url\":\"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/\",\"name\":\"Connecting Power BI to remote SQL Server from outside the domain with Windows authentication - Syntera\",\"isPartOf\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/#website\"},\"datePublished\":\"2022-09-21T06:00:00+00:00\",\"dateModified\":\"2023-10-12T06:09:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/e038d1dcebeca2193c5503f78783988d\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.syntera.ch\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting Power BI to remote SQL Server from outside the domain with Windows authentication\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#website\",\"url\":\"https:\/\/www.syntera.ch\/blog\/\",\"name\":\"Syntera\",\"description\":\"translating data into business value.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.syntera.ch\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/e038d1dcebeca2193c5503f78783988d\",\"name\":\"Dominic Schranz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&d=mm&r=g\",\"caption\":\"Dominic Schranz\"},\"url\":\"https:\/\/www.syntera.ch\/blog\/author\/domi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connecting Power BI to remote SQL Server from outside the domain with Windows authentication - Syntera","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:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/","og_locale":"en_US","og_type":"article","og_title":"Connecting Power BI to remote SQL Server from outside the domain with Windows authentication - Syntera","og_description":"As an external employee or consultant, you sometimes have to connect to on-premises data from a remote location. We recently ran into troubles while connecting to a MS SQL Server from a machine which was not in the same domain as the SQL Server. The user credentials and the VPN connection was in place but [&hellip;]","og_url":"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/","og_site_name":"Syntera","article_published_time":"2022-09-21T06:00:00+00:00","article_modified_time":"2023-10-12T06:09:47+00:00","og_image":[{"url":"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2022\/09\/image.png"}],"author":"Dominic Schranz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dominic Schranz","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/","url":"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/","name":"Connecting Power BI to remote SQL Server from outside the domain with Windows authentication - Syntera","isPartOf":{"@id":"https:\/\/www.syntera.ch\/blog\/#website"},"datePublished":"2022-09-21T06:00:00+00:00","dateModified":"2023-10-12T06:09:47+00:00","author":{"@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/e038d1dcebeca2193c5503f78783988d"},"breadcrumb":{"@id":"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.syntera.ch\/blog\/2022\/09\/21\/connecting-power-bi-to-remote-sql-server-from-outside-the-domain-with-windows-authentication\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.syntera.ch\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting Power BI to remote SQL Server from outside the domain with Windows authentication"}]},{"@type":"WebSite","@id":"https:\/\/www.syntera.ch\/blog\/#website","url":"https:\/\/www.syntera.ch\/blog\/","name":"Syntera","description":"translating data into business value.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.syntera.ch\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/e038d1dcebeca2193c5503f78783988d","name":"Dominic Schranz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&d=mm&r=g","caption":"Dominic Schranz"},"url":"https:\/\/www.syntera.ch\/blog\/author\/domi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":17,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"predecessor-version":[{"id":401,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/15\/revisions\/401"}],"wp:attachment":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}