{"id":11768,"date":"2021-02-17T09:22:30","date_gmt":"2021-02-17T09:22:30","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=11768"},"modified":"2021-03-06T09:18:37","modified_gmt":"2021-03-06T09:18:37","slug":"configure-remote-access-connect-remote-sql-server2019","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/","title":{"rendered":"How to Configure Remote Access and Connect to a Remote SQL Server 2019?"},"content":{"rendered":"<p><strong>Watch this video for a step by step process on how to Configure Remote Access and Connect to a Remote SQL Server 2019<\/strong><\/p>\n<div class=\"youtube-video\" style=\"border: 1px solid #ddd;\"><iframe src=\"https:\/\/www.youtube.com\/embed\/lJ_WRSN_wD0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p>In this article, you will learn to configure remote access on a SQL Server and connect to a remote SQL Server.<\/p>\n<h3>Steps to Configure Remote Access on a SQL Server<\/h3>\n<p>1. Open <strong>Microsoft SQL Server Management Studio\u00a0<\/strong>by clicking on the <strong>Windows<\/strong> icon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11769\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min.jpg\" alt=\"\" width=\"635\" height=\"679\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min.jpg 635w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min-281x300.jpg 281w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/p>\n<p>2. Then you will be prompted to connect to the server, here click on <strong>Connect<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11792\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-sql-server-min.jpg\" alt=\"\" width=\"478\" height=\"316\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-sql-server-min.jpg 478w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-sql-server-min-300x198.jpg 300w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/p>\n<p>3. To enable remote connection on SQL Server, right \u2013 click on the server and click on the <strong>Properties<\/strong> option. In the <strong>Server Properties<\/strong> dialog under the <strong>Connections<\/strong> tab, tick the <strong>Allow remote connections to this server<\/strong> option and click on <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11770\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/properties-min.jpg\" alt=\"\" width=\"339\" height=\"489\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/properties-min.jpg 339w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/properties-min-208x300.jpg 208w\" sizes=\"auto, (max-width: 339px) 100vw, 339px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11794\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/allow-remote-connections-min.jpg\" alt=\"\" width=\"699\" height=\"657\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/allow-remote-connections-min.jpg 699w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/allow-remote-connections-min-300x282.jpg 300w\" sizes=\"auto, (max-width: 699px) 100vw, 699px\" \/><\/p>\n<p>4. Click on the <strong>Windows <\/strong>icon on the desktop and click on <strong>Microsoft SQL Server 2019<\/strong>. Then click on the drop-down and select the <strong>SQL Server Configuration Manager<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11773\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-configuration-min.jpg\" alt=\"\" width=\"626\" height=\"675\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-configuration-min.jpg 626w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-configuration-min-278x300.jpg 278w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><\/p>\n<p>5. Then from the <strong>SQL Server Network Configuration<\/strong> select <strong>Protocols<\/strong> for your server. Ensure that<strong> TCP\/IP<\/strong> protocol is enabled, if it\u2019s not then right-click on <strong>TCP\/IP<\/strong> and select the <strong>Properties<\/strong> option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11774\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/tcp-protocols-min.jpg\" alt=\"\" width=\"943\" height=\"712\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/tcp-protocols-min.jpg 943w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/tcp-protocols-min-300x227.jpg 300w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/tcp-protocols-min-768x580.jpg 768w\" sizes=\"auto, (max-width: 943px) 100vw, 943px\" \/><\/p>\n<p>6. Under the <strong>Protocol<\/strong> tab, click on the drop-down for <strong>Enabled<\/strong> and select <strong>Yes<\/strong>. Then go to the<strong> IP Addresses<\/strong> tab and scroll down to <strong>IPAII<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11776\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/protocol-yes1-min.jpg\" alt=\"\" width=\"408\" height=\"470\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/protocol-yes1-min.jpg 408w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/protocol-yes1-min-260x300.jpg 260w\" sizes=\"auto, (max-width: 408px) 100vw, 408px\" \/><\/p>\n<p>7. If the <strong>TCP Dynamic Ports<\/strong> dialog box displays <strong>0<\/strong>, it indicates that the<strong> Database Engine<\/strong> is listening on dynamic ports, delete the 0 and leave the TCP Dynamic Ports blank and set the <strong>TCP Port<\/strong> to <strong>1433<\/strong> and click on <strong>Apply<\/strong>. SQL Server uses port 1433 as the default instance.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11777\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/ipaii-min.jpg\" alt=\"\" width=\"409\" height=\"471\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/ipaii-min.jpg 409w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/ipaii-min-261x300.jpg 261w\" sizes=\"auto, (max-width: 409px) 100vw, 409px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11778\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/tcp-port-min.jpg\" alt=\"\" width=\"410\" height=\"472\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/tcp-port-min.jpg 410w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/tcp-port-min-261x300.jpg 261w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11779\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/confirmation-for-changes-port-min.jpg\" alt=\"\" width=\"480\" height=\"162\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/confirmation-for-changes-port-min.jpg 480w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/confirmation-for-changes-port-min-300x101.jpg 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/p>\n<p>8. You will be prompted for confirmation, click on <strong>OK<\/strong>. Then again click on <strong>OK<\/strong> on the TCP\/IP Properties.<\/p>\n<p>9. From the left pane of <strong>SQL Server Configuration Manager<\/strong>, click <strong>SQL Server Services<\/strong> and right-click <strong>SQL Server<\/strong>, and click <strong>Restart<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11780\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-services-min.jpg\" alt=\"\" width=\"943\" height=\"714\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-services-min.jpg 943w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-services-min-300x227.jpg 300w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-services-min-768x581.jpg 768w\" sizes=\"auto, (max-width: 943px) 100vw, 943px\" \/><\/p>\n<h3>Steps to Configure a Windows Firewall for Database Engine Access<\/h3>\n<p>For adding a firewall exception for the 1433 port, follow the below steps:<\/p>\n<p>1. Click on <strong>Windows<\/strong> icon. Then click on <strong>Windows Administrative Tools <\/strong>drop-down, scroll-down and select the <strong>Windows Firewall with Advanced Security<\/strong> option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11781\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/windows-firewall-advanced-min.jpg\" alt=\"\" width=\"298\" height=\"959\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/windows-firewall-advanced-min.jpg 298w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/windows-firewall-advanced-min-93x300.jpg 93w\" sizes=\"auto, (max-width: 298px) 100vw, 298px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>2. In the <strong>Windows Firewall with Advanced Security<\/strong> dialog, click on the <strong>Inbound Rules<\/strong> option in the left panel and select the <strong>New Rule<\/strong> from the <strong>Actions<\/strong> panel. This will open the <strong>New Inbound Rule Wizard<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-11783\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/inbound-rules1-min-1024x763.jpg\" alt=\"\" width=\"1024\" height=\"763\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/inbound-rules1-min-1024x763.jpg 1024w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/inbound-rules1-min-300x224.jpg 300w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/inbound-rules1-min-768x573.jpg 768w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/inbound-rules1-min.jpg 1045w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>3. In the <strong>New Inbound Rule Wizard<\/strong>, under <strong>Rule Type<\/strong>, click on the <strong>Port<\/strong> option and click <strong>Next<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11784\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/port-min.jpg\" alt=\"\" width=\"711\" height=\"579\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/port-min.jpg 711w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/port-min-300x244.jpg 300w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><\/p>\n<p>4. In the <strong>Protocol and Ports<\/strong> window, mention the protocols and ports to which a rule applies. Select the <strong>TCP<\/strong> option under <strong>Does this rule apply to TCP or UDP?<\/strong> and in the <strong>Specific local ports<\/strong>, text box enter the <strong>1433<\/strong> port, and click <strong>Next<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11785\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/protocol-port-min.jpg\" alt=\"\" width=\"712\" height=\"579\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/protocol-port-min.jpg 712w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/protocol-port-min-300x244.jpg 300w\" sizes=\"auto, (max-width: 712px) 100vw, 712px\" \/><\/p>\n<p>5. In the <strong>Action<\/strong> window, select the<strong> Allow the connection<\/strong> option to specify the action to be taken when a connection matches the conditions specified in the rule and click on <strong>Next<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11786\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/action-min.jpg\" alt=\"\" width=\"709\" height=\"581\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/action-min.jpg 709w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/action-min-300x246.jpg 300w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><\/p>\n<p>6. In the <strong>Profile<\/strong> window, specify the profile for which the rule applies. Here we have selected <strong>Domain<\/strong>. Then click on <strong>Next<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11787\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/profile-min.jpg\" alt=\"\" width=\"712\" height=\"577\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/profile-min.jpg 712w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/profile-min-300x243.jpg 300w\" sizes=\"auto, (max-width: 712px) 100vw, 712px\" \/><\/p>\n<p>7. In the <strong>Name<\/strong> window, enter the name of the created rule and click on <strong>Finish<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11788\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/name-min-1.jpg\" alt=\"\" width=\"710\" height=\"579\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/name-min-1.jpg 710w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/name-min-1-300x245.jpg 300w\" sizes=\"auto, (max-width: 710px) 100vw, 710px\" \/><\/p>\n<p>8. You can now see the created rule in the list of inbound rules.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-11789\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/new-rule-added-min-1024x767.jpg\" alt=\"\" width=\"1024\" height=\"767\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/new-rule-added-min-1024x767.jpg 1024w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/new-rule-added-min-300x225.jpg 300w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/new-rule-added-min-768x575.jpg 768w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/new-rule-added-min.jpg 1043w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>9. Now to connect to a remote server using the <strong>Windows Authentication<\/strong>, go to <strong>Server Properties<\/strong> and under the <strong>Security<\/strong> tab set the <strong>Server authentication to SQL Server<\/strong> <strong>and Windows Authentication mode <\/strong>and click on <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11790\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/security-min.jpg\" alt=\"\" width=\"693\" height=\"655\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/security-min.jpg 693w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/security-min-300x284.jpg 300w\" sizes=\"auto, (max-width: 693px) 100vw, 693px\" \/><\/p>\n<p>10. Then you will be prompted for restarting the server or else the changes won&#8217;t be reflected. Here, click on <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11796\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/security-warning-min.jpg\" alt=\"\" width=\"604\" height=\"129\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/security-warning-min.jpg 604w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/security-warning-min-300x64.jpg 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p>In this way, you can configure remote access and connect to a remote SQL server 2019.<\/p>\n<p><script type=\"application\/ld+json\">{\n  \"@context\": \"http:\/\/schema.org\",\n  \"@type\": \"VideoObject\",\n  \"name\": \"How to Configure Remote Access and Connect to a Remote SQL Server 2019? | MilesWeb\",\n  \"description\": \"Here's an in-depth guide on how to configure remote access and connect to a remote SQL server 2019: https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/  Give a thumbs up \ud83d\udc4d if you liked this video.  Subscribe to our channel and get notified for all the latest videos.  To know more about web hosting visit our website - https:\/\/www.milesweb.in\",\n  \"thumbnailUrl\": \"https:\/\/i.ytimg.com\/vi\/lJ_WRSN_wD0\/default.jpg\",\n  \"uploadDate\": \"2021-03-05T06:30:02Z\",\n  \"duration\": \"PT6M12S\",\n  \"embedUrl\": \"https:\/\/www.youtube.com\/embed\/lJ_WRSN_wD0\",\n  \"interactionCount\": \"7\"\n}<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Watch this video for a step by step process on how to Configure Remote Access and Connect to a Remote SQL Server 2019 In this article, you will learn to configure remote access on a SQL Server and connect to a remote SQL Server. Steps to Configure Remote Access on a SQL Server 1. Open [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,1884],"tags":[1885,1886,1888,1887,1889,1867],"class_list":["post-11768","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-howtos","category-windows-server","tag-configure-remote-access","tag-connect-to-a-remote-sql-server","tag-remote-access-to-sql-server","tag-remote-sql-server","tag-remote-sql-server-2019","tag-windows-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Configure Remote Access and Connect to a Remote SQL Server 2019<\/title>\n<meta name=\"description\" content=\"The article reveals steps to configure remote access and connect to a remote SQL server.\" \/>\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.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configure Remote Access and Connect to a Remote SQL Server 2019\" \/>\n<meta property=\"og:description\" content=\"The article reveals steps to configure remote access and connect to a remote SQL server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-17T09:22:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-06T09:18:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min.jpg\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/\"},\"author\":{\"name\":\"Pallavi Godse\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"headline\":\"How to Configure Remote Access and Connect to a Remote SQL Server 2019?\",\"datePublished\":\"2021-02-17T09:22:30+00:00\",\"dateModified\":\"2021-03-06T09:18:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/\"},\"wordCount\":589,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/open-sql-server-management-min.jpg\",\"keywords\":[\"configure remote access\",\"connect to a remote SQL server\",\"remote access to SQL server\",\"remote SQL server\",\"remote SQL server 2019\",\"windows server\"],\"articleSection\":[\"How-Tos\",\"Windows Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/\",\"name\":\"Configure Remote Access and Connect to a Remote SQL Server 2019\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/open-sql-server-management-min.jpg\",\"datePublished\":\"2021-02-17T09:22:30+00:00\",\"dateModified\":\"2021-03-06T09:18:37+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"The article reveals steps to configure remote access and connect to a remote SQL server.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/open-sql-server-management-min.jpg\",\"contentUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/open-sql-server-management-min.jpg\",\"width\":635,\"height\":679},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/configure-remote-access-connect-remote-sql-server2019\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Configure Remote Access and Connect to a Remote SQL Server 2019?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#website\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"sameAs\":[\"https:\\\/\\\/www.milesweb.in\"],\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/author\\\/pallavi\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configure Remote Access and Connect to a Remote SQL Server 2019","description":"The article reveals steps to configure remote access and connect to a remote SQL server.","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.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/","og_locale":"en_US","og_type":"article","og_title":"Configure Remote Access and Connect to a Remote SQL Server 2019","og_description":"The article reveals steps to configure remote access and connect to a remote SQL server.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-02-17T09:22:30+00:00","article_modified_time":"2021-03-06T09:18:37+00:00","og_image":[{"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min.jpg","type":"","width":"","height":""}],"author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/"},"author":{"name":"Pallavi Godse","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"headline":"How to Configure Remote Access and Connect to a Remote SQL Server 2019?","datePublished":"2021-02-17T09:22:30+00:00","dateModified":"2021-03-06T09:18:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/"},"wordCount":589,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min.jpg","keywords":["configure remote access","connect to a remote SQL server","remote access to SQL server","remote SQL server","remote SQL server 2019","windows server"],"articleSection":["How-Tos","Windows Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/","name":"Configure Remote Access and Connect to a Remote SQL Server 2019","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min.jpg","datePublished":"2021-02-17T09:22:30+00:00","dateModified":"2021-03-06T09:18:37+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"The article reveals steps to configure remote access and connect to a remote SQL server.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min.jpg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/open-sql-server-management-min.jpg","width":635,"height":679},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/configure-remote-access-connect-remote-sql-server2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Configure Remote Access and Connect to a Remote SQL Server 2019?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","sameAs":["https:\/\/www.milesweb.in"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/pallavi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=11768"}],"version-history":[{"count":14,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11768\/revisions"}],"predecessor-version":[{"id":12162,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11768\/revisions\/12162"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=11768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=11768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=11768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}