unable to manage SQL 2008
Posted on 2010-09-23
okay , long story short ..
I have a SQL server 2008 Express installation ;
- it's configured to use windows authentication ONLY!
- I know sa password
- I had a domain account that was an admin of this instance.
for some reason the domain/windows account is gone ; now I only have 'sa' account and
another domain account that is NOT an admin .
Is there any way to fix this issue , so that I can create a new windows admin account on it ?
right now I cannot login with 'sa' ; it rejects access as it's configured to accept windows authentication.
When I login with a local admin , I can connect to databases but cannot do any admin jobs.
what's best ?