|
hi every buddy
i hav e a problem to create new user in sql server 2008 r2
i create a user and my user created.
and i logined with this user succesfully. but when i want to create a new database in sqlserver authentication mode
i facing with this problem
"Create Database permission Denied in DataBase master.[error 262]"
thanks for any help.
|
|
|
|
|
You need dbo permission on the Master database (I think) to be able to create a database. Do some research on what permissions are available in SQL server it will be very enlightening.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
grant server role with sysadmin
|
|
|
|