<\/div>\n

E\u011fer localde MS SQL Server \u00fczerinde \u00e7al\u0131\u015fma ger\u00e7ekle\u015ftirmeniz gerekiyor ve SQL Server’da local servera ba\u011flan\u0131rken a\u015fa\u011f\u0131daki hatay\u0131 al\u0131yorsan\u0131z \u00e7\u00f6z\u00fcm\u00fcn\u00fc buradan bulabilirsiniz.
\nHatam\u0131z\u0131n g\u00f6rsel hali a\u015fa\u011f\u0131daki gibidir.
\n $\"MS$ <\/a><\/p>\n

Metinsel olarak hatay\u0131 belirmek gerekirse;<\/p>\n

Cannot connect to ASUS<\/strong><\/em><\/span><\/p>\n
Additional information:<\/strong><\/em><\/span><\/p>\n
Sucuyla ba\u011flant\u0131 kurulurken a\u011f ile ilgili veya \u00f6rne\u011fe \u00f6zel bir hata olu\u015ftu.Sunucu bulunamad\u0131 veya sunucuya eri\u015filemiyor.\u00d6rnek ad\u0131n\u0131n do\u011fru oldu\u011funu ve SQL Server’\u0131n uzak ba\u011flant\u0131lara izin verdi\u011fini do\u011frulay\u0131n.(provider. Named Pipes Provider, error: 40 – SQL Server i\u00e7in ba\u011flant\u0131 a\u00e7\u0131lamad\u0131) (Microsoft SQL Server, Error: 2)<\/strong><\/em><\/span><\/p>\n
Sistem belirtilen dosyay\u0131 bulam\u0131yor.<\/strong><\/em><\/span><\/p><\/blockquote>\n
Evet g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi hatam\u0131z yukar\u0131daki gibi olacakt\u0131r.
\n\u00d6ncelikle bu hatan\u0131n sebebine de\u011finmemiz gerekirse,
\nSQL Server sunucusunun \u00e7al\u0131\u015fmamas\u0131ndan bu hata kaynaklanmaktad\u0131r.Hatta localde sorunsuz \u00e7al\u0131\u015fan SQL Server bilgisayar\u0131 yeniden a\u00e7\u0131p kapatt\u0131\u011f\u0131m\u0131zda bu hatay\u0131 verebilir.Bunun sebebi SQL Server’\u0131n ba\u015flat\u0131lmam\u0131\u015f olmas\u0131ndan kaynaklanmaktad\u0131r.<\/p>\n
Bu hatay\u0131 atlatabilmek i\u00e7in SQL Server’\u0131 \u00e7al\u0131\u015ft\u0131rmak – ba\u015flatmak yeterlidir.Bu i\u015flemler i\u00e7in a\u015fa\u011f\u0131daki kombinasyonlar\u0131 takip ediniz.<\/p>\n
\n
Ba\u015flat<\/strong> -> \u00c7al\u0131\u015ft\u0131r<\/strong>‘\u0131 a\u00e7\u0131n\u0131z.<\/li>\n
\u00c7al\u0131\u015ft\u0131r penceresinde\u00a0services.msc<\/strong> komutunu yaz\u0131n\u0131z ve tamam butonuna t\u0131klay\u0131n\u0131z.
\n $\"MS$ <\/a><\/li>\n
Kar\u015f\u0131n\u0131za Hizmetler<\/strong> penceresi gelecektir.Bu pencereden SQL Server (MSSQLSERVER)<\/strong>‘\u0131 bulunuz.
\n $\"MS$ <\/a><\/li>\n
G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi SQL Server (MSSQLSERVER)<\/strong>‘\u0131n “Durum<\/strong>” bilgisi bo\u015f durmaktad\u0131r.Yani \u00e7al\u0131\u015fmamaktad\u0131r.SQL Server (MSSQLSERVER)<\/strong>\u00a0sa\u011f t\u0131klayarak “Ba\u015flat<\/strong>” butonuna t\u0131klay\u0131n\u0131z.
\n $\"MS$ <\/a><\/li>\n
Bu i\u015flemler neticesinde a\u015fa\u011f\u0131daki gibi SQL Server ba\u015flat\u0131lacakt\u0131r.
\n $\"MS$ <\/a><\/li>\n
Son durum olarak Hizmetler penceresinde SQL Server’\u0131n “Durum” kar\u015f\u0131l\u0131\u011f\u0131 “\u00c7al\u0131\u015f\u0131yor” olarak g\u00f6r\u00fclmesi gerekmektedir.
\n $\"MS$ <\/a><\/li>\n<\/ul>\n
Bu i\u015flemler neticesinde yukar\u0131da belirtti\u011fimiz hata al\u0131nmayacak ve SQL Server’a s\u0131k\u0131nt\u0131s\u0131z bir \u015fekilde giri\u015f sa\u011flayabileceksiniz.<\/p>\n
Sonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere…<\/p>\n
\u0130yi \u00e7al\u0131\u015fmalar…<\/p>\n","protected":false},"excerpt":{"rendered":"
E\u011fer localde MS SQL Server \u00fczerinde \u00e7al\u0131\u015fma ger\u00e7ekle\u015ftirmeniz gerekiyor ve SQL Server’da local servera ba\u011flan\u0131rken a\u015fa\u011f\u0131daki hatay\u0131 al\u0131yorsan\u0131z \u00e7\u00f6z\u00fcm\u00fcn\u00fc buradan bulabilirsiniz. Hatam\u0131z\u0131n g\u00f6rsel hali a\u015fa\u011f\u0131daki gibidir. Metinsel olarak hatay\u0131 belirmek gerekirse; Cannot connect to...<\/p>\n","protected":false},"author":1,"featured_media":3415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[258,22],"tags":[260,849,484,542,245],"class_list":["post-3407","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hata-cozumleri","category-veritabani","tag-hata","tag-hata-cozumleri","tag-hata-cozumu","tag-ms-sql-server","tag-sql-server"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=3407"}],"version-history":[{"count":1,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3407\/revisions"}],"predecessor-version":[{"id":10389,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3407\/revisions\/10389"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3415"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=3407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=3407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=3407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}