|
Rank: Newbie Groups: Member
Joined: 3/29/2007 Posts: 4 Points: 0 Location: Ireland
|
Little issue, perhaps someone has come across this. Working on deploying myLittleAdmin for an SQL '05 shared server. Security by default is very restricted on our servers. However to allow for myLittleAdmin we've added specific permissions to databases for users.
However, when attempting a resoration of a database we are receiving the following error:
User does not have permission to RESTORE database 'user_testerdb'. RESTORE DATABASE is terminating abnormally.
The user, 'user_tester' has the following rights on the 'user_testerdb' database role membership:
db_accessadmin db_backupoperator db_datareader db_datawriter db_ddladmin db_owner db_securityadmin
Any ideas why the backup won't work?
Thanks...
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Hi Thanks to check that you well use v3.1d. Also could you please tell us if you are using the Restore wizard for Webhosting companies or the other one? At last, do not hesitate to send an exact description of your install and config (with web.config and config.xml files) at support@mylittletools.netBest regards
|
|
Rank: Newbie Groups: Member
Joined: 3/29/2007 Posts: 4 Points: 0 Location: Ireland
|
Hi Elian,
Thanks for the quick reply, yep, using the full version of v3.1d
Using the restore wizard for webhosting to restore the database.
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Could you please check that you well defined the sysadminconnection and sysadminconnectionid properties in your web.config file as well as the SysAdminLogin_1 and SysAdminPassword_1 keys in your web.config file?
(more info can be found in the WH Backup Restore Configuration Guide, located in the install folder)
Hope this helps
|
|
Rank: Newbie Groups: Member
Joined: 3/29/2007 Posts: 4 Points: 0 Location: Ireland
|
sysadminconnection and sysadminconnectionid settings were the ones to watch for... i had sysadminconnection set to false... i'm a little worried though, how secure is this connection if an ordinary user has what looks to be a connection also using the SA account
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
The sysadmin connection is located in the web.config file and cannot be seen. Also this sysadmin connection is only used with Backup/Restore wizards.
|
|
Rank: Newbie Groups: Member
Joined: 3/29/2007 Posts: 4 Points: 0 Location: Ireland
|
Wasn't TOO worried, but that makes me sleep a little better tonight, thanks for the assistance..
Great little tool so far!
|
|
Guest |