login with another user faile problem
-
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.
-
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
-
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.