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?
