{"id":3068,"date":"2026-11-11T10:00:00","date_gmt":"2026-11-11T07:00:00","guid":{"rendered":"https:\/\/narhost.com\/destek\/?p=3068"},"modified":"2026-11-12T13:55:05","modified_gmt":"2026-11-12T10:55:05","slug":"plesk-mssql-uzaktan-baglanti-ssms","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/plesk-mssql-uzaktan-baglanti-ssms\/","title":{"rendered":"Plesk&#8217;te MSSQL Veritaban\u0131na SSMS ile Uzaktan Ba\u011flanma"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son g\u00f6zden ge\u00e7irme: Kas\u0131m 2026 \u00b7 Narhost Windows hosting \u00fcr\u00fcn sayfas\u0131 (MSSQL uzaktan eri\u015fim) ve Microsoft SSMS belgesine 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>Plesk MSSQL uzaktan ba\u011flant\u0131 SSMS<\/strong> ile kurulurken Windows kimli\u011fi de\u011fil, Plesk&#8217;te olu\u015fturdu\u011funuz veritaban\u0131 kullan\u0131c\u0131s\u0131 kullan\u0131l\u0131r. Bilgileri Plesk&#8217;ten al\u0131p SSMS&#8217;e girin:<\/p>\n<ol>\n<li>Plesk&#8217;te <strong>Websites &amp; Domains \u2192 Databases<\/strong> ekran\u0131nda veritaban\u0131n\u0131z\u0131n ba\u011flant\u0131 bilgisini a\u00e7\u0131p sunucu adresini not edin.<\/li>\n<li>SSMS&#8217;te <strong>Connect to Server<\/strong> penceresinde Server name alan\u0131na bu adresi yaz\u0131n; port belirtilmi\u015fse <code>sunucu,port<\/code> bi\u00e7iminde.<\/li>\n<li>Authentication i\u00e7in <strong>SQL Server Authentication<\/strong> se\u00e7ip veritaban\u0131 kullan\u0131c\u0131 ad\u0131 ve \u015fifresini girin.<\/li>\n<li>Ba\u011flan\u0131n ve Object Explorer&#8217;da yaln\u0131z kendi veritaban\u0131n\u0131z\u0131 a\u00e7\u0131n.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>Plesk Obsidian; istemci SQL Server Management Studio (SSMS)<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Windows hosting, MSSQL Server 2022<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>Plesk m\u00fc\u015fteri hesab\u0131, veritaban\u0131 kullan\u0131c\u0131s\u0131<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/windows-hosting\" title=\"Narhost Windows Hosting paketleri\">Windows Hosting<\/a><\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>Bilgisayar\u0131n\u0131za SSMS&#8217;in g\u00fcncel s\u00fcr\u00fcm\u00fcn\u00fc kurun.<\/li>\n<li>Plesk&#8217;te bir MSSQL veritaban\u0131 ve ona ba\u011fl\u0131 bir veritaban\u0131 kullan\u0131c\u0131s\u0131 olu\u015fturulmu\u015f olsun.<\/li>\n<li>Kullan\u0131c\u0131n\u0131n \u015fifresini bilmiyorsan\u0131z Plesk&#8217;teki kullan\u0131c\u0131 d\u00fczenleme ekran\u0131ndan yenileyin.<\/li>\n<li>\u0130\u015f yerinizin g\u00fcvenlik duvar\u0131 d\u0131\u015far\u0131ya SQL Server ba\u011flant\u0131s\u0131na izin vermiyorsa ba\u011flant\u0131 kurulamaz; ev ya da mobil hatla deneyerek ay\u0131rt edin.<\/li>\n<\/ul>\n<\/div>\n<h2>Plesk MSSQL uzaktan ba\u011flant\u0131 SSMS i\u00e7in ne gerekir<\/h2>\n<p>Narhost&#8217;un Windows hosting paketlerinde MSSQL Server 2022 sunulur ve \u00fcr\u00fcn sayfas\u0131ndaki kar\u015f\u0131la\u015ft\u0131rma tablosunda MSSQL uzaktan eri\u015fim b\u00fct\u00fcn paketlerde i\u015faretlidir. Uzaktan eri\u015fim, veritaban\u0131n\u0131 kendi bilgisayar\u0131n\u0131zdaki SSMS ile y\u00f6netebilmeniz, tablo olu\u015fturup sorgu \u00e7al\u0131\u015ft\u0131rabilmeniz demektir. Payla\u015f\u0131ml\u0131 hostingde sunucuya RDP ile ba\u011flanamazs\u0131n\u0131z; veritaban\u0131na ula\u015fman\u0131n yolu bu ba\u011flant\u0131d\u0131r.<\/p>\n<p>Ba\u011flant\u0131 i\u00e7in d\u00f6rt bilgi gerekir: sunucu adresi, veritaban\u0131 ad\u0131, veritaban\u0131 kullan\u0131c\u0131 ad\u0131 ve \u015fifresi. Bunlar\u0131n Plesk&#8217;te nerede g\u00f6r\u00fcnd\u00fc\u011f\u00fc <a href=\"https:\/\/narhost.com\/destek\/mssql-veritabani-erisim-bilgilerimi-nasil-ogrenebilirim\/\" title=\"MSSQL Eri\u015fim Bilgileri Nas\u0131l \u00d6\u011frenilir \u2014 Narhost Destek Merkezi\">MSSQL eri\u015fim bilgileri nas\u0131l \u00f6\u011frenilir<\/a> kart\u0131nda ekran yoluyla anlat\u0131l\u0131yor.<\/p>\n<figure class=\"nh-sema\"><img src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/11\/plesk-mssql-uzaktan-baglanti-ssms-sema-narhost.webp\" alt=\"plesk mssql uzaktan ba\u011flant\u0131 ssms \u015femas\u0131 \u2014 ba\u011flant\u0131 bilgisi, sunucu ad\u0131, SQL Server Authentication ve do\u011frulama\" width=\"1200\" height=\"500\" loading=\"lazy\" decoding=\"async\"><figcaption>Windows kimli\u011fi de\u011fil, Plesk&#x27;teki veritaban\u0131 kullan\u0131c\u0131s\u0131 kullan\u0131l\u0131r.<\/figcaption><\/figure>\n<h2>Ad\u0131m ad\u0131m SSMS ile ba\u011flanma<\/h2>\n<ol class=\"kb-adimlar\">\n<li><strong>Plesk \u2192 Websites &amp; Domains \u2192 Databases<\/strong> ekran\u0131n\u0131 a\u00e7\u0131n. MSSQL veritaban\u0131n\u0131z\u0131n sat\u0131r\u0131ndaki ba\u011flant\u0131 bilgisi b\u00f6l\u00fcm\u00fcnde sunucu adresi ve veritaban\u0131 ad\u0131 yazar.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: sunucu adresi bir ana makine ad\u0131 ya da IP adresi olarak g\u00f6r\u00fcn\u00fcr; baz\u0131 yap\u0131larda yan\u0131na port numaras\u0131 eklenmi\u015ftir.<\/p>\n<\/li>\n<li><strong>SSMS&#8217;i a\u00e7\u0131n.<\/strong> Connect to Server penceresi kendili\u011finden a\u00e7\u0131lmazsa <strong>Object Explorer \u2192 Connect \u2192 Database Engine<\/strong> yolunu kullan\u0131n.<\/li>\n<li><strong>Sunucu ad\u0131n\u0131 girin.<\/strong> Server name alan\u0131na Plesk&#8217;teki adresi yaz\u0131n. Plesk bir port g\u00f6steriyorsa adres ile port aras\u0131na virg\u00fcl koyun:\n<pre><code class=\"language-plaintext\">sunucu-adi.ornek.com,1433<\/code><\/pre>\n<p class=\"kb-cikti\">\u00d6rnekteki port yaln\u0131z bi\u00e7imi g\u00f6sterir; kendi hesab\u0131n\u0131zda Plesk&#8217;in yazd\u0131\u011f\u0131 de\u011feri kullan\u0131n.<\/p>\n<\/li>\n<li><strong>Kimlik do\u011frulamay\u0131 se\u00e7in.<\/strong> Authentication alan\u0131nda <strong>SQL Server Authentication<\/strong> se\u00e7in; Login&#8217;e veritaban\u0131 kullan\u0131c\u0131 ad\u0131n\u0131, Password&#8217;e \u015fifresini yaz\u0131n. Windows Authentication bu senaryoda \u00e7al\u0131\u015fmaz.<\/li>\n<li><strong>\u015eifreleme ayar\u0131na bak\u0131n.<\/strong> SSMS&#8217;in g\u00fcncel s\u00fcr\u00fcmlerinde Encryption varsay\u0131lan olarak <strong>Mandatory<\/strong> gelir. Sertifika uyar\u0131s\u0131 al\u0131rsan\u0131z bu, sunucu sertifikas\u0131n\u0131n bilgisayar\u0131n\u0131zca do\u011frulanamad\u0131\u011f\u0131n\u0131 g\u00f6sterir; <strong>Trust server certificate<\/strong> kutusunu yaln\u0131z ba\u011fland\u0131\u011f\u0131n\u0131z adresin do\u011fru oldu\u011fundan eminseniz i\u015faretleyin.<\/li>\n<li><strong>Ba\u011flan\u0131n.<\/strong> Connect d\u00fc\u011fmesine bas\u0131n.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: Object Explorer&#8217;da sunucu ad\u0131 ve SQL Server s\u00fcr\u00fcm\u00fc g\u00f6r\u00fcn\u00fcr; Databases alt\u0131nda kendi veritaban\u0131n\u0131z\u0131 a\u00e7abilirsiniz.<\/p>\n<\/li>\n<\/ol>\n<div class=\"warn-box\">\n<p class=\"label\">Dikkat<\/p>\n<p>Payla\u015f\u0131ml\u0131 sunucuda Databases listesinde ba\u015fka veritabanlar\u0131n\u0131n adlar\u0131n\u0131 g\u00f6rebilirsiniz ama eri\u015fim yetkiniz yaln\u0131z kendi veritaban\u0131n\u0131za aittir. Uygulaman\u0131z\u0131n ba\u011flant\u0131 dizesinde de ayn\u0131 kullan\u0131c\u0131y\u0131 kullan\u0131n; veritaban\u0131 \u015fifresini kaynak koduna a\u00e7\u0131k metin olarak de\u011fil, yap\u0131land\u0131rma dosyas\u0131nda tutun ve dosyay\u0131 s\u00fcr\u00fcm kontrol\u00fcne eklemeyin.<\/p>\n<\/div>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Object Explorer&#8217;da veritaban\u0131n\u0131z\u0131n tablolar\u0131n\u0131 g\u00f6rebiliyor ve <code>SELECT @@VERSION;<\/code> sorgusu SQL Server 2022 s\u00fcr\u00fcm bilgisini d\u00f6nd\u00fcr\u00fcyorsa Plesk MSSQL uzaktan ba\u011flant\u0131 SSMS \u00fczerinden \u00e7al\u0131\u015f\u0131yordur.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00e7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>&#8220;A network-related or instance-specific error&#8221; hatas\u0131.<\/strong> Sunucu adresi ya da port yanl\u0131\u015ft\u0131r veya a\u011f\u0131n\u0131z ba\u011flant\u0131y\u0131 engelliyordur. Microsoft&#8217;un <a href=\"https:\/\/learn.microsoft.com\/en-us\/troubleshoot\/sql\/connect\/network-related-or-instance-specific-error-occurred-while-establishing-connection\" title=\"Microsoft Learn \u2014 SQL Server ba\u011flant\u0131 hatas\u0131 sorun giderme\" target=\"_blank\" rel=\"noopener\">ba\u011flant\u0131 hatas\u0131 sorun giderme belgesindeki<\/a> kontrolleri uygulay\u0131n; farkl\u0131 bir internet ba\u011flant\u0131s\u0131yla deneyin.<\/li>\n<li><strong>&#8220;Login failed for user&#8221; hatas\u0131.<\/strong> Kullan\u0131c\u0131 ad\u0131 ya da \u015fifre yanl\u0131\u015ft\u0131r; \u015fifreyi Plesk&#8217;ten yenileyip tekrar deneyin. Kullan\u0131c\u0131 yetkileri <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 Merkezi\">MSSQL veritaban\u0131 olu\u015fturma ve kullan\u0131c\u0131 yetkilendirme<\/a> kart\u0131nda.<\/li>\n<li><strong>Ba\u011flant\u0131 kuruluyor ama veritaban\u0131 g\u00f6r\u00fcnm\u00fcyor.<\/strong> Kullan\u0131c\u0131 ba\u015fka bir veritaban\u0131na ba\u011fl\u0131d\u0131r; Plesk&#8217;te kullan\u0131c\u0131n\u0131n hangi veritaban\u0131na atand\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: Plesk&#8217;teki veritaban\u0131 ad\u0131, SSMS&#8217;e yazd\u0131\u011f\u0131n\u0131z sunucu adresi, hata metninin tamam\u0131 ve ba\u011flant\u0131y\u0131 denedi\u011finiz saat. Veritaban\u0131 \u015fifresini talebe yazmay\u0131n.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\">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 (RDP) Y\u00f6netimi Rehberi - Narhost Destek\">Windows Sunucu (RDP) Y\u00f6netimi Rehberi (konu merkezi)<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/pleskte-veritabani-olusturma\/\" title=\"Plesk&#039;te MySQL \/ MSSQL Veritaban\u0131 Olu\u015fturma \u2014 Narhost Destek Merkezi\">Plesk&#8217;te MySQL ya da MSSQL veritaban\u0131 olu\u015fturma<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-hosting-mssql-var-mi-boyutu-nedir\/\" title=\"Windows Hosting Paketinde MSSQL Boyutu \u2014 Narhost Destek Merkezi\">Windows hosting paketinde MSSQL boyutu<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/blog\/mysql-mi-mssql-mi\/\" title=\"MySQL mi MSSQL mi \u2014 Narhost Blog\">MySQL mi MSSQL mi, web uygulamas\u0131 i\u00e7in hangi veritaban\u0131<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a sorulan sorular<\/h2>\n<h3>MSSQL veritaban\u0131na SSMS d\u0131\u015f\u0131nda hangi ara\u00e7larla ba\u011flan\u0131l\u0131r?<\/h3>\n<p>SQL Server kimlik do\u011frulamas\u0131n\u0131 destekleyen her istemciyle ba\u011flanabilirsiniz; Azure Data Studio&#8217;nun yerini alan Visual Studio Code eklentisi ve uygulaman\u0131z\u0131n kendi ba\u011flant\u0131 dizesi bunlara \u00f6rnektir. Sunucu adresi, kullan\u0131c\u0131 ad\u0131 ve \u015fifre her ara\u00e7ta ayn\u0131d\u0131r.<\/p>\n<h3>Windows Authentication ile neden ba\u011flanam\u0131yorum?<\/h3>\n<p>Payla\u015f\u0131ml\u0131 Windows hostingde bilgisayar\u0131n\u0131z\u0131n Windows hesab\u0131 sunucuda tan\u0131ml\u0131 de\u011fildir. Ba\u011flant\u0131 yaln\u0131z Plesk&#8217;te olu\u015fturulan veritaban\u0131 kullan\u0131c\u0131s\u0131yla, SQL Server Authentication se\u00e7ilerek yap\u0131l\u0131r.<\/p>\n<h3>Veritaban\u0131 yede\u011fini SSMS ile alabilir miyim?<\/h3>\n<p>Payla\u015f\u0131ml\u0131 sunucuda sunucu diskine yedek yazma yetkiniz olmayabilir. Plesk&#8217;in yedekleme ara\u00e7lar\u0131n\u0131 kullan\u0131n ya da tablolar\u0131 SSMS&#8217;in betik olu\u015fturma \u00f6zelli\u011fiyle d\u0131\u015fa aktar\u0131n; b\u00fcy\u00fck geri y\u00fcklemeler i\u00e7in destek talebi a\u00e7\u0131n.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Windows hostingde Plesk&#8217;te olu\u015fturdu\u011funuz MSSQL veritaban\u0131na kendi bilgisayar\u0131n\u0131zdaki SSMS ile ba\u011flanma: sunucu adresi ve port bi\u00e7imi, SQL Server Authentication, Encryption ve Trust server certificate, s\u0131k hatalar.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,12],"tags":[222,225,226],"class_list":["post-3068","post","type-post","status-publish","format-standard","hentry","category-windows-hosting","category-vds-server","tag-mssql","tag-ssms","tag-windows-hosting"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/3068","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=3068"}],"version-history":[{"count":1,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/3068\/revisions"}],"predecessor-version":[{"id":3127,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/3068\/revisions\/3127"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=3068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=3068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=3068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}