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 |
|
Kwacha
Starting Member
2 Posts |
 Posted - 2012-07-10 : 05:56:28
|
| I am getting a db_owner permission error when I try creating a database in SQL. What could be the problem, how do I grant the permissions?.Kwacha |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-07-10 : 08:41:04
|
| Could you post the exact error message?Does the logon you are using have sufficient permissions to CREATE database?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Kwacha
Starting Member
2 Posts |
Posted - 2012-07-12 : 02:09:24
|
| "User sa does not have db_owner permission to the system database. Cannot continue with refresh". |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-07-13 : 14:52:59
|
| Could you post the Server permissions the User sa has on the SQL Server Instance?Just to confirm - are you doing : CREATE DATABASE mydbname ?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
DB_OWNER permissions