{"id":215,"date":"2014-03-02T07:45:12","date_gmt":"2014-03-01T23:45:12","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=215"},"modified":"2014-03-05T23:53:39","modified_gmt":"2014-03-05T15:53:39","slug":"changing-sql-server-default-tcp-port-2","status":"publish","type":"post","link":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html","title":{"rendered":"Changing SQL Server Default TCP Port"},"content":{"rendered":"<p>Seperti diketahui bahwa Default TCP Port dari SQL Server adalah 1433. Sebagai langkah pengamanan, default TCP port tersebut direkomendasikan untuk diganti dengan nilai port lain.<!--more--><\/p>\n<p>Langkah-langkah untuk mengganti default TCP port adalah sebagai berikut (misal kita ganti dengan 1355, demo ini menggunakan SQL Server 2008 R2) :<\/p>\n<p>pertama kita masuk ke SQL Server Configuration Manager \u2013&gt; SQL Server Network Configuration \u2013&gt; Protocol for &lt;NamaInstance&gt;<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-216\" alt=\"port1\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1-300x102.png\" width=\"400\" height=\"202\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Kemudian klik kanan pada Protocol Name TCP\/IP lalu pilih Properties lalu pilihlah tab IP Addresseses . Terlihat jelas bahwa TCP Port default terdaftar pada semua IP Address yang ada.<\/p>\n<p>Kosongkan semua nilai yang ada di TCP Port pada setiap IP Address yang ada kecuali untuk IP Addresses IPAll. Kosongkan TCP Dynamic Port. Isi TCP Port pada IPAll dengan nilai 1355<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-217\" alt=\"port2\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port2.png\" width=\"405\" height=\"447\" srcset=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port2.png 405w, http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port2-271x300.png 271w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-218\" alt=\"port3\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port3.png\" width=\"497\" height=\"171\" srcset=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port3.png 497w, http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port3-300x103.png 300w\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Klik Ok, sesuai Warning Box diatas, kita restart Services dari SQL Server.<\/p>\n<p>Langkah selanjutnya adalah memasukkan Inbound Rules baru pada Firewall untuk port 1355.<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-219\" alt=\"port4\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port4.png\" width=\"728\" height=\"587\" srcset=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port4.png 728w, http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port4-300x241.png 300w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Setelah TCP Port 1355 di assign ke Inbound rules pada firewall, sampai langkah ini kita telah selasai mengganti TCP Port Default dari SQL Server.<\/p>\n<p>Agar Client bisa melakukan komunikasi dengan SQL Server yang telah berganti nilai TCP Portnya, Name Server nya perlu didampingi dengan nilai TCP portnya. Contoh penulisannya seperti Connectionstring berikut :<\/p>\n<div id=\"codeSnippetWrapper\">\n<div id=\"codeSnippet\">\n<pre>Provider=SQLNCLI10;Server=myServerAddress,1355;<\/pre>\n<pre>Database=myDataBase;Uid=myUsername; Pwd=myPassword;<\/pre>\n<\/div>\n<\/div>\n<p>Tampak pada penyebutan name server ditulis seperti ini :\u00a0<strong>myServerAddress,1355<\/strong>. demikian semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seperti diketahui bahwa Default TCP Port dari SQL Server adalah 1433. Sebagai langkah pengamanan, default TCP port tersebut direkomendasikan untuk diganti dengan nilai port lain.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html\">Continue reading<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":216,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[62,22,23],"class_list":["post-215","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-hardening","tag-security","tag-tcp-port"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Changing SQL Server Default TCP Port - Suherman Blog<\/title>\n<meta name=\"description\" content=\"Salahsatu teknik Hardening SQL Server dengan cara merubah Default TCP Port\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Changing SQL Server Default TCP Port - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Salahsatu teknik Hardening SQL Server dengan cara merubah Default TCP Port\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-01T23:45:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-03-05T15:53:39+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"537\" \/>\n\t<meta property=\"og:image:height\" content=\"184\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Changing SQL Server Default TCP Port\",\"datePublished\":\"2014-03-01T23:45:12+00:00\",\"dateModified\":\"2014-03-05T15:53:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html\"},\"wordCount\":217,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png\",\"keywords\":[\"Hardening\",\"Security\",\"TCP Port\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html\",\"url\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html\",\"name\":\"Changing SQL Server Default TCP Port - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png\",\"datePublished\":\"2014-03-01T23:45:12+00:00\",\"dateModified\":\"2014-03-05T15:53:39+00:00\",\"description\":\"Salahsatu teknik Hardening SQL Server dengan cara merubah Default TCP Port\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#primaryimage\",\"url\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png\",\"contentUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png\",\"width\":537,\"height\":184},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Changing SQL Server Default TCP Port\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"http:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Changing SQL Server Default TCP Port - Suherman Blog","description":"Salahsatu teknik Hardening SQL Server dengan cara merubah Default TCP Port","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":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html","og_locale":"en_US","og_type":"article","og_title":"Changing SQL Server Default TCP Port - Suherman Blog","og_description":"Salahsatu teknik Hardening SQL Server dengan cara merubah Default TCP Port","og_url":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-03-01T23:45:12+00:00","article_modified_time":"2014-03-05T15:53:39+00:00","og_image":[{"width":537,"height":184,"url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png","type":"image\/png"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Changing SQL Server Default TCP Port","datePublished":"2014-03-01T23:45:12+00:00","dateModified":"2014-03-05T15:53:39+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html"},"wordCount":217,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png","keywords":["Hardening","Security","TCP Port"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html","url":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html","name":"Changing SQL Server Default TCP Port - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png","datePublished":"2014-03-01T23:45:12+00:00","dateModified":"2014-03-05T15:53:39+00:00","description":"Salahsatu teknik Hardening SQL Server dengan cara merubah Default TCP Port","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#primaryimage","url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png","contentUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/03\/port1.png","width":537,"height":184},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/changing-sql-server-default-tcp-port-2.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Changing SQL Server Default TCP Port"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"http:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=215"}],"version-history":[{"count":6,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":230,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/215\/revisions\/230"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media\/216"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}