Question Locked

SQL2008 database permissions

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I set up SQLexpress08 on a pc just to learn and whatnot. Got a couple nice DBs put together (faily good sized ones too), and later decided to add the computer to my AD for ease of use. Now all my DBs say insufficient privaledges. I cant even load them unless i go back to the local user. I checked the logins section and my AD username is listed as public. When i tried to check all the allow checkboxes it throws up another error with same message.

I tried to export the DBs as scripts, which was fine, but when i try to execute them i still dont have the right privs, so they fail.

What'd i miss?

2 replies

by demosthanese

I'm dumb. Went over to the local login and changed the privs. Disregard my oversight.

This discussion is closed to new replies.