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 |
|
BitShift
Yak Posting Veteran
98 Posts |
 Posted - 2007-05-02 : 18:05:10
|
| Im running sql 2005 developer edition on my xp pro workstation. For some reason I can no longer create a database. I get an error such as the following:"CREATE DATABASE permission denied in database 'master' (Microsoft sql server error: 262)"ideas ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-02 : 18:08:55
|
| How are you connecting? With sa account? With Windows Authentication? If Windows Authentication, is the account a member of the local admin group? If not, has the Windows account been added to the sysadmin fixed server role in SQL Server? If the account is a member of the local admin group, did you remove sysadmin from BUILTIN\Administrators role in SQL Server?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-02 : 22:42:35
|
| The account used should be in db creator server role at least. |
|
|
|
|
|
|
cant create db locally