Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gzeng
Starting Member
3 Posts |
 Posted - 2007-07-02 : 14:00:04
|
| I installed IIS Manager to my Vista PC and then SQL Server 2005 Express and SQL Server Management Studio Express using Windows Authentication. I could successfully connect to SQL Server. However, when I tried to create a new database, I got the error:CREATE DATABASE permission denied in database ‘master’I searched mant forums thru web about this error but could not find a resolution. I have BUILTIN\Users and sa in the Logins under Security. But BUILTIN\Users is not in any Server Roles. I tried to add it to public or dbcreator but was not allowed to do so, while sa is only in sysadmin. Anybody could help me solve this program? Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-02 : 14:26:50
|
| You need logon with sa and add proper sql login to db creator server role. |
 |
|
|
|
|
|
CREATE DATABASE permission denied in database ‘mas