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 |
|
prakashdotc
Starting Member
25 Posts |
 Posted - 2006-09-22 : 07:48:15
|
| Hi All, i'm working on a tool in vb.net, which is used to backup database and restore it. I have a database 'DBBackupTest' with permissions as db_owner, when i execute backup query from my application it throws error as 'User don't have permission to perform this action', but when i execute backup query in the query analyzer it execute's file and takes backup of database, i also tried with window's authentication but same problem, what are the 'ServerRole' permissions and 'Access' permissions required for this to work... - Prakash.C |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-22 : 13:13:18
|
Taken directly from SQL Server Books Online:quote:
PermissionsBACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles.
So if you are getting the error, then I suspect that your connection string is using the wrong account.Tara Kizer |
 |
|
|
|
|
|
Permission required to Backup Database