Windows Thread, SQL 2008 recover an account to the sysadmin role in Technical; Unfortunatly SQL was installed in windows authentication only and it is unknown which user has the sysadmin role. We have ...
21st April 2010, 09:17 AM #1
SQL 2008 recover an account to the sysadmin role
Unfortunatly SQL was installed in windows authentication only and it is unknown which user has the sysadmin role. We have tried a few steps to add a user to the role, one of them being start in single user mode which we have done but when 'sqlcmd' is started it says an administrator is already connected.
As no account has the sysadmin role we can not change to windows and sql authentication which means the sa account is disabled.
IDG Tech News
21st April 2010, 10:13 AM #2
How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition
I'm not sure if this will also apply to SQL 2008, but you can always have a look. The KB above mentions a registry key which can be set to change the authentication mode to Mixed.
If that works you should be able to go in as sa and move on from there.
It is actually possible with SQL 2008 to install without any administrators, since the default rights are not assigned as they were in SQL 2005. You have to explicitly state any accounts you want to give admin rights.
22nd April 2010, 11:39 AM #3
As an alternative, if you've set up the SQL service to run under a dedicated account, could you use this to run a SQL query against the database to add an administrator/other account as serveradmin?
Edit: Or better yet - http://blogs.ameriteach.com/chris-ra...r-account.html
By Kamran7860 in forum Virtual Learning Platforms
Last Post: 23rd November 2010, 07:03 AM
By Boon72 in forum Windows Server 2008 R2
Last Post: 3rd February 2010, 11:55 AM
By albertwt in forum Windows Server 2008
Last Post: 8th September 2009, 03:16 AM
By imiddleton25 in forum Virtual Learning Platforms
Last Post: 2nd April 2009, 12:30 AM
By googlemad in forum Courses and Training
Last Post: 25th January 2009, 11:12 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)