{"id":169,"date":"2012-04-16T14:56:28","date_gmt":"2012-04-16T18:56:28","guid":{"rendered":"https:\/\/jeremystein.com\/brain\/?p=169"},"modified":"2012-04-16T14:56:28","modified_gmt":"2012-04-16T18:56:28","slug":"only-one-administrator-can-connect-at-this-time","status":"publish","type":"post","link":"https:\/\/jeremystein.com\/brain\/only-one-administrator-can-connect-at-this-time\/","title":{"rendered":"Only one administrator can connect at this time"},"content":{"rendered":"<p>Having somehow removed my own access to the database, I restarted SQL Server 2005 in single-user mode.  When I tried to connect with sqlcmd, I got this error:<\/p>\n<blockquote><p>Login failed for user &#8216;MYDOMAIN\\me&#8217;. Reason: Server is in single user mode.<br \/>\nOnly one administrator can connect at this time.<\/p><\/blockquote>\n<p>It turns out I had to first stop SSIS, SSAS, SSRS, etc.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Having somehow removed my own access to the database, I restarted SQL Server 2005 in single-user mode. When I tried to connect with sqlcmd, I got this error: Login failed for user &#8216;MYDOMAIN\\me&#8217;. Reason: Server is in single user mode. Only one administrator can connect at this time. It turns out I had to first [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-169","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/posts\/169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/comments?post=169"}],"version-history":[{"count":0,"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/posts\/169\/revisions"}],"wp:attachment":[{"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/media?parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/categories?post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jeremystein.com\/brain\/wp-json\/wp\/v2\/tags?post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}