While I am a fan of Vista and UAC, I have to admit there are times when other applications really cause it to be annoying, tonight it was SQL Express causing me pain. I wanted to try one of Microsoft sample’s, so I downloaded the zip, extracted it, loaded Visual Studio 2008 and hit F5. At this point, the debugger stepped in and told me there was an error opening the database connection.
“CREATE DATABASE permission denied in database ‘master’.rnAn attempt to attach an auto-named database for file <
To create a database on SQL you need local admin permissions, as the application was automatically attaching the database I had to run Visual Studio as Administrator before I could execute it. Just find it a bit annoying that you need access to Master to attach a SQL Express database as the whole point is for it to be zero friction.
What I do is easy, I use SQL Server Management Studio Express and runit with administrator privileges, add the dba roles to my user account in security and voila! it would never happen again!
Thanks for your post, I just met such problem and didn’t know how to resolve it, it’s so easy:)
I’ve tried running SQL Management studio as an administrator as well as several other things I’ve found as possible solutions. Every single one says I don’t have permission. This is completely retarded. SQL 2008 and Vista is a complete joke.