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 |
|
gongxia649
So Suave
344 Posts |
 Posted - 2007-04-17 : 11:13:31
|
| im performing a backup on the master and i receive this error "backup database permission denied in database master"anyone input will be appreaciated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-17 : 11:18:39
|
| Which sql login did you use? Only sysadmin, db_owner and db_backupoperator can backup db. |
 |
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-04-17 : 13:51:34
|
| rmiao,when i try to assign a sysadmin role to the windows authentication login name. it shows the erro 15247 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-17 : 14:17:49
|
| Do you have complete error message? Did you connect to sql as sysadmin? |
|
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-04-17 : 14:33:49
|
| i connected as windows authentication login."user does not have permission to perform this action error 15247" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-17 : 14:47:58
|
| The account that you are using does not have sufficient privileges to backup the database nor to assign the proper server role.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
backup master