{"id":61,"date":"2011-10-24T10:26:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=61"},"modified":"2011-10-24T10:26:00","modified_gmt":"1970-01-01T00:00:00","slug":"sql-server-the-account-is-disabled-hatasinin-cozumu","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2011\/10\/24\/sql-server-the-account-is-disabled-hatasinin-cozumu\/","title":{"rendered":"Sql Server the Account is Disabled Hatasinin \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"

Geçen günlerde karsilastigim bir problemin çözümü üzerine bu makaleyi paylasiyorum.<\/p>\n

Sql Server üzerinde çalisirken bir an veritabanindan cevap alamadim ve oturumum sonlandirip, tekrardan giris yapmak istedim.<\/p>\n

Ancak tekrardan giris yaptigimda ‘The account is disabled’ hatasiyla karsilastim, admin yetkisine sahip bu kullanicinin disable olmasi demek, bu hesapla yapilan bütün uygulamalarin, islemlerin çalismamasi demek.<\/p>\n

Daha sonrasinda ise veritabanimi "sa" kullanicisiyla girip su tsql koduyla kullanicimi enable ettim.<\/p>\n

\n

ALTER LOGIN VeriTabaniKullaniciAdi ENABLE<\/div>\n<\/code><\/p>\n

Bu sayede tekrardan kullanicim aktiflesti, sizin de benzer durumda çözümünüz için bu t-sql kodu isinizi görebilir.<\/p>","protected":false},"excerpt":{"rendered":"

MSSql server üzerinde disable edilmis kullaniciyi aktiflestirme islemi nasil yapilir<\/p>\n","protected":false},"author":522,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[422],"tags":[5247,4268,4508,5014],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/61"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/522"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}