Built in admin account Deleted

Posted on 2006-04-18
Last Modified: 2008-03-03
trying to comply with my companys security policy, I deleted the builtin\administrators account in sql 2005

Now I want to add an account so I can access the sql server but it will not let me. I am guessing that I should have added that account first, Any Ideas how I can fix this?
Question by:JonMny
    LVL 68

    Expert Comment

    Do you have an 'sa' account and know the related password?
    LVL 9

    Author Comment

    I do have the sa account. I think it has limited rights set up for windows authentication, also some other accounts were added and they have sysadmin rights

    LVL 68

    Accepted Solution

    Any account with "sysadmin" rights is good enough.  That will give you full authority once you get in.
    LVL 68

    Expert Comment

    Btw, I suggest not deleting the BUILTIN account but removing all authority from it.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now