{"id":1816,"date":"2021-09-23T22:42:37","date_gmt":"2021-09-23T19:42:37","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1816"},"modified":"2021-09-23T22:45:06","modified_gmt":"2021-09-23T19:45:06","slug":"windows-firewall-sql-ports","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/windows-firewall-sql-ports\/","title":{"rendered":"Windows Firewall SQL Ports"},"content":{"rendered":"\n<p>PowerShell Komutlar\u0131<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>New-NetFirewallRule -DisplayName \"SQLServer default instance\" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>New-NetFirewallRule -DisplayName \"SQLServer Browser service\" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow<\/code><\/pre>\n\n\n\n<p>CMD<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT  \n<\/code><\/pre>\n\n\n\n<p>MSSQL Ba\u011flant\u0131 Portlar\u0131;<br>TCP\u00a0<strong>1433<\/strong>,\u00a0<strong>4022<\/strong>,\u00a0<strong>135<\/strong>,\u00a0<strong>1434<\/strong>, UDP\u00a0<strong>1434<\/strong>.<\/p>\n\n\n\n<p># <em>wf.msc<\/em> (Windows Firewall) > Gelen Kurallar<br><code>C:\\Program Files\\Microsoft SQL Server\\MSSQL15.&lt;InstanceName>\\MSSQL\\Binn\\sqlservr.exe<\/code><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PowerShell Komutlar\u0131 CMD MSSQL Ba\u011flant\u0131 Portlar\u0131;TCP\u00a01433,\u00a04022,\u00a0135,\u00a01434, UDP\u00a01434. # wf.msc (Windows Firewall) > Gelen KurallarC:\\Program Files\\Microsoft SQL Server\\MSSQL15.&lt;InstanceName>\\MSSQL\\Binn\\sqlservr.exe<\/p>\n","protected":false},"author":2,"featured_media":1817,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1096,32,451],"tags":[],"_links":{"self":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1816"}],"collection":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/comments?post=1816"}],"version-history":[{"count":4,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1816\/revisions"}],"predecessor-version":[{"id":1821,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1816\/revisions\/1821"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media\/1817"}],"wp:attachment":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media?parent=1816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}