{"id":675,"date":"2014-03-03T18:30:08","date_gmt":"2014-03-03T16:30:08","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=675"},"modified":"2014-03-03T18:30:08","modified_gmt":"2014-03-03T16:30:08","slug":"mssql-uzak-erisimini-hizlica-test-etmek","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2014\/03\/mssql-uzak-erisimini-hizlica-test-etmek\/","title":{"rendered":"Mssql Uzak Eri\u015fimini H\u0131zl\u0131ca Test Etmek"},"content":{"rendered":"<p>Mssql connection manager kullanmadan uzak mssql e ba\u011flan\u0131p veritaban\u0131m\u0131za eri\u015febiliyor muyuz eri\u015femiyor muyuz sorusunun cevab\u0131 i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemi uygulayabilirsiniz.<\/p>\n<p>\u00d6ncelikle masa \u00fcst\u00fcm\u00fczde bir test.txt isimli dosya yaratal\u0131m , sonra dosyan\u0131n uzant\u0131s\u0131n\u0131 .udl olarak de\u011fi\u015ftirelim , e\u011fer bu i\u015flemi yapmakta sorun ya\u015far iseniz muhtemelen bilindik dosya adlar\u0131n\u0131 otomatik olarak gizle se\u00e7ene\u011finiz aktiftir , herhangi bir klas\u00f6r\u00fcn view properties men\u00fcs\u00fcnden yapabilirsiniz.<\/p>\n<p>Olu\u015fturdu\u011fumuz test.udl dosyas\u0131n\u0131 \u00f6zelliklerine girip connection tab \u0131n\u0131 a\u00e7al\u0131m.<\/p>\n<p>Select or enter a server name b\u00f6l\u00fcm\u00fcne mssql sunucunun ip adresini ya da hostname ini girelim.<\/p>\n<p>Use a specific user name and password b\u00f6l\u00fcm\u00fcnde User name k\u0131sm\u0131na Size iletilen mssql kullan\u0131c\u0131 ad\u0131n\u0131z\u0131 girelim , passwprd b\u00f6l\u00fcm\u00fcne ise \u015fifrenizi girelim.<\/p>\n<p>E\u011fer buraya kadar bilgiler do\u011fru ve mssql server eri\u015filebilir ise Select the database file as a database name b\u00f6l\u00fcm\u00fcn\u00fcn \u00fczerine geldi\u011finizde eri\u015febildi\u011finiz veritaban\u0131 adlar\u0131n\u0131 g\u00f6rebiliyor olacaks\u0131n\u0131z , i\u015fte hepsi bu kadar. G\u00f6rebiliyorsan\u0131z uzak eri\u015fim sorunsuzdur.<\/p>\n<p><a href=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-676\" alt=\"mssql1\" src=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql1.png\" width=\"311\" height=\"320\" srcset=\"https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql1.png 311w, https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql1-291x300.png 291w\" sizes=\"auto, (max-width: 311px) 100vw, 311px\" \/><a href=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-677\" alt=\"mssql2\" src=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql2.png\" width=\"281\" height=\"139\" \/><\/a><\/a><\/p>\n<p><a href=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-678\" alt=\"mssql3\" src=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql3.png\" width=\"255\" height=\"320\" srcset=\"https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql3.png 255w, https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql3-239x300.png 239w\" sizes=\"auto, (max-width: 255px) 100vw, 255px\" \/><\/a><a href=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-679\" alt=\"mssql4\" src=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql4.png\" width=\"255\" height=\"320\" srcset=\"https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql4.png 255w, https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/03\/mssql4-239x300.png 239w\" sizes=\"auto, (max-width: 255px) 100vw, 255px\" \/><\/a><span style=\"color: #ffffff;\">Test remote SQL connectivity EASILY!<\/span><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/tr\/share-medium.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Pinterest\",\"Linkedin\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"ayhanarda\";var hupso_url_t=\"\";var hupso_title_t=\"Mssql%20Uzak%20Eri%C5%9Fimini%20H%C4%B1zl%C4%B1ca%20Test%20Etmek\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"Mssql connection manager kullanmadan uzak mssql e ba\u011flan\u0131p veritaban\u0131m\u0131za eri\u015febiliyor muyuz eri\u015femiyor muyuz sorusunun cevab\u0131 i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemi uygulayabilirsiniz. \u00d6ncelikle masa \u00fcst\u00fcm\u00fczde bir test.txt isimli dosya yaratal\u0131m , sonra dosyan\u0131n uzant\u0131s\u0131n\u0131 .udl olarak de\u011fi\u015ftirelim , e\u011fer bu i\u015flemi yapmakta sorun ya\u015far iseniz muhtemelen bilindik dosya adlar\u0131n\u0131 otomatik olarak gizle se\u00e7ene\u011finiz aktiftir , herhangi bir klas\u00f6r\u00fcn [&hellip;]","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[482],"tags":[432,483,484,485],"class_list":["post-675","post","type-post","status-publish","format-standard","hentry","category-mssql-2","tag-mssql","tag-mssql-connecion-test","tag-mssql-connectivity","tag-remote-mssql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/comments?post=675"}],"version-history":[{"count":1,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/675\/revisions"}],"predecessor-version":[{"id":680,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/675\/revisions\/680"}],"wp:attachment":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/media?parent=675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/categories?post=675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/tags?post=675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}