|
|
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 |