Urgent help needed!!!

[diasflac]

:banghead:

I started using the security wizard and it quickly dawned on me that I didn't know what I was doing. So I removed what I was doing, or at least I thought it did.

Now there is only one set of permissions Admin, and Admin has no permissions at all. When I try to check admin rights or even read rights back to the Admin it says I need to be logged in as admin, which I am.

Is there anyway at all I can either copy some information from 2 tables and put it in my back up?? I'm really stuck here and need to fix this or I'll have lost considerable amounts of work.

 

[Chris1985]

Can you add a new user and give this user all admin rights - make sure you change this user to owner as well.
- Tools - Security - User groups and permissions - Change owner tab.

Hope this helps

 

[Pat Hartman]

Since ULS was deprecated 6 years ago, you should probably not be attempting to implement it now. Search here for "Security FAQ". You should find a document written by MS that may help you undo what you have done. If you don't find it here, use Google but add "Access" to the search criteria.

 

[diasflac]

It will let me create a new user, but I cannot give any rights (I only need read access rights to copy information into an older back up) as I have no admin rights.

I've tried google but there's nothing specific. All I need to do is be able to read and copy the tables to the back up which has no information in it. If I can by pass security this would be good too. Obviously the best option is to be able to restore access to the database.

The System.mbd file in application data asks for a password if I attempt to undo it like microsoft said, but I gave both my username and admin no password so I can't even follow that step as it says the passwords are wrong.

 

[Pat Hartman]

I guess your Google couldn't find this:
http://support.microsoft.com/kb/207793

 

[diasflac]

Yes it did, de-securing and removing ULA restrictions cannot be done while none of the accounts have any access. The solution will require something more hackerist it would seem.

I've remade it using a back up now anyway so I don't need a solution, just wasted a day lol.