OK, I did something stupid and now cannot get access to my server...
I was experimenting with the security/login settings and denied access to BUILTIN\Administrators. Now I cannot get on my server.
Anyone else ever done this? What can I do to get back on without loosing some of my data?
Any help would be appreciated.
You don't have the sa password? Do you have another NT group that does have admin rights in SQL? If all fails, you can rebuild the master, then reattach your db's. Use appropriate caution.
Thanks for your response...I did end up rebuilding the DB and reattaching the .mdf files...worked like a charm.
I'll never make that mistake again...and now I do have the sa password.
Viewing 3 posts - 1 through 2 (of 2 total)