{"id":6437,"date":"2020-09-24T06:37:10","date_gmt":"2020-09-24T06:37:10","guid":{"rendered":"https:\/\/www.bodhost.com\/kb\/?p=6437"},"modified":"2026-02-26T14:03:10","modified_gmt":"2026-02-26T14:03:10","slug":"how-to-define-the-custom-port-for-ms-sql-remote-access","status":"publish","type":"post","link":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/","title":{"rendered":"How to Define the Custom Port for MS SQL Remote Access?"},"content":{"rendered":"

<\/strong><\/p>\r\n

If you want to assign a TCP\/IP port number to the SQL Server Database Engine. You must follow the steps given below-<\/p>\r\n\r\n\r\n\r\n

    \r\n
  1. Open SQL Server Management Studio and login to your database<\/li>\r\n
  2. Now, right-click on the server name in the left panel and choose Properties<\/li>\r\n
  3. Choose the Connections page on the left side and ensure that \u201cAllow remote connections to this server\u201d is checked. Now exit the SQL Server Management Studio
    \"\"<\/li>\r\n
  4. Now open the SQL Server Configuration Manager and expand the node SQL Server Network Now Select Protocols for your SQL Server Instance. Ensure that the TCP\/IP protocol enabled.
    \"MS<\/li>\r\n
  5. Right-click on the TCP\/IP and choose In the TCP\/IP Properties dialog box, click on the IP Addresses tab and scroll down to the IPALL section. Make sure that the TCP Dynamic Ports is empty and TCP Port set to your desired TCP Port.
    \"SQL<\/li>\r\n
  6. Click the Apply button and then OK to save your changes. Once successfully done, restart your SQL Server<\/li>\r\n
  7. Now you can still connect to your SQL Server Instance remotely with the help of SQL Server Management Studio.
    \"\"<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

    Note:<\/strong><\/p>\r\n\r\n\r\n\r\n

    If you still face a problem with your remote connection, it is most likely that you will have to configure your Firewall settings. Make sure that Firewall does not block your TCP Port.<\/em><\/p>\r\n

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

    If you want to assign a TCP\/IP port number to the SQL Server Database Engine. You must follow the steps given below- Open SQL Server Management Studio and login to…<\/p>\n

    Read More<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[857,837],"tags":[856,855,854],"class_list":["post-6437","post","type-post","status-publish","format-standard","hentry","category-sql","category-tutorial","tag-custom-port-for-ms-sql-remote-access","tag-sql","tag-sql-remote-access"],"yoast_head":"\nHow to Define the Custom Port for MS SQL Remote Access?<\/title>\n<meta name=\"description\" content=\"In this tutorial, you will learn now you can customize a port for remote access for MS SQL through a step-by-step guide.\" \/>\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.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Define the Custom Port for MS SQL Remote Access?\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn now you can customize a port for remote access for MS SQL through a step-by-step guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - bodHOST\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-24T06:37:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T14:03:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2020\/09\/Kb-image1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"539\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Paul Lopez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Lopez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/\"},\"author\":{\"name\":\"Paul Lopez\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/566ccff9a2fae4af852be8097b179813\"},\"headline\":\"How to Define the Custom Port for MS SQL Remote Access?\",\"datePublished\":\"2020-09-24T06:37:10+00:00\",\"dateModified\":\"2026-02-26T14:03:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/\"},\"wordCount\":228,\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Kb-image1-1.png\",\"keywords\":[\"Custom Port for MS SQL Remote Access\",\"SQL\",\"SQL Remote Access\"],\"articleSection\":[\"SQL\",\"Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/\",\"name\":\"How to Define the Custom Port for MS SQL Remote Access?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Kb-image1-1.png\",\"datePublished\":\"2020-09-24T06:37:10+00:00\",\"dateModified\":\"2026-02-26T14:03:10+00:00\",\"description\":\"In this tutorial, you will learn now you can customize a port for remote access for MS SQL through a step-by-step guide.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Kb-image1-1.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Kb-image1-1.png\",\"width\":600,\"height\":539},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-define-the-custom-port-for-ms-sql-remote-access\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/category\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Define the Custom Port for MS SQL Remote Access?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"alternateName\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"width\":240,\"height\":240,\"caption\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/566ccff9a2fae4af852be8097b179813\",\"name\":\"Paul Lopez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"caption\":\"Paul Lopez\"},\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/author\\\/paullopez\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Define the Custom Port for MS SQL Remote Access?","description":"In this tutorial, you will learn now you can customize a port for remote access for MS SQL through a step-by-step guide.","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.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/","og_locale":"en_US","og_type":"article","og_title":"How to Define the Custom Port for MS SQL Remote Access?","og_description":"In this tutorial, you will learn now you can customize a port for remote access for MS SQL through a step-by-step guide.","og_url":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/","og_site_name":"Knowledge Base - bodHOST","article_published_time":"2020-09-24T06:37:10+00:00","article_modified_time":"2026-02-26T14:03:10+00:00","og_image":[{"width":600,"height":539,"url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2020\/09\/Kb-image1-1.png","type":"image\/png"}],"author":"Paul Lopez","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Paul Lopez","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/#article","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/"},"author":{"name":"Paul Lopez","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/566ccff9a2fae4af852be8097b179813"},"headline":"How to Define the Custom Port for MS SQL Remote Access?","datePublished":"2020-09-24T06:37:10+00:00","dateModified":"2026-02-26T14:03:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/"},"wordCount":228,"publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2020\/09\/Kb-image1-1.png","keywords":["Custom Port for MS SQL Remote Access","SQL","SQL Remote Access"],"articleSection":["SQL","Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/","url":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/","name":"How to Define the Custom Port for MS SQL Remote Access?","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/#primaryimage"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2020\/09\/Kb-image1-1.png","datePublished":"2020-09-24T06:37:10+00:00","dateModified":"2026-02-26T14:03:10+00:00","description":"In this tutorial, you will learn now you can customize a port for remote access for MS SQL through a step-by-step guide.","breadcrumb":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/#primaryimage","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2020\/09\/Kb-image1-1.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2020\/09\/Kb-image1-1.png","width":600,"height":539},{"@type":"BreadcrumbList","@id":"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"SQL","item":"https:\/\/www.bodhost.com\/kb\/category\/sql\/"},{"@type":"ListItem","position":2,"name":"How to Define the Custom Port for MS SQL Remote Access?"}]},{"@type":"WebSite","@id":"https:\/\/www.bodhost.com\/kb\/#website","url":"https:\/\/www.bodhost.com\/kb\/","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","description":"","publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"alternateName":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bodhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bodhost.com\/kb\/#organization","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","url":"https:\/\/www.bodhost.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","width":240,"height":240,"caption":"Web Hosting Knowledge Base | bodHOST Hosting FAQ"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/566ccff9a2fae4af852be8097b179813","name":"Paul Lopez","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","caption":"Paul Lopez"},"url":"https:\/\/www.bodhost.com\/kb\/author\/paullopez\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/6437","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/comments?post=6437"}],"version-history":[{"count":6,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/6437\/revisions"}],"predecessor-version":[{"id":12006,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/6437\/revisions\/12006"}],"wp:attachment":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/media?parent=6437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/categories?post=6437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/tags?post=6437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}