Built in admin account Deleted

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?
LVL 9
JonMnyAsked:
Who is Participating?
 
Scott PletcherSenior DBACommented:
Any account with "sysadmin" rights is good enough.  That will give you full authority once you get in.
0
 
Scott PletcherSenior DBACommented:
Do you have an 'sa' account and know the related password?
0
 
JonMnyAuthor Commented:
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


0
 
Scott PletcherSenior DBACommented:
Btw, I suggest not deleting the BUILTIN account but removing all authority from it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.