{"id":1045,"date":"2014-02-25T17:21:44","date_gmt":"2014-02-25T14:21:44","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1045"},"modified":"2014-04-08T10:54:54","modified_gmt":"2014-04-08T07:54:54","slug":"error-cannot-open-user-default-database-in-mssql-server","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/error-cannot-open-user-default-database-in-mssql-server\/","title":{"rendered":"Error : Cannot Open User Default Database in MsSQL Server"},"content":{"rendered":"<p>If you delete default database of user, users of default database can not connect to database. You have to connect with sqlcmd on master database. After you have to change default database of user.<\/p>\n<p><strong>Error<\/strong><\/p>\n<blockquote><p>Cannot open user default database. Login failed.<\/p><\/blockquote>\n<p><strong>Solution <\/strong><\/p>\n<blockquote><p>Open CMD prompt<br \/>\nC:\\>sqlcmd -E -d master<br \/>\n1> alter login [domain\\LoginUser] with default_database = master<br \/>\n2> go<br \/>\n3> quit<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>If you delete default database of user, users of default database can not connect to database. You have to connect with sqlcmd on master database. After you have to change default database of user. Error Cannot open user default database. Login failed. Solution Open CMD prompt C:\\>sqlcmd -E -d master 1> alter login [domain\\LoginUser] with&#8230;<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,57],"tags":[14,96,46],"class_list":["post-1045","post","type-post","status-publish","format-standard","hentry","category-administration-mssql-server","category-errors-and-solutions-mssql-server","tag-database-administration","tag-mssql-server","tag-sql-server-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-gR","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1045"}],"version-history":[{"count":6,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1045\/revisions"}],"predecessor-version":[{"id":1103,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1045\/revisions\/1103"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1045"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}