- 0
sql SQL Server 2008 R2 - Administrator Locked Out
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Similar Content
-
Distributed SQL: The architecture behind MariaDB Xpand — Free Whitepaper
By News Staff,
- ebook offer
- sponsored
- (and 4 more)
- 0 replies
- 0 views
-
- 0 replies
- 0 views
-
- 8 replies
- 1,603 views
-
Save 98% off this multi-course Premium Coding Skills Bundle
By News Staff,
- neowin deals
- online courses
- (and 12 more)
- 0 replies
- 0 views
-
This Premium Google Sheets & Microsoft Excel Certification Bundle is Price Dropped to $20
By News Staff,
- google sheets
- microsoft excel
- (and 9 more)
- 0 replies
- 0 views
-
Question
Jason S. Global Moderator
last week i managed to lock myself out of SSMS :pinch:
so, after doing some searches on Google, i found these sites which seemed promising:
http://www.bandgap.cs.rice.edu/classes/comp410/resources/Using%20SQL%20Server/How%20to%20regain%20access%20if%20you%27ve%20been%20locked%20out.aspx
http://beyondrelational.com/blogs/chintak/archive/2010/07/20/sql-2008-r2-new-installation-and-login-password-unknown.aspx
http://msdn.microsoft.com/en-us/library/dd207004%28v=sql.110%29.aspx
I found this on the MSDN site, linked above: "Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role." Neither the -m or -f work, btw.
None of these sites have worked for me. I've now tried to use this "-m" technique through cmd as well as the SQL Server Configuration Manager. After making the change, i restart the SQL Server service as well as the SQL Server Browser service. i then reopen SSMS and try to login using the admin account and it still tells me that the account is locked. Since there is another Administrator on this server, i logged in to Windows as this admin, then tried to open SSMS... same result - says that the account doesnt exist. So, clearly, this "-m" switch isnt working.
Does anyone have another workaround? All I need is to re-enable the administrator account again.
Link to comment
Share on other sites
5 answers to this question
Recommended Posts