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 |
|
jcb267
Constraint Violating Yak Guru
291 Posts |
 Posted - 2008-11-12 : 21:37:01
|
| I am just beginning to learn SQL. I have installed SQL on my machine now want to create a local database so I can start learning. I keep getting this error though - CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262). What am I doing wrong? |
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-11-12 : 21:42:14
|
| Most likely the account you use to create a login is membe of the Builtin\User group in windows xp and it is not a member of sysadmin or dbcreators fixed server role. Use sa account to create a new login. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-12 : 22:27:26
|
| This issue has been discussed many times in this forum. Are you using Express edition? Please search it. |
|
|
|
jcb267
Constraint Violating Yak Guru
291 Posts |
Posted - 2008-11-12 : 22:29:42
|
Yes, I am using the Express edition and Windows Vista.quote:
Originally posted by sodeep
This issue has been discussed many times in this forum. Are you using Express edition? Please search it.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-12 : 22:37:33
|
| Did you take eagerness to search in Search button? |
|
|
|
|
|
|
Creating a Database