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:07:35
|
| 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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-02 : 14:09:21
|
| Duplicate, locking thread.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
CREATE DATABASE permission denied in database ‘mas