deleted database manager now can not administor database

G

Guest

i member of staff had left, a we deleted this person as a user, we then found
that this user was set up as the database administrator, we can not now give
any one else access to this database.
Having relized our mistake after 7-10 days we tried to reset up that user
again, but software knows it is not the orginal user.
If any one has any sugestions they would be very much appreciated
Regards

Mark Woodward

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-e07786f126aa&dg=microsoft.public.outlook.bcm
 
L

Luther

In general, any user who is a member of the NT administrator's group
should have full control.

Take one of the existing users, and promote them to the admin group,
they should then be able to add new users to the database.

To change the db owner permanently you'll need to use sql tools to
change the ownership in the database itself.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top