{"id":3905,"date":"2024-09-25T08:41:43","date_gmt":"2024-09-25T08:41:43","guid":{"rendered":"https:\/\/www.vipservis.com\/blog\/?p=3905"},"modified":"2024-09-25T09:13:07","modified_gmt":"2024-09-25T09:13:07","slug":"microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/","title":{"rendered":"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0130\u00e7indekiler<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #ff0f0f;color:#ff0f0f\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #ff0f0f;color:#ff0f0f\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#Microsoft_SQL_Servera_MSSQLe_Uzak_Erisim_Nasil_Yapilir\" >Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r?<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#1_SQL_Serverin_Uzak_Erisime_Acilmasi\" >1. SQL Server\u2019\u0131n Uzak Eri\u015fime A\u00e7\u0131lmas\u0131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#2_TCPIP_Ayarlarini_Yapilandirma\" >2. TCP\/IP Ayarlar\u0131n\u0131 Yap\u0131land\u0131rma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#3_SQL_Server_Guvenlik_Ayarlari\" >3. SQL Server G\u00fcvenlik Ayarlar\u0131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#4_Windows_Guvenlik_Duvari_Ayarlari\" >4. Windows G\u00fcvenlik Duvar\u0131 Ayarlar\u0131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#5_Uzak_Baglanti_Icin_Istemci_Uygulamasi_Kullanma\" >5. Uzak Ba\u011flant\u0131 \u0130\u00e7in \u0130stemci Uygulamas\u0131 Kullanma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#6_Baglantiyi_Test_Etme\" >6. Ba\u011flant\u0131y\u0131 Test Etme<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Microsoft_SQL_Servera_MSSQLe_Uzak_Erisim_Nasil_Yapilir\"><\/span>Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Microsoft SQL Server, veritaban\u0131 y\u00f6netimi i\u00e7in g\u00fc\u00e7l\u00fc bir platformdur ve kullan\u0131c\u0131lar\u0131n veritabanlar\u0131na uzaktan eri\u015fim sa\u011flamalar\u0131na olanak tan\u0131r. Ancak, g\u00fcvenlik ayarlar\u0131 ve yap\u0131land\u0131rmalar do\u011fru yap\u0131lmad\u0131\u011f\u0131 takdirde, bu eri\u015fim sorunlu hale gelebilir. Bu makalede, Microsoft SQL Server&#8217;a uzaktan eri\u015fimin nas\u0131l sa\u011flanaca\u011f\u0131na dair ad\u0131mlar\u0131 detayl\u0131 bir \u015fekilde a\u00e7\u0131klayaca\u011f\u0131z.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"1_SQL_Serverin_Uzak_Erisime_Acilmasi\"><\/span>1. SQL Server\u2019\u0131n Uzak Eri\u015fime A\u00e7\u0131lmas\u0131<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>1.1. SQL Server&#8217;\u0131 A\u00e7\u0131n<\/strong><\/p>\n<p>\u00d6ncelikle, SQL Server Management Studio\u2019yu (SSMS) a\u00e7\u0131n ve veritaban\u0131 sunucunuza ba\u011flan\u0131n. Ba\u011flant\u0131y\u0131 sa\u011flad\u0131ktan sonra, sunucu \u00fczerinde baz\u0131 ayarlamalar yapman\u0131z gerekiyor.<\/p>\n<p><strong>1.2. SQL Server Ayarlar\u0131n\u0131 Kontrol Edin<\/strong><\/p>\n<p>SQL Server&#8217;\u0131n uzaktan ba\u011flant\u0131lara izin verecek \u015fekilde yap\u0131land\u0131r\u0131ld\u0131\u011f\u0131ndan emin olun. Bunun i\u00e7in:<\/p>\n<ul>\n<li>SQL Server Configuration Manager&#8217;\u0131 a\u00e7\u0131n.<\/li>\n<li>&#8220;SQL Server Network Configuration&#8221; alt\u0131ndan &#8220;Protocols for [Instance Name]&#8221; se\u00e7ene\u011fini bulun.<\/li>\n<li>&#8220;TCP\/IP&#8221; protokol\u00fcn\u00fc sa\u011f t\u0131klay\u0131p &#8220;Enable&#8221; se\u00e7ene\u011fi ile etkinle\u015ftirin.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"2_TCPIP_Ayarlarini_Yapilandirma\"><\/span>2. TCP\/IP Ayarlar\u0131n\u0131 Yap\u0131land\u0131rma<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>2.1. TCP\/IP \u00d6zelliklerini A\u00e7\u0131n<\/strong><\/p>\n<ul>\n<li>TCP\/IP&#8217;yi etkinle\u015ftirdikten sonra, TCP\/IP&#8217;ye sa\u011f t\u0131klay\u0131n ve &#8220;Properties&#8221; se\u00e7ene\u011fini se\u00e7in.<\/li>\n<li>&#8220;IP Addresses&#8221; sekmesine gidin. Burada, <code>IPAll<\/code> alt\u0131nda <code>TCP Port<\/code> de\u011ferini kontrol edin. Varsay\u0131lan olarak, SQL Server 1433 portunu kullan\u0131r. E\u011fer bu de\u011feri de\u011fi\u015ftirdiyseniz, g\u00fcncel port numaras\u0131n\u0131 not edin.<\/li>\n<\/ul>\n<p><strong>2.2. Dinleyici Portunu Ayarlay\u0131n<\/strong><\/p>\n<p>E\u011fer SQL Server\u2019\u0131n dinleyici portunu de\u011fi\u015ftirdiyseniz, uzak ba\u011flant\u0131larda bu port numaras\u0131n\u0131 kullanman\u0131z gerekecektir. De\u011fi\u015fiklikleri yapt\u0131ktan sonra, ayarlar\u0131n ge\u00e7erli olabilmesi i\u00e7in SQL Server hizmetini yeniden ba\u015flat\u0131n.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"3_SQL_Server_Guvenlik_Ayarlari\"><\/span>3. SQL Server G\u00fcvenlik Ayarlar\u0131<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>3.1. SQL Server Authentication Modunu Aktif Etme<\/strong><\/p>\n<p>Uzak ba\u011flant\u0131lar i\u00e7in SQL Server Authentication modunu aktif hale getirmelisiniz. Bunun i\u00e7in:<\/p>\n<ul>\n<li>SQL Server Management Studio&#8217;yu a\u00e7\u0131n.<\/li>\n<li>Sunucuya sa\u011f t\u0131klay\u0131n ve &#8220;Properties&#8221; se\u00e7ene\u011fine gidin.<\/li>\n<li>&#8220;Security&#8221; sekmesinde &#8220;SQL Server and Windows Authentication mode&#8221; se\u00e7ene\u011fini se\u00e7in.<\/li>\n<\/ul>\n<p><strong>3.2. Kullan\u0131c\u0131 Hesab\u0131 Olu\u015fturma<\/strong><\/p>\n<p>Uzak ba\u011flant\u0131lar i\u00e7in kullanmak istedi\u011finiz bir kullan\u0131c\u0131 hesab\u0131 olu\u015fturun. &#8220;Security&#8221; alt\u0131nda &#8220;Logins&#8221; k\u0131sm\u0131na sa\u011f t\u0131klay\u0131p &#8220;New Login&#8221; se\u00e7ene\u011fi ile yeni bir kullan\u0131c\u0131 olu\u015fturabilirsiniz. Bu kullan\u0131c\u0131ya uygun yetkileri verin.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"4_Windows_Guvenlik_Duvari_Ayarlari\"><\/span>4. Windows G\u00fcvenlik Duvar\u0131 Ayarlar\u0131<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Uzak eri\u015fimi sa\u011flamak i\u00e7in Windows G\u00fcvenlik Duvar\u0131 ayarlar\u0131nda gerekli de\u011fi\u015fiklikleri yapmal\u0131s\u0131n\u0131z:<\/p>\n<ul>\n<li>Denetim Masas\u0131\u2019ndan &#8220;Windows Defender Firewall&#8221; se\u00e7ene\u011fine gidin.<\/li>\n<li>&#8220;Advanced settings&#8221; se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li>\n<li>&#8220;Inbound Rules&#8221; k\u0131sm\u0131na sa\u011f t\u0131klay\u0131p &#8220;New Rule&#8221; se\u00e7ene\u011fi ile yeni bir kural olu\u015fturun.<\/li>\n<li>Port se\u00e7ene\u011fini se\u00e7in, &#8220;TCP&#8221; ve belirledi\u011finiz port numaras\u0131n\u0131 (varsay\u0131lan 1433) girin.<\/li>\n<li>Ba\u011flant\u0131ya izin verin ve kural\u0131 tamamlay\u0131n.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"5_Uzak_Baglanti_Icin_Istemci_Uygulamasi_Kullanma\"><\/span>5. Uzak Ba\u011flant\u0131 \u0130\u00e7in \u0130stemci Uygulamas\u0131 Kullanma<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Art\u0131k SQL Server\u2019a uzaktan ba\u011flanmak i\u00e7in bir istemci uygulamas\u0131 kullanabilirsiniz. \u00d6rne\u011fin, SQL Server Management Studio veya ba\u015fka bir veritaban\u0131 istemcisi kullanarak a\u015fa\u011f\u0131daki bilgileri girin:<\/p>\n<ul>\n<li><strong>Server Name<\/strong>: <code>[Sunucu IP Adresi],[Port Numaras\u0131]<\/code> (\u00f6rne\u011fin, <code>192.168.1.100,1433<\/code>)<\/li>\n<li><strong>Authentication<\/strong>: SQL Server Authentication se\u00e7ene\u011fini se\u00e7in.<\/li>\n<li><strong>Username<\/strong> ve <strong>Password<\/strong>: Olu\u015fturdu\u011funuz kullan\u0131c\u0131 bilgilerini girin.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"6_Baglantiyi_Test_Etme\"><\/span>6. Ba\u011flant\u0131y\u0131 Test Etme<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Giri\u015f bilgilerinizi girdikten sonra &#8220;Connect&#8221; butonuna t\u0131klayarak ba\u011flant\u0131y\u0131 test edin. Ba\u011flant\u0131n\u0131z ba\u015far\u0131l\u0131ysa, SQL Server\u2019a uzaktan eri\u015fiminiz sa\u011flanm\u0131\u015f demektir.<\/p>\n<p>Microsoft SQL Server\u2019a (MSSQL\u2019e) uzaktan eri\u015fim sa\u011flamak, do\u011fru yap\u0131land\u0131rmalar ve ayarlar ile olduk\u00e7a kolayd\u0131r. Yukar\u0131da belirtilen ad\u0131mlar\u0131 izleyerek, g\u00fcvenli bir \u015fekilde veritaban\u0131n\u0131za uzaktan eri\u015fim sa\u011flayabilirsiniz. Uzak ba\u011flant\u0131lar\u0131n\u0131z\u0131 y\u00f6netirken, her zaman g\u00fcvenlik \u00f6nlemlerini g\u00f6z \u00f6n\u00fcnde bulundurmal\u0131s\u0131n\u0131z.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r? Microsoft SQL Server, veritaban\u0131 y\u00f6netimi i\u00e7in g\u00fc\u00e7l\u00fc bir platformdur ve kullan\u0131c\u0131lar\u0131n veritabanlar\u0131na uzaktan eri\u015fim sa\u011flamalar\u0131na olanak tan\u0131r. Ancak, g\u00fcvenlik ayarlar\u0131 ve yap\u0131land\u0131rmalar do\u011fru yap\u0131lmad\u0131\u011f\u0131 takdirde, bu eri\u015fim sorunlu hale gelebilir. Bu makalede, Microsoft SQL Server&#8217;a uzaktan eri\u015fimin nas\u0131l sa\u011flanaca\u011f\u0131na dair ad\u0131mlar\u0131 detayl\u0131 bir \u015fekilde a\u00e7\u0131klayaca\u011f\u0131z. 1. SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2141,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[123],"tags":[16224,16241,16239,16005,16235,16228,16003,16229,15994,16238,16231,15990,16230,16236,16223,16227,16225,15988,16233,15997,16001,15998,15989,16006,15996,16000,15991,15993,16004,16234,15995,16232,16237,16002,16226,15992,16240,15999,16007],"class_list":["post-3905","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web-hosting","tag-microsoft-sql-server-uzak-erisim","tag-mssql-baglanti-ayarlari","tag-mssql-baglanti-hatasi-cozumu","tag-mssql-baglanti-testi","tag-mssql-erisim-yapilandirma","tag-mssql-firewall-ayarlari","tag-mssql-icin-port-acma","tag-mssql-port-acma","tag-mssql-port-ayarlari","tag-mssql-server-erisimi","tag-mssql-sunucu-baglantisi","tag-mssql-tcp-ip-ayarlari","tag-mssql-tcp-ip-etkinlestirme","tag-mssql-uzak-baglanti","tag-mssql-uzak-erisim","tag-mssql-uzak-erisim-ayarlari","tag-mssql-uzaktan-baglanma","tag-mssql-uzaktan-erisim","tag-mssql-uzaktan-erisim-sorunu","tag-mssql-veritabani-erisimi","tag-mssql-yapilandirma-rehberi","tag-sql-server-baglanti-hatasi","tag-sql-server-baglantisi","tag-sql-server-dinleyici-ayarlari","tag-sql-server-firewall-ayarlari","tag-sql-server-guvenligi","tag-sql-server-guvenlik-ayarlari","tag-sql-server-kullanici-hesabi-olusturma","tag-sql-server-kullanici-yetkileri","tag-sql-server-management-studio-baglanti","tag-sql-server-management-studio-uzaktan-baglanti","tag-sql-server-port-ayarlari","tag-sql-server-port-yonlendirme","tag-sql-server-uzak-erisim-ayarlari","tag-sql-server-uzaktan-baglanti","tag-sql-server-uzaktan-baglanti-nasil-yapilir","tag-sql-server-uzaktan-yonetim","tag-uzaktan-mssql-baglantisi","tag-uzaktan-mssql-yonetimi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r? - Vipservis Blog<\/title>\n<meta name=\"description\" content=\"Microsoft SQL Server\u2019a (MSSQL) uzak eri\u015fim nas\u0131l yap\u0131l\u0131r? Ad\u0131m ad\u0131m rehber ile MSSQL sunucunuza uzaktan sorunsuz bir \u015fekilde ba\u011flan\u0131n.\" \/>\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.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r? - Vipservis Blog\" \/>\n<meta property=\"og:description\" content=\"Microsoft SQL Server\u2019a (MSSQL) uzak eri\u015fim nas\u0131l yap\u0131l\u0131r? Ad\u0131m ad\u0131m rehber ile MSSQL sunucunuza uzaktan sorunsuz bir \u015fekilde ba\u011flan\u0131n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/\" \/>\n<meta property=\"og:site_name\" content=\"Vipservis Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vipserviscom\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-25T08:41:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-25T09:13:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vipservis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@vipserviscom\" \/>\n<meta name=\"twitter:site\" content=\"@vipserviscom\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vipservis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/\"},\"author\":{\"name\":\"Vipservis\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/#\/schema\/person\/cdb61a7e4f2eef5e8f9550829d769ed2\"},\"headline\":\"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r?\",\"datePublished\":\"2024-09-25T08:41:43+00:00\",\"dateModified\":\"2024-09-25T09:13:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/\"},\"wordCount\":667,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg\",\"keywords\":[\"Microsoft SQL Server uzak eri\u015fim\",\"MSSQL ba\u011flant\u0131 ayarlar\u0131.\",\"MSSQL ba\u011flant\u0131 hatas\u0131 \u00e7\u00f6z\u00fcm\u00fc\",\"MSSQL ba\u011flant\u0131 testi\",\"MSSQL eri\u015fim yap\u0131land\u0131rma\",\"MSSQL firewall ayarlar\u0131\",\"MSSQL i\u00e7in port a\u00e7ma\",\"MSSQL port a\u00e7ma\",\"MSSQL port ayarlar\u0131\",\"MSSQL server eri\u015fimi\",\"MSSQL sunucu ba\u011flant\u0131s\u0131\",\"MSSQL TCP\/IP ayarlar\u0131\",\"MSSQL TCP\/IP etkinle\u015ftirme\",\"MSSQL uzak ba\u011flant\u0131\",\"MSSQL uzak eri\u015fim\",\"MSSQL uzak eri\u015fim ayarlar\u0131\",\"MSSQL uzaktan ba\u011flanma\",\"MSSQL uzaktan eri\u015fim\",\"MSSQL uzaktan eri\u015fim sorunu\",\"MSSQL veritaban\u0131 eri\u015fimi\",\"MSSQL yap\u0131land\u0131rma rehberi\",\"SQL Server ba\u011flant\u0131 hatas\u0131\",\"SQL Server ba\u011flant\u0131s\u0131\",\"SQL Server dinleyici ayarlar\u0131\",\"SQL Server Firewall ayarlar\u0131\",\"SQL Server g\u00fcvenli\u011fi\",\"SQL Server g\u00fcvenlik ayarlar\u0131\",\"SQL Server kullan\u0131c\u0131 hesab\u0131 olu\u015fturma\",\"SQL Server kullan\u0131c\u0131 yetkileri\",\"SQL Server Management Studio ba\u011flant\u0131\",\"SQL Server Management Studio uzaktan ba\u011flant\u0131\",\"SQL Server port ayarlar\u0131\",\"SQL Server port y\u00f6nlendirme\",\"SQL Server uzak eri\u015fim ayarlar\u0131\",\"SQL Server uzaktan ba\u011flant\u0131\",\"SQL Server uzaktan ba\u011flant\u0131 nas\u0131l yap\u0131l\u0131r\",\"SQL Server uzaktan y\u00f6netim\",\"uzaktan MSSQL ba\u011flant\u0131s\u0131\",\"uzaktan MSSQL y\u00f6netimi.\"],\"articleSection\":[\"Web Hosting\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/\",\"url\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/\",\"name\":\"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r? - Vipservis Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg\",\"datePublished\":\"2024-09-25T08:41:43+00:00\",\"dateModified\":\"2024-09-25T09:13:07+00:00\",\"description\":\"Microsoft SQL Server\u2019a (MSSQL) uzak eri\u015fim nas\u0131l yap\u0131l\u0131r? Ad\u0131m ad\u0131m rehber ile MSSQL sunucunuza uzaktan sorunsuz bir \u015fekilde ba\u011flan\u0131n.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#primaryimage\",\"url\":\"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg\",\"contentUrl\":\"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg\",\"width\":2560,\"height\":1707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/www.vipservis.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/#website\",\"url\":\"https:\/\/www.vipservis.com\/blog\/\",\"name\":\"Vipservis Blog\",\"description\":\"Vipservis Olarak 26 Y\u0131ll\u0131k Tecr\u00fcbemiz ile Cevap Arad\u0131\u011f\u0131n\u0131z T\u00fcm Sorular\u0131 Yaz\u0131yoruz.\",\"publisher\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vipservis.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/#organization\",\"name\":\"Vipservis Bili\u015fim ve \u0130nternet Teknolojileri\",\"url\":\"https:\/\/www.vipservis.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/logo-1.png\",\"contentUrl\":\"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/logo-1.png\",\"width\":500,\"height\":104,\"caption\":\"Vipservis Bili\u015fim ve \u0130nternet Teknolojileri\"},\"image\":{\"@id\":\"https:\/\/www.vipservis.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vipserviscom\",\"https:\/\/x.com\/vipserviscom\",\"https:\/\/www.instagram.com\/vipserviscom\",\"https:\/\/www.linkedin.com\/company\/vipservis?originalSubdomain=tr\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/#\/schema\/person\/cdb61a7e4f2eef5e8f9550829d769ed2\",\"name\":\"Vipservis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.vipservis.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.vipservis.com\/blog\/wp-content\/litespeed\/avatar\/6600f3cb02baa85efeb72add678e6f83.jpg?ver=1780662610\",\"contentUrl\":\"https:\/\/www.vipservis.com\/blog\/wp-content\/litespeed\/avatar\/6600f3cb02baa85efeb72add678e6f83.jpg?ver=1780662610\",\"caption\":\"Vipservis\"},\"sameAs\":[\"https:\/\/vipservis.com\/blog\"],\"url\":\"https:\/\/www.vipservis.com\/blog\/author\/crawk\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r? - Vipservis Blog","description":"Microsoft SQL Server\u2019a (MSSQL) uzak eri\u015fim nas\u0131l yap\u0131l\u0131r? Ad\u0131m ad\u0131m rehber ile MSSQL sunucunuza uzaktan sorunsuz bir \u015fekilde ba\u011flan\u0131n.","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.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/","og_locale":"tr_TR","og_type":"article","og_title":"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r? - Vipservis Blog","og_description":"Microsoft SQL Server\u2019a (MSSQL) uzak eri\u015fim nas\u0131l yap\u0131l\u0131r? Ad\u0131m ad\u0131m rehber ile MSSQL sunucunuza uzaktan sorunsuz bir \u015fekilde ba\u011flan\u0131n.","og_url":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/","og_site_name":"Vipservis Blog","article_publisher":"https:\/\/www.facebook.com\/vipserviscom","article_published_time":"2024-09-25T08:41:43+00:00","article_modified_time":"2024-09-25T09:13:07+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg","type":"image\/jpeg"}],"author":"Vipservis","twitter_card":"summary_large_image","twitter_creator":"@vipserviscom","twitter_site":"@vipserviscom","twitter_misc":{"Yazan:":"Vipservis","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#article","isPartOf":{"@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/"},"author":{"name":"Vipservis","@id":"https:\/\/www.vipservis.com\/blog\/#\/schema\/person\/cdb61a7e4f2eef5e8f9550829d769ed2"},"headline":"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r?","datePublished":"2024-09-25T08:41:43+00:00","dateModified":"2024-09-25T09:13:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/"},"wordCount":667,"commentCount":0,"publisher":{"@id":"https:\/\/www.vipservis.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg","keywords":["Microsoft SQL Server uzak eri\u015fim","MSSQL ba\u011flant\u0131 ayarlar\u0131.","MSSQL ba\u011flant\u0131 hatas\u0131 \u00e7\u00f6z\u00fcm\u00fc","MSSQL ba\u011flant\u0131 testi","MSSQL eri\u015fim yap\u0131land\u0131rma","MSSQL firewall ayarlar\u0131","MSSQL i\u00e7in port a\u00e7ma","MSSQL port a\u00e7ma","MSSQL port ayarlar\u0131","MSSQL server eri\u015fimi","MSSQL sunucu ba\u011flant\u0131s\u0131","MSSQL TCP\/IP ayarlar\u0131","MSSQL TCP\/IP etkinle\u015ftirme","MSSQL uzak ba\u011flant\u0131","MSSQL uzak eri\u015fim","MSSQL uzak eri\u015fim ayarlar\u0131","MSSQL uzaktan ba\u011flanma","MSSQL uzaktan eri\u015fim","MSSQL uzaktan eri\u015fim sorunu","MSSQL veritaban\u0131 eri\u015fimi","MSSQL yap\u0131land\u0131rma rehberi","SQL Server ba\u011flant\u0131 hatas\u0131","SQL Server ba\u011flant\u0131s\u0131","SQL Server dinleyici ayarlar\u0131","SQL Server Firewall ayarlar\u0131","SQL Server g\u00fcvenli\u011fi","SQL Server g\u00fcvenlik ayarlar\u0131","SQL Server kullan\u0131c\u0131 hesab\u0131 olu\u015fturma","SQL Server kullan\u0131c\u0131 yetkileri","SQL Server Management Studio ba\u011flant\u0131","SQL Server Management Studio uzaktan ba\u011flant\u0131","SQL Server port ayarlar\u0131","SQL Server port y\u00f6nlendirme","SQL Server uzak eri\u015fim ayarlar\u0131","SQL Server uzaktan ba\u011flant\u0131","SQL Server uzaktan ba\u011flant\u0131 nas\u0131l yap\u0131l\u0131r","SQL Server uzaktan y\u00f6netim","uzaktan MSSQL ba\u011flant\u0131s\u0131","uzaktan MSSQL y\u00f6netimi."],"articleSection":["Web Hosting"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/","url":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/","name":"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r? - Vipservis Blog","isPartOf":{"@id":"https:\/\/www.vipservis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#primaryimage"},"image":{"@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg","datePublished":"2024-09-25T08:41:43+00:00","dateModified":"2024-09-25T09:13:07+00:00","description":"Microsoft SQL Server\u2019a (MSSQL) uzak eri\u015fim nas\u0131l yap\u0131l\u0131r? Ad\u0131m ad\u0131m rehber ile MSSQL sunucunuza uzaktan sorunsuz bir \u015fekilde ba\u011flan\u0131n.","breadcrumb":{"@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#primaryimage","url":"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg","contentUrl":"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/data-center-room-with-computers-servers-storage-systems-generative-ai-scaled.jpg","width":2560,"height":1707},{"@type":"BreadcrumbList","@id":"https:\/\/www.vipservis.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/www.vipservis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft SQL Server\u2019a (MSSQL\u2019e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/www.vipservis.com\/blog\/#website","url":"https:\/\/www.vipservis.com\/blog\/","name":"Vipservis Blog","description":"Vipservis Olarak 26 Y\u0131ll\u0131k Tecr\u00fcbemiz ile Cevap Arad\u0131\u011f\u0131n\u0131z T\u00fcm Sorular\u0131 Yaz\u0131yoruz.","publisher":{"@id":"https:\/\/www.vipservis.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vipservis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/www.vipservis.com\/blog\/#organization","name":"Vipservis Bili\u015fim ve \u0130nternet Teknolojileri","url":"https:\/\/www.vipservis.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.vipservis.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/logo-1.png","contentUrl":"https:\/\/www.vipservis.com\/blog\/wp-content\/uploads\/2024\/09\/logo-1.png","width":500,"height":104,"caption":"Vipservis Bili\u015fim ve \u0130nternet Teknolojileri"},"image":{"@id":"https:\/\/www.vipservis.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vipserviscom","https:\/\/x.com\/vipserviscom","https:\/\/www.instagram.com\/vipserviscom","https:\/\/www.linkedin.com\/company\/vipservis?originalSubdomain=tr"]},{"@type":"Person","@id":"https:\/\/www.vipservis.com\/blog\/#\/schema\/person\/cdb61a7e4f2eef5e8f9550829d769ed2","name":"Vipservis","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.vipservis.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.vipservis.com\/blog\/wp-content\/litespeed\/avatar\/6600f3cb02baa85efeb72add678e6f83.jpg?ver=1780662610","contentUrl":"https:\/\/www.vipservis.com\/blog\/wp-content\/litespeed\/avatar\/6600f3cb02baa85efeb72add678e6f83.jpg?ver=1780662610","caption":"Vipservis"},"sameAs":["https:\/\/vipservis.com\/blog"],"url":"https:\/\/www.vipservis.com\/blog\/author\/crawk\/"}]}},"_links":{"self":[{"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/posts\/3905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/comments?post=3905"}],"version-history":[{"count":1,"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/posts\/3905\/revisions"}],"predecessor-version":[{"id":3907,"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/posts\/3905\/revisions\/3907"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/media\/2141"}],"wp:attachment":[{"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/media?parent=3905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/categories?post=3905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vipservis.com\/blog\/wp-json\/wp\/v2\/tags?post=3905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}