{"id":4408,"date":"2023-01-24T22:21:28","date_gmt":"2023-01-24T19:21:28","guid":{"rendered":"https:\/\/www.domainhizmetleri.com\/blog\/?p=4408"},"modified":"2023-01-26T18:11:51","modified_gmt":"2023-01-26T15:11:51","slug":"microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/www.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/","title":{"rendered":"Microsoft SQL Server&#8217;a (MSSQL&#8217;e) Uzak Eri\u015fim Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Yaz\u0131 \u0130\u00e7eri\u011fi<\/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=\"\u0130\u00e7indekiler Tablosunu A\u00e7\/Kapat\"><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: #0a0a0a;color:#0a0a0a\" 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: #0a0a0a;color:#0a0a0a\" 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.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#Microsoft_SQL_Servara_MSSQLe_Uzak_Erisim_Yapma_Adimlari\" >Microsoft SQL Servar&#8217;a (MSSQL&#8217;e) Uzak Eri\u015fim Yapma Ad\u0131mlar\u0131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#1_SQL_Server_Configuration_Manager_Penceresini_Acin\" >1) SQL Server Configuration Manager Penceresini A\u00e7\u0131n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#2_TCPIP_Protokolunun_Etkin_Oldugundan_Emin_Olun\" >2) TCP\/IP Protokol\u00fcn\u00fcn Etkin Oldu\u011fundan Emin Olun<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#3_TCP_Port_degerini_1433_Olarak_Guncelleyin\" >3) TCP Port de\u011ferini 1433 Olarak G\u00fcncelleyin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#4_SQL_Server_MSSQLSERVER_Servisini_Yeniden_Baslatin\" >4) SQL Server (MSSQLSERVER) Servisini Yeniden Ba\u015flat\u0131n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#5_Firewall_Guvenlik_Duvari_Uzerinden_1433TCP_Portunu_Aktif_Edin\" >5) Firewall (G\u00fcvenlik Duvar\u0131) \u00dczerinden 1433\/TCP Portunu Aktif Edin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#6_Portu_Genel_Erisime_Acildigini_Test_Edelim\" >6) Portu Genel Eri\u015fime A\u00e7\u0131ld\u0131\u011f\u0131n\u0131 Test Edelim<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/microsoft-sql-servera-mssqle-uzak-erisim-nasil-yapilir\/#7_SQL_Server_Management_Studio_SSMS_Programiyla_Baglanti\" >7) SQL Server Management Studio (SSMS) Program\u0131yla Ba\u011flant\u0131<\/a><\/li><\/ul><\/nav><\/div>\n<div class=\"wpb-content-wrapper\">\r\n<p>Merhaba, bug\u00fcn sizlere bir Microsoft SQL sunucusuna nas\u0131l uzaktan ba\u011flanabilece\u011finizi payla\u015faca\u011f\u0131z.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Microsoft_SQL_Servara_MSSQLe_Uzak_Erisim_Yapma_Adimlari\"><\/span>Microsoft SQL Servar&#8217;a (MSSQL&#8217;e) Uzak Eri\u015fim Yapma Ad\u0131mlar\u0131<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p>SQL sunucusuna uzaktan ba\u011flanmak i\u00e7in \u00f6ncelikle sunucunun IP adresi veya domain URL&#8217;si gerekmektedir. Bu bilgileri edindikten sonra, SQL Server Management Studio (SSMS) adl\u0131 program\u0131 kullanabilirsiniz.<\/p>\r\n\r\n\r\n\r\n<p>E\u011fer bilgisayar\u0131n\u0131zda kurulu de\u011filse SQL Server Management Studio (SSMS) program\u0131n\u0131 buradan indirebilirsiniz: \u00a0<br \/><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-ver16&amp;tabs=command-line\" target=\"_blank\" rel=\"noreferrer noopener nofollow\" data-type=\"URL\" data-id=\"https:\/\/learn.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms-19?view=sql-server-ver16\">SQL Server Management Studio (SSMS) \u0130ndir<\/a><\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_SQL_Server_Configuration_Manager_Penceresini_Acin\"><\/span><strong>1) SQL Server Configuration Manager<\/strong> Penceresini A\u00e7\u0131n<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p>SQL Server kurulu uzak Windows sunucuda, <strong>SQL Server Configuration Manager<\/strong> program\u0131n\u0131 a\u00e7al\u0131m. <br \/><em>Programa h\u0131zl\u0131 \u015fekilde ula\u015fabilmek i\u00e7in Windows arama \u00e7ubu\u011funa &#8220;Configuration Manager&#8221; yazabilirsiniz. Sunucuda kurulu olan s\u00fcr\u00fcme g\u00f6re ismi belirecektir. \u00d6rne\u011fin SQL Server 2019 i\u00e7in &#8220;SQL Server 2019 Configuration Manager&#8221; \u015feklinde kar\u015f\u0131n\u0131za \u00e7\u0131kacakt\u0131r.<\/em><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4456\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Configuration-Manager-Search-1024x720.png\" alt=\"\" width=\"883\" height=\"621\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Configuration-Manager-Search-1024x720.png 1024w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Configuration-Manager-Search-300x211.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Configuration-Manager-Search-990x696.png 990w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Configuration-Manager-Search.png 1209w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_TCPIP_Protokolunun_Etkin_Oldugundan_Emin_Olun\"><\/span>2) <strong>TCP\/IP<\/strong> Protokol\u00fcn\u00fcn Etkin Oldu\u011fundan Emin Olun<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p>Configuration Manager i\u00e7inde, <strong>SQL Server Network Configuration<\/strong> alt\u0131nda <strong>Protocols for <strong>********<\/strong><\/strong> gibi kurarken belirlenen SQL servisinin ad\u0131n\u0131n bulundu\u011fu sekmeye t\u0131klay\u0131n. Hatal\u0131 y\u00f6nlenmemeniz i\u00e7in a\u015fa\u011f\u0131daki g\u00f6rselde ilgili isimleri gizledim. Buradaki <strong>TCP\/IP<\/strong> protokol\u00fcn\u00fcn <strong>etkin <\/strong>oldu\u011fundan emin olun. E\u011fer Disabled (Pasif) durumdaysa, <strong>TCP\/IP<\/strong> protokol\u00fcne sa\u011f t\u0131klay\u0131p <strong>Enable <\/strong>diyerek aktif hale getirin.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"841\" height=\"451\" class=\"wp-image-4475\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/T9F9Z6.png\" alt=\"\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/T9F9Z6.png 841w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/T9F9Z6-300x161.png 300w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_TCP_Port_degerini_1433_Olarak_Guncelleyin\"><\/span><strong>3) TCP Port de\u011ferini 1433 Olarak G\u00fcncelleyin<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p>TCP portunun 1433 olarak tan\u0131mland\u0131\u011f\u0131ndan emin olal\u0131m.<strong> TCP\/IP protokol\u00fcne sa\u011f t\u0131klad\u0131ktan sonra a\u00e7\u0131lan men\u00fcden Properties diyerek \u00f6zellikler sayfas\u0131n\u0131 a\u00e7\u0131n.<\/strong><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" class=\"wp-image-4451\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Configuration-Manager-TCP-Ozellikler.png\" alt=\"\" height=\"451\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Configuration-Manager-TCP-Ozellikler.png 841w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Configuration-Manager-TCP-Ozellikler-300x163.png 300w\" sizes=\"(max-width: 841px) 100vw, 841px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>A\u00e7\u0131lan \u00f6zelliklerde <strong>IP Addresses &gt; IPAll ba\u015fl\u0131\u011f\u0131 alt\u0131nda bulunan TCP Port de\u011ferini 1433 olarak g\u00fcncelleyin.<\/strong><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"412\" height=\"473\" class=\"wp-image-4422\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/TCP-Port-1433.png\" alt=\"\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/TCP-Port-1433.png 412w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/TCP-Port-1433-261x300.png 261w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_SQL_Server_MSSQLSERVER_Servisini_Yeniden_Baslatin\"><\/span><strong>4) SQL Server (MSSQLSERVER) Servisini Yeniden Ba\u015flat\u0131n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p>Yapt\u0131\u011f\u0131m\u0131z ayarlar\u0131n aktif olabilmesi i\u00e7in<strong> SQL Server Services<\/strong> i\u00e7erisinde bulunan <strong>SQL Server (********) servisini yeniden ba\u015flat\u0131n.<\/strong><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4457\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Restart-1024x473.png\" alt=\"\" width=\"1022\" height=\"472\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Restart-1024x473.png 1024w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Restart-300x139.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Restart-990x457.png 990w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/SQL-Server-Restart.png 1085w\" sizes=\"auto, (max-width: 1022px) 100vw, 1022px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_Firewall_Guvenlik_Duvari_Uzerinden_1433TCP_Portunu_Aktif_Edin\"><\/span>5) Firewall (G\u00fcvenlik Duvar\u0131) \u00dczerinden 1433\/TCP Portunu Aktif Edin<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p><strong>Windows Server Sunucularda &#8220;1433\/TCP&#8221; portunu aktif etmek i\u00e7in, a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:<\/strong><\/p>\r\n\r\n\r\n[vc_row][vc_column][vc_message message_box_style=&#8221;3d&#8221; message_box_color=&#8221;danger&#8221; icon_fontawesome=&#8221;fas fa-exclamation-triangle&#8221;]<span style=\"color: #000000;\">Bu ad\u0131mlar, Windows Server 2012 ve \u00fcst\u00fc s\u00fcr\u00fcmler i\u00e7in ge\u00e7erlidir ve farkl\u0131 s\u00fcr\u00fcmlerde de\u011fi\u015febilir. Ayr\u0131ca g\u00fcvenli\u011finiz i\u00e7in firewall ayarlar\u0131n\u0131 yaparken dikkatli olman\u0131z\u0131 tavsiye ederiz.<\/span> [\/vc_message][\/vc_column][\/vc_row]\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Geli\u015fmi\u015f G\u00fcvenlik Duvar\u0131 Ayarlar\u0131n\u0131z\u0131. Windows \u00c7al\u0131\u015ft\u0131r (Win+R) penceresi \u00fczerinden <code><code><\/code><\/code><strong>wf.msc<\/strong> yazarak geli\u015fmi\u015f g\u00fcvenlik duvar\u0131 ayarlar\u0131n\u0131 a\u00e7abilirsiniz.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4479\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/V3R3g7.png\" alt=\"\" width=\"321\" height=\"207\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/V3R3g7.png 478w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/V3R3g7-300x193.png 300w\" sizes=\"auto, (max-width: 321px) 100vw, 321px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>Inbound Rules<\/strong> (Gelen Kurallar) sekmesine t\u0131klay\u0131n ve &#8220;<strong>New Rule<\/strong> (Yeni Kural)&#8221; se\u00e7ene\u011fini se\u00e7in.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"767\" class=\"wp-image-4503\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/1433-Portu-Acma-1024x767.png\" alt=\"1433 Portu A\u00e7ma\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/1433-Portu-Acma-1024x767.png 1024w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/1433-Portu-Acma-300x225.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/1433-Portu-Acma-74x55.png 74w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/1433-Portu-Acma-111x83.png 111w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/1433-Portu-Acma-215x161.png 215w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/1433-Portu-Acma-990x741.png 990w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/1433-Portu-Acma.png 1047w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Kural tipini &#8220;<strong>Custom <\/strong>(\u00d6zel)&#8221; olarak i\u015faretleyip <strong>Next <\/strong>(\u0130leri) butonuna t\u0131klay\u0131n.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4504\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Custom-Rule.png\" alt=\"Firewall Custom Rule\r\n\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Custom-Rule.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Custom-Rule-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Sonras\u0131nda &#8220;<strong>All programs<\/strong> (T\u00fcm programlar)&#8221; kutucu\u011funu aktif edin ve <strong>Next <\/strong>(\u0130leri) butonuna t\u0131klay\u0131n.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4505\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-All-Programs.png\" alt=\"Firewall All Programs\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-All-Programs.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-All-Programs-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>Protocol Type (Protokol t\u00fcr\u00fc) &gt; TCP<\/strong><br \/><strong>Local Port (Yerel ba\u011flant\u0131 noktas\u0131) &gt; Specific Ports (Belirli ba\u011flant\u0131 noktalar\u0131)<\/strong> <br \/>se\u00e7eneklerini se\u00e7ip <strong>1433<\/strong> Portunu girin ve <strong>Next <\/strong>(\u0130leri) butonuna t\u0131klay\u0131n.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4507\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/TCP-Spesific-Port.png\" alt=\"\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/TCP-Spesific-Port.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/TCP-Spesific-Port-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>E\u011fer 1433 portunu genele a\u00e7mak isterseniz <strong>Any IP address <\/strong>(Herhangi Bir IP Adresi) se\u00e7ene\u011fi ile devam edebilirsiniz.<\/li>\r\n<\/ul>\r\n\r\n\r\n<div class=\"mks_pullquote mks_pullquote_left\" style=\"width:300px; font-size: 16px; color: #000; background-color:;\">G\u00fcvenli\u011finiz i\u00e7in genele eri\u015fim vermek yerine yetkili IP adreslerinize \u00f6zel kural olu\u015fturabilirsiniz.<\/div>\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4509\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Any-IP-Address.png\" alt=\"\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Any-IP-Address.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Any-IP-Address-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>IP adresine \u00f6zel olarak eri\u015fim izini verebilmek i\u00e7in <strong>Which remote IP addresses does this rule apply to?<\/strong> (Bu kural hangi uzak IP adreslerine uygulan\u0131yor?) b\u00f6l\u00fcm\u00fcnden <strong>These IP adresses:<\/strong> (Bu IP adresleri:) se\u00e7ene\u011fine se\u00e7ip <strong>Add <\/strong>(Ekle) butonuna t\u0131klay\u0131n.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4510\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Ozel-IP-Izni.png\" alt=\"Firewall Ozel IP Izni\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Ozel-IP-Izni.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Ozel-IP-Izni-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>This IP address or subnet (Bu IP adresi veya alt a\u011f) b\u00f6l\u00fcm\u00fcne izin vermek istedi\u011finiz IP adresini girin. Birden fazla IP eklemek isterseniz ayn\u0131 ad\u0131m\u0131 tekrarlayabilirsiniz.<br \/><br \/>IP adresinizi sorgulamak i\u00e7in bu web sitesini kullanabilirsiniz: <a href=\"https:\/\/ip.domainhizmetleri.com\/\">https:\/\/ip.domainhizmetleri.com\/<\/a><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4512\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-IP-Adresine-Izin-Verme.png\" alt=\"\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-IP-Adresine-Izin-Verme.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-IP-Adresine-Izin-Verme-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Eklenen IP adresinizi kontrol ettikten sonra <strong>Next <\/strong>(\u0130leri) diyerek devam edebilirsiniz.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4513\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-IP-Adresine-Izin-Verme-2.png\" alt=\"Firewall IP Adresine Izin Verme\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-IP-Adresine-Izin-Verme-2.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-IP-Adresine-Izin-Verme-2-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Otomatik olarak se\u00e7ili gelen <strong>Allow the connection<\/strong> (Ba\u011flant\u0131ya izin ver) se\u00e7ene\u011fine t\u0131klayarak devam edin.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4519\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Allow-the-connections.png\" alt=\"\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Allow-the-connections.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Allow-the-connections-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Profile b\u00f6l\u00fcm\u00fcnde bulunan t\u00fcm se\u00e7enekler otomatik olarak kutucuklar\u0131 aktif bir \u015fekilde gelecektir. Bu nedenle <strong>Next <\/strong>(\u0130leri) diyerek devam edin.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4516\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Profile-Settings.png\" alt=\"\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Profile-Settings.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/Firewall-Profile-Settings-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Son ad\u0131mdaysa ekledi\u011finiz kural i\u00e7in bir isim girin. \u00d6rne\u011fin: <strong>MSSQL Portu<\/strong> ve &#8220;<strong>Finish <\/strong>(Son)&#8221; butonuna t\u0131klay\u0131n.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" class=\"wp-image-4520\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/MSSQL-Firewall-Rule-Name.png\" alt=\"MSSQL Firewall Rule Name\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/MSSQL-Firewall-Rule-Name.png 714w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/MSSQL-Firewall-Rule-Name-300x244.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_Portu_Genel_Erisime_Acildigini_Test_Edelim\"><\/span>6) Portu Genel Eri\u015fime A\u00e7\u0131ld\u0131\u011f\u0131n\u0131 Test Edelim<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p>E\u011fer 1433\/TCP portunu genele a\u00e7t\u0131ysan\u0131z, \u00e7al\u0131\u015f\u0131p \u00e7al\u0131\u015fmad\u0131\u011f\u0131n\u0131 test etmek i\u00e7in bu web sitesini kullanabilirsiniz: <a href=\"https:\/\/portchecker.co\/checking\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"><strong>https:\/\/portchecker.co\/checking<\/strong><\/a><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/portchecker.co\/checking\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4484\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/H0k4j8.png\" alt=\"\" width=\"563\" height=\"371\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/H0k4j8.png 867w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/H0k4j8-300x198.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/H0k4j8-130x86.png 130w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/H0k4j8-187x124.png 187w\" sizes=\"auto, (max-width: 563px) 100vw, 563px\" \/><\/a><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_SQL_Server_Management_Studio_SSMS_Programiyla_Baglanti\"><\/span>7) SQL Server Management Studio (SSMS) Program\u0131yla Ba\u011flant\u0131<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p>T\u00fcm ad\u0131mlar\u0131 tamamlad\u0131\u011f\u0131m\u0131za g\u00f6re bilgisayar\u0131m\u0131zda kurulu olan <strong>SQL Server Management Studio <\/strong>(SSMS) program\u0131n\u0131 kullanarak uzak sunucuya ba\u011flant\u0131y\u0131 test edece\u011fiz. SSMS ilk a\u00e7\u0131ld\u0131\u011f\u0131nda kar\u015f\u0131m\u0131za otomatik gelen &#8220;<strong>Connect to Server<\/strong>&#8221; penceresinde;<\/p>\r\n\r\n\r\n\r\n<p>&#8220;<strong>Server name<\/strong>&#8221; alan\u0131na sunucunun IP adresini veya URL adresini, <br \/>&#8220;<strong>Authentication<\/strong>&#8221; b\u00f6l\u00fcm\u00fcne SQL Server kullan\u0131c\u0131 ad\u0131n\u0131 ve \u015fifresini girin.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"477\" height=\"315\" class=\"wp-image-4436\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/MSSQL-Server-Connect.png\" alt=\"\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/MSSQL-Server-Connect.png 477w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/MSSQL-Server-Connect-300x198.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/MSSQL-Server-Connect-130x86.png 130w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/MSSQL-Server-Connect-187x124.png 187w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Son olarak, &#8220;<strong>Connect<\/strong>&#8221; butonuna t\u0131klay\u0131n ve yukar\u0131daki t\u00fcm ad\u0131mlar\u0131 ba\u015far\u0131yla uygulad\u0131ysan\u0131z, ba\u011flant\u0131n\u0131z kurulmu\u015f olacakt\u0131r.<\/p>\r\n\r\n\r\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\r\n\r\n\r\n[vc_row][vc_column][vc_message message_box_style=&#8221;3d&#8221; message_box_color=&#8221;success&#8221; icon_fontawesome=&#8221;far fa-smile-wink&#8221;]Veritabanlar\u0131n\u0131z i\u00e7in h\u0131zl\u0131 ve g\u00fcvenli bir Sanal Sunucu hizmeti ar\u0131yorsan\u0131z, <a href=\"https:\/\/www.domainhizmetleri.com\/nvme-vds-sanal-sunucu\/\" target=\"_blank\" rel=\"noreferrer noopener\">Y\u00fcksek Performansl\u0131 NVMe VDS Sanal Sunucu<\/a> paketlerimize g\u00f6z atman\u0131z\u0131 \u00f6neririz.[\/vc_message][\/vc_column][\/vc_row]\r\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Merhaba, bug\u00fcn sizlere bir Microsoft SQL sunucusuna nas\u0131l uzaktan ba\u011flanabilece\u011finizi payla\u015faca\u011f\u0131z. Microsoft SQL Servar&#8217;a (MSSQL&#8217;e) Uzak Eri\u015fim Yapma Ad\u0131mlar\u0131 SQL sunucusuna uzaktan ba\u011flanmak i\u00e7in \u00f6ncelikle sunucunun IP adresi veya domain URL&#8217;si gerekmektedir. Bu bilgileri edindikten sonra, SQL Server Management Studio (SSMS) adl\u0131 program\u0131 kullanabilirsiniz. E\u011fer bilgisayar\u0131n\u0131zda kurulu de\u011filse SQL Server Management Studio (SSMS) program\u0131n\u0131 buradan [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":4449,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[145,147],"tags":[25,196,194,195],"class_list":["post-4408","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-nedir-nasil","category-sunucu","tag-mssql","tag-sql","tag-uzak-mssql","tag-uzak-sql"],"views":8190,"_links":{"self":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/4408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/comments?post=4408"}],"version-history":[{"count":47,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/4408\/revisions"}],"predecessor-version":[{"id":4559,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/4408\/revisions\/4559"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/media\/4449"}],"wp:attachment":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/media?parent=4408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/categories?post=4408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/tags?post=4408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}