{"id":1986,"date":"2026-09-12T17:49:46","date_gmt":"2026-09-12T14:49:46","guid":{"rendered":"https:\/\/narhost.com\/destek\/mssql-port-degistirme\/"},"modified":"2026-09-12T17:49:46","modified_gmt":"2026-09-12T14:49:46","slug":"mssql-port-degistirme","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/mssql-port-degistirme\/","title":{"rendered":"MSSQL Port De\u011fi\u015ftirme ve Servisi Yeniden Ba\u015flatma"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son g\u00f6zden ge\u00e7irme: Eyl\u00fcl 2026 \u00b7 SQL Server Configuration Manager (Microsoft Learn) resmi dok\u00fcman\u0131na g\u00f6re<\/p>\n<div id=\"hizli-cozum\" class=\"ai-box ai-box--cozum\">\n<p class=\"ai-box-title\">H\u0131zl\u0131 \u00e7\u00f6z\u00fcm<\/p>\n<p><strong>MSSQL port de\u011fi\u015ftirme<\/strong> i\u015flemi SQL Server Configuration Manager&#8217;da TCP\/IP protokol\u00fcn\u00fcn IPAll b\u00f6l\u00fcm\u00fcne yeni port numaras\u0131n\u0131 yaz\u0131p servisi yeniden ba\u015flatmaktan ibarettir; sunucunuzda y\u00f6netici olarak uygulay\u0131n.<\/p>\n<ol>\n<li>SQL Server Configuration Manager&#8217;\u0131 a\u00e7\u0131n, <strong>SQL Server Network Configuration \u2192 Protocols for MSSQLSERVER<\/strong> d\u00fc\u011f\u00fcm\u00fcne gidin.<\/li>\n<li><strong>TCP\/IP<\/strong> \u00fczerine \u00e7ift t\u0131klay\u0131n, <strong>IP Addresses<\/strong> sekmesinde <strong>IPAll<\/strong> b\u00f6l\u00fcm\u00fcn\u00fc bulun ve <strong>TCP Port<\/strong> alan\u0131na yeni port numaras\u0131n\u0131 yaz\u0131n.<\/li>\n<li><strong>SQL Server Services<\/strong> d\u00fc\u011f\u00fcm\u00fcnden <strong>SQL Server (MSSQLSERVER)<\/strong> servisine sa\u011f t\u0131klay\u0131p <strong>Restart<\/strong>&#8216;\u0131 se\u00e7in.<\/li>\n<li>G\u00fcvenlik duvar\u0131nda yeni portu a\u00e7\u0131n ve <code>Get-NetTCPConnection -LocalPort &lt;yeni-port&gt;<\/code> ile dinlendi\u011fini do\u011frulay\u0131n.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>Yok \u2014 SQL Server Configuration Manager Windows&#8217;un kendi bile\u015fenidir<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Windows Server 2019, Windows Server 2022 + SQL Server (Standard\/Express)<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>Sunucuda y\u00f6netici (Administrator) hesab\u0131<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/vds-sunucu\" title=\"Narhost VDS Sunucu \u2014 Windows Server se\u00e7enekleri\">VDS Sunucu<\/a><\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>Sunucunuzda y\u00f6netici yetkili bir hesapla oturum a\u00e7abildi\u011finizi do\u011frulay\u0131n.<\/li>\n<li>Varsay\u0131lan m\u0131 yoksa adland\u0131r\u0131lm\u0131\u015f (named) bir \u00f6rnek mi \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131z\u0131 bilin; Configuration Manager&#8217;da d\u00fc\u011f\u00fcm ad\u0131 buna g\u00f6re de\u011fi\u015fir.<\/li>\n<li>Ba\u011fl\u0131 uygulamalar\u0131n ba\u011flant\u0131 dizesini (connection string) yeni port ile g\u00fcncellemeniz gerekece\u011fini unutmay\u0131n.<\/li>\n<li>G\u00fcvenlik duvar\u0131nda yeni port i\u00e7in kural ekleme yetkiniz oldu\u011fundan emin olun; bu ad\u0131m atlan\u0131rsa ba\u011flant\u0131 tamamen kesilir.<\/li>\n<\/ul>\n<\/div>\n<h2>MSSQL Port De\u011fi\u015ftirme Neden Gerekir<\/h2>\n<p>Varsay\u0131lan MSSQL portu 1433&#8217;t\u00fcr ve internete a\u00e7\u0131k her SQL Server \u00f6rne\u011finde otomatik tarama ara\u00e7lar\u0131n\u0131n ilk denedi\u011fi port budur. MSSQL port de\u011fi\u015ftirme ba\u011flant\u0131y\u0131 g\u00f6r\u00fcnmez yapmaz ama standart port \u00fczerinden yap\u0131lan otomatik ke\u015fif ve kaba kuvvet denemelerinin b\u00fcy\u00fck k\u0131sm\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rak\u0131r. Ayn\u0131 sunucuda birden fazla SQL Server \u00f6rne\u011fi \u00e7al\u0131\u015ft\u0131r\u0131yorsan\u0131z her \u00f6rne\u011fe ayr\u0131 bir sabit port atamak ba\u011flant\u0131 y\u00f6netimini de kolayla\u015ft\u0131r\u0131r.<\/p>\n<div class=\"highlight-box\">\n<p class=\"label\">Bilgi<\/p>\n<p>Microsoft&#8217;un kendi dok\u00fcman\u0131 port de\u011fi\u015ftirmeyi tek ba\u015f\u0131na g\u00fcvenlik \u00f6nlemi saymaz; port taramas\u0131 h\u00e2l\u00e2 m\u00fcmk\u00fcnd\u00fcr. G\u00fc\u00e7l\u00fc kimlik do\u011frulama ve g\u00fcvenlik duvar\u0131 k\u0131s\u0131tlamas\u0131 ile birlikte uygulanmal\u0131d\u0131r.<\/p>\n<\/div>\n<figure class=\"nh-sema\"><img src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/mssql-port-degistirme-sema-narhost.webp\" alt=\"MSSQL port de\u011fi\u015ftirme ak\u0131\u015f \u015femas\u0131 \u2014 Configuration Manager, TCP port ayar\u0131, servis yeniden ba\u015flatma ve do\u011frulama ad\u0131mlar\u0131\" width=\"1200\" height=\"500\" loading=\"lazy\" decoding=\"async\"><figcaption>D\u00f6rt ad\u0131m: Configuration Manager, TCP port ayar\u0131, servisi yeniden ba\u015flatma, portu do\u011frulama.<\/figcaption><\/figure>\n<h2>Ad\u0131m Ad\u0131m MSSQL Port De\u011fi\u015ftirme<\/h2>\n<h3>Y\u00f6ntem 1 \u2014 SQL Server Configuration Manager (resm\u00ee y\u00f6ntem)<\/h3>\n<ol class=\"kb-adimlar\">\n<li><strong>SQL Server Configuration Manager&#8217;\u0131 a\u00e7\u0131n.<\/strong> Ba\u015flat men\u00fcs\u00fcnde aray\u0131p y\u00f6netici olarak \u00e7al\u0131\u015ft\u0131r\u0131n; konsol b\u00f6lmesinde <strong>SQL Server Network Configuration<\/strong>&#8216;\u0131 geni\u015fletip <strong>Protocols for MSSQLSERVER<\/strong>&#8216;\u0131 se\u00e7in (adland\u0131r\u0131lm\u0131\u015f \u00f6rnekte d\u00fc\u011f\u00fcm ad\u0131 \u00f6rnek ad\u0131n\u0131z\u0131 ta\u015f\u0131r).\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: sa\u011f b\u00f6lmede TCP\/IP, Named Pipes gibi protokoller listelenir.<\/p>\n<\/li>\n<li><strong>TCP\/IP<\/strong> sat\u0131r\u0131na \u00e7ift t\u0131klay\u0131n, a\u00e7\u0131lan pencerede <strong>IP Addresses<\/strong> sekmesine ge\u00e7in. Listede IP1, IP2 gibi adresler ve en altta <strong>IPAll<\/strong> b\u00f6l\u00fcm\u00fc g\u00f6r\u00fcn\u00fcr.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: IPAll b\u00f6l\u00fcm\u00fcnde <code>TCP Dynamic Ports<\/code> ve <code>TCP Port<\/code> alanlar\u0131 g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/li>\n<li><strong>IPAll<\/strong> b\u00f6l\u00fcm\u00fcnde <code>TCP Dynamic Ports<\/code> alan\u0131ndaki <code>0<\/code> de\u011ferini silin, <code>TCP Port<\/code> alan\u0131na se\u00e7ti\u011finiz yeni port numaras\u0131n\u0131 yaz\u0131n ve <strong>OK<\/strong> ile onaylay\u0131n.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: pencere kapan\u0131r, ayar kaydedilir ama servis yeniden ba\u015flat\u0131lana kadar etkin olmaz.<\/p>\n<\/li>\n<li><strong>SQL Server Services<\/strong> d\u00fc\u011f\u00fcm\u00fcne ge\u00e7in, <strong>SQL Server (MSSQLSERVER)<\/strong> sat\u0131r\u0131na sa\u011f t\u0131klay\u0131p <strong>Restart<\/strong>&#8216;\u0131 se\u00e7in. <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/configure-a-server-to-listen-on-a-specific-tcp-port\" title=\"SQL Server&#039;\u0131 belirli bir TCP portunu dinleyecek \u015fekilde yap\u0131land\u0131rma \u2014 Microsoft Learn resmi dok\u00fcman\u0131\" target=\"_blank\" rel=\"noopener\">Microsoft&#8217;un resmi dok\u00fcman\u0131na g\u00f6re<\/a> yeni port ancak bu yeniden ba\u015flatmadan sonra dinlenmeye ba\u015flar.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: servis durur ve yeniden ba\u015flar; birka\u00e7 saniye s\u00fcrer.<\/p>\n<\/li>\n<\/ol>\n<h3>Servisi ve Portu Genel Komutlarla Do\u011frulama<\/h3>\n<p>SQL Server servisinin durumunu ve dinledi\u011fi portu genel Windows komutlar\u0131yla kontrol edebilirsiniz. Test sunucumuzda SQL Server kurulu olmad\u0131\u011f\u0131 i\u00e7in a\u015fa\u011f\u0131daki \u00e7\u0131kt\u0131 servisin bulunmad\u0131\u011f\u0131n\u0131 g\u00f6steriyor; kurulu bir sunucuda ayn\u0131 komut <code>MSSQLSERVER<\/code> servisinin ad\u0131n\u0131 ve durumunu listeler.<\/p>\n<pre><code class=\"language-powershell\">Get-Service -Name '*SQL*'<\/code><\/pre>\n<p class=\"kb-cikti\">Test sunucumuzdaki ger\u00e7ek \u00e7\u0131kt\u0131: servis bulunamad\u0131 (SQL Server kurulu de\u011fil). Kurulu bir sunucuda beklenen \u00e7\u0131kt\u0131: <code>Status Running, Name MSSQLSERVER<\/code>.<\/p>\n<pre><code class=\"language-powershell\">Get-NetTCPConnection -LocalPort 1433 -State Listen<\/code><\/pre>\n<p class=\"kb-cikti\">Test sunucumuzdaki ger\u00e7ek \u00e7\u0131kt\u0131: sonu\u00e7 bo\u015f (1433 portunda dinleyen yok). Kurulu ve \u00e7al\u0131\u015fan bir \u00f6rnekte bu komut <code>State Listen<\/code> sat\u0131r\u0131yla d\u00f6ner; port de\u011fi\u015ftirdiyseniz numaray\u0131 g\u00fcncelleyip tekrar \u00e7al\u0131\u015ft\u0131r\u0131n.<\/p>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Yeni portla <code>Get-NetTCPConnection -LocalPort &lt;yeni-port&gt; -State Listen<\/code> \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda bir <code>Listen<\/code> sat\u0131r\u0131 g\u00f6rmelisiniz; <code>netstat -ano | findstr :&lt;yeni-port&gt;<\/code> ile de ayn\u0131 sonucu do\u011frulayabilirsiniz. Eski port olan 1433 art\u0131k yan\u0131t vermemelidir.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00c7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>\u0130stemci uygulama ba\u011flanam\u0131yor.<\/strong> Ba\u011flant\u0131 dizesinde port belirtilmemi\u015f olabilir; sunucu ad\u0131n\u0131n sonuna <code>,yeni-port<\/code> ekleyin ya da bir alias tan\u0131mlay\u0131n.<\/li>\n<li><strong>SQL Server Browser servisi devrede ama adland\u0131r\u0131lm\u0131\u015f \u00f6rnek bulunam\u0131yor.<\/strong> Browser servisi dinamik port bildirir; sabit port kullan\u0131yorsan\u0131z istemci taraf\u0131nda adres ve portu a\u00e7\u0131k\u00e7a yazman\u0131z gerekir.<\/li>\n<li><strong>Yeni port h\u00e2l\u00e2 dinlemiyor.<\/strong> Restart ad\u0131m\u0131 atlanm\u0131\u015f olabilir; <code>Get-Service MSSQLSERVER<\/code> ile servisin ger\u00e7ekten yeniden ba\u015flad\u0131\u011f\u0131n\u0131 kontrol edin.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Talebe \u015funlar\u0131 ekleyin: sunucu ad\u0131, eski ve yeni port numaras\u0131, SQL Server s\u00fcr\u00fcm\u00fc ve \u00f6rnek ad\u0131 (default\/named), ald\u0131\u011f\u0131n\u0131z hata mesaj\u0131 birebir.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\" title=\"Narhost destek talebi olu\u015ftur\">Destek talebi a\u00e7<\/a><\/div>\n<div class=\"kb-ilgili\">\n<p class=\"label\">Sonraki ad\u0131mlar<\/p>\n<ul>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucu-rdp-yonetimi-rehberi\/\" title=\"Windows sunucu y\u00f6netimi rehberi \u2014 Narhost Destek\">Windows sunucu y\u00f6netimi kartlar\u0131n\u0131n tamam\u0131<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucuda-mssql-sql-server-kurulumu\/\" title=\"Windows sunucuda MSSQL SQL Server kurulumu \u2014 Narhost Destek\">MSSQL SQL Server kurulumu<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/mssql-veritabani-olusturma-kullanici-yetkilendirme\/\" title=\"MSSQL veritaban\u0131 olu\u015fturma ve kullan\u0131c\u0131 yetkilendirme \u2014 Narhost Destek\">Veritaban\u0131 olu\u015fturma ve kullan\u0131c\u0131 yetkilendirme<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucuda-mssql-veri-yolu-degistirme\/\" title=\"Windows sunucuda MSSQL veri yolu de\u011fi\u015ftirme \u2014 Narhost Destek\">MSSQL veri yolu de\u011fi\u015ftirme<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a Sorulan Sorular<\/h2>\n<h3>MSSQL port de\u011fi\u015ftirme sunucuyu tamamen g\u00fcvenli yapar m\u0131?<\/h3>\n<p>Hay\u0131r. Microsoft&#8217;un kendi dok\u00fcman\u0131na g\u00f6re port taramas\u0131 h\u00e2l\u00e2 m\u00fcmk\u00fcnd\u00fcr; port de\u011fi\u015ftirmek yaln\u0131zca otomatik ke\u015fif denemelerinin b\u00fcy\u00fck k\u0131sm\u0131n\u0131 azalt\u0131r. G\u00fc\u00e7l\u00fc kimlik do\u011frulama ve g\u00fcvenlik duvar\u0131 k\u0131s\u0131tlamas\u0131yla birlikte kullan\u0131lmal\u0131d\u0131r.<\/p>\n<h3>Hangi port numaras\u0131n\u0131 se\u00e7meliyim?<\/h3>\n<p>1024 ile 49151 aras\u0131nda, ba\u015fka bir servisin kullanmad\u0131\u011f\u0131 bir numara se\u00e7in; IANA&#8217;n\u0131n port kay\u0131tlar\u0131na bakarak \u00e7ak\u0131\u015fmay\u0131 \u00f6nleyebilirsiniz.<\/p>\n<h3>Bu i\u015flemi payla\u015f\u0131ml\u0131 Windows hostingde yapabilir miyim?<\/h3>\n<p>Hay\u0131r. MSSQL port de\u011fi\u015ftirme yaln\u0131zca kendi Windows Server&#8217;\u0131n\u0131z\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131 VPS veya VDS \u00fcr\u00fcnlerinde uygulan\u0131r; Narhost&#8217;un VPS\/VDS hatlar\u0131 y\u00f6netimsizdir, bu ayar\u0131 sunucunuzda siz yapars\u0131n\u0131z.<\/p>\n<h3>Adland\u0131r\u0131lm\u0131\u015f (named) \u00f6rnekte ad\u0131m de\u011fi\u015fir mi?<\/h3>\n<p>D\u00fc\u011f\u00fcm ad\u0131 <code>Protocols for &lt;\u00f6rnek ad\u0131&gt;<\/code> \u015feklinde g\u00f6r\u00fcn\u00fcr ve ba\u011flan\u0131rken istemci taraf\u0131nda sunucu ad\u0131, ters e\u011fik \u00e7izgi ve \u00f6rnek ad\u0131n\u0131 birlikte yazman\u0131z gerekir; port ayar\u0131n\u0131n kendisi ayn\u0131 \u015fekilde yap\u0131l\u0131r.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL port de\u011fi\u015ftirme: SQL Server Configuration Manager&#8217;da IPAll b\u00f6l\u00fcm\u00fcne yeni TCP portunu yaz\u0131n, servisi yeniden ba\u015flat\u0131n, g\u00fcvenlik duvar\u0131nda a\u00e7\u0131n ve Get-NetTCPConnection ile do\u011frulay\u0131n.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,12],"tags":[],"class_list":["post-1986","post","type-post","status-publish","format-standard","hentry","category-windows-hosting","category-vds-server"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1986","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/comments?post=1986"}],"version-history":[{"count":0,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1986\/revisions"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=1986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=1986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=1986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}