+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    HMCTech's Avatar
    Join Date
    Apr 2008
    Posts
    618
    Thank Post
    37
    Thanked 48 Times in 35 Posts
    Rep Power
    23

    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.

  2. #2

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    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.

    HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode

    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.

  3. #3

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    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

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 06:03 AM
  2. SQL 2008 express
    By Boon72 in forum Windows Server 2008 R2
    Replies: 1
    Last Post: 3rd February 2010, 10:55 AM
  3. Unable to add domain resources in Windows Server 2008 TSG role.
    By albertwt in forum Windows Server 2008
    Replies: 9
    Last Post: 8th September 2009, 02:16 AM
  4. SQL Account for Moss 2007
    By imiddleton25 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 1st April 2009, 11:30 PM
  5. SQL Server 2008 Maintenance course
    By googlemad in forum Courses and Training
    Replies: 0
    Last Post: 25th January 2009, 10:12 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •