• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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?
0
JonMny
Asked:
JonMny
  • 3
1 Solution
 
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:
Any account with "sysadmin" rights is good enough.  That will give you full authority once you get in.
0
 
Scott PletcherSenior DBACommented:
Btw, I suggest not deleting the BUILTIN account but removing all authority from it.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now