Hi, im just testing mylittleadmin with plesk 10 hosting system. I Integrate sucefull with MS SQL server 2008 but im problem with Integrating of MS SQL 2005

When a try to restore a database with a user have full permission in this database a get this error

.Net SqlClient Data Provider

User does not have permission to RESTORE database '2oo5'.
RESTORE DATABASE is terminating abnormally.

USE [master]
GO

ALTER DATABASE [2oo5]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO

RESTORE DATABASE [2oo5]
FROM DISK=N'C:\Inetpub\vhosts\sqladmin\myLittleAdmin\mla_sql_3.7\upload\634266141455156250_backup.bak'
WITH RECOVERY
, REPLACE
, MOVE N'AFI_log' TO N'c:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\2oo5_log.LDF'
, MOVE N'AFI' TO N'c:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\2oo5.mdf'
, NOUNLOAD, STATS = 10
GO

USE [2oo5]
GO

EXEC sp_changedbowner 'sa'

USE [master]
GO

ALTER DATABASE [2oo5]
SET MULTI_USER
GO




BUT if i try to restore using "sa" user i can restore with sucefull.
I think problem is configuration.


This is my config.xml

<myLittleAdmin>

<sqlservers>
<sqlserver
address="Localhost"
name="SQL 2005"
sysadminconnection="true"
sysadminconnectionid="1"
/>
<sqlserver
address=".\MSSQLSERVER2008"
name="SQL 2008"
sysadminconnection="true"
sysadminconnectionid="1"
/>
</sqlservers>

<languages>
<language culture="en-US" name="English" default="true" />
<language culture="fr-FR" name="French" />
<language culture="de-DE" name="Deutsch" />
<language culture="ja-JP" name="Japanese" />
</languages>

<skins>
<skin folder="default" name="default" />
</skins>

<profiles>
<profile id="default" location="xml/profiles/default.xml" />
</profiles>

<dateformats>
<dateformat format="%Y%m%d %H:%M" name="20061026 17:52" />
<dateformat format="%Y/%m/%d %H:%M" name="2006/10/26 17:52" />
<dateformat format="%Y/%m/%d %I:%M %p" name="2006/10/26 5:52 PM" />
<dateformat format="%d/%m/%Y %H:%M" name="26/10/2006 17:52" />
<dateformat format="%d/%m/%Y %I:%M %p" name="26/10/2006 5:52 PM" />
<dateformat format="%m/%d/%Y %H:%M" name="10/26/2006 17:52" />
<dateformat format="%m/%d/%Y %I:%M %p" name="10/26/2006 5:52 PM" />
</dateformats>

<csvseparators>
<csvseparator value="{SEMICOLON}" name=";" />
<csvseparator value="{COMMA}" name="," />
<csvseparator value="{TAB}" name="{TAB}" />
</csvseparators>

<tools>
<backupwh
backupfolder="C:\Inetpub\vhosts\sqladmin\myLittleAdmin\mla_sql_3.7\upload\"
backupurl="http://XXXXX"
usesysadminconnection="true"
/>
<restorewh
uploadfolder="C:\Inetpub\vhosts\sqladmin\myLittleAdmin\mla_sql_3.7\upload\"
deleteafterrestore="true"
usesysadminconnection="true"
/>
<mylittlebackup
url="http://localhost/mlb/silentlogon.aspx"
/>
<newquery
rowcountdefaultvalue="0"
textsizedefaultvalue="2147483647"
/>
</tools>

<connection>
<authentications>
<authentication value="sql" name="lSqlAuthentication" localization="true" />
</authentications>
<protocols>
<protocol value="" name="lDefault" localization="true" />
<protocol value="dbnmpntw" name="lNamedPipes" localization="true" />
<protocol value="dbmsrpcn" name="lMultiprotocol" localization="true" />
<protocol value="dbmsadsn" name="lAppleTalk" localization="true" />
<protocol value="dbmsgnet" name="lVIA" localization="true" />
<protocol value="dbmslpcn" name="lSharedMemory" localization="true" />
<protocol value="dbmsspxn" name="lIPXSPX" localization="true" />
<protocol value="dbmssocn" name="lTCPIP" localization="true" />
</protocols>
<packetsize value="4096" />
<connectiontimeout value="15" />
<executiontimeout value="0" />
<debug value="false" />
<checkmssqlversion
value="true"
mla2000url="http://localhost/mla_2000/silentlogon.asp"
/>
<askdb value="true" />
</connection>

</myLittleAdmin>


This is my webconfig

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

<appSettings>
<add key="Version" value="3.7" />
<add key="Release" value="0069" />
<add key="Build" value="3833" />
<!-- Sysadmin connection value //-->
<add key="SysAdminLogin_1" value="sa" />
<add key="SysAdminPassword_1" value="15935789" />
<add key="SysAdminLogin_2" value="sa" />
<add key="SysAdminPassword_2" value="15935789" />
</appSettings>

<system.web>
<pages
validateRequest="false"
smartNavigation="false"
theme=""
/>

<compilation defaultLanguage="c#" debug="true" />

<globalization
requestEncoding="utf-8"
responseEncoding="utf-8"
culture="en-US"
/>

<customErrors mode="RemoteOnly" defaultRedirect="./error/index.html">
<error statusCode="404" redirect="./error/404.html"/>
</customErrors>

<authorization>
<allow users="?" />
</authorization>

<machineKey
validationKey="5C7EEF6650639D2CB8FAA0DA36AF24452DCF69065F2EDC2C8F2F44C0
220BE2E5889CA01A207FC5FCE62D1A5A4F6D2410722261E6A33E77E0628B17AA928039B
F"
decryptionKey="DC47E74EA278F789D2FF0E412AD840A89C10171F408D8AC4"
validation="SHA1" />

<httpRuntime
maxRequestLength="204800"
/>

<browserCaps>
<!--
Name: BrowserCaps update for modern browsers, http://slingfive.com/pages/code/browserCaps/
Author: Rob Eberhardt, http://slingfive.com/
History:
2004-11-19 improved detection of Safari, Konqueror &amp; Mozilla variants, added Opera detection
2003-12-21 updated TagWriter info
2003-12-03 first published
-->
<!-- GECKO Based Browsers (Netscape 6+, Mozilla/Firefox, ...) //-->
<case match="^Mozilla/5\.0 \([^)]*\) (Gecko/[-\d]+)(?'VendorProductToken' (?'type'[^/\d]*)([\d]*)/(?'version'(?'major'\d+)(?'minor'\.\d+)(?'letters'\w*)))?">
browser=Gecko
<filter>
<case match="(Gecko/[-\d]+)(?'VendorProductToken' (?'type'[^/\d]*)([\d]*)/(?'version'(?'major'\d+)(?'minor'\.\d+)(?'letters'\w*)))">
type=${type}
</case>
<case> <!-- plain Mozilla if no VendorProductToken found -->
type=Mozilla
</case>
</filter>
frames=true
tables=true
cookies=true
javascript=true
javaapplets=true
ecmascriptversion=1.5
w3cdomversion=1.0
css1=true
css2=true
xml=true
tagwriter=System.Web.UI.HtmlTextWriter
<case match="rv:(?'version'(?'major'\d+)(?'minor'\.\d+)(?'letters'\w*))">
version=${version}
majorversion=0${major}
minorversion=0${minor}
<case match="^b" with="${letters}">
beta=true
</case>
</case>
</case>
<!-- AppleWebKit Based Browsers (Safari...) //-->
<case match="AppleWebKit/(?'version'(?'major'\d?)(?'minor'\d{2})(?'letters'\w*)?)">
browser=AppleWebKit
version=${version}
majorversion=0${major}
minorversion=0.${minor}
frames=true
tables=true
cookies=true
javascript=true
javaapplets=true
ecmascriptversion=1.5
w3cdomversion=1.0
css1=true
css2=true
xml=true
tagwriter=System.Web.UI.HtmlTextWriter
<case match="AppleWebKit/(?'version'(?'major'\d)(?'minor'\d+)(?'letters'\w*))(.* )?(?'type'[^/\d]*)/.*( |$)">
type=${type}
</case>
</case>
<!-- Konqueror //-->
<case match=".+[K|k]onqueror/(?'version'(?'major'\d+)(?'minor'(\.[\d])*)(?'letters'[^;]*));\s+(?'platform'[^;\)]*)(;|\))">
browser=Konqueror
version=${version}
majorversion=0${major}
minorversion=0${minor}
platform=${platform}
type=Konqueror
frames=true
tables=true
cookies=true
javascript=true
javaapplets=true
ecmascriptversion=1.5
w3cdomversion=1.0
css1=true
css2=true
xml=true
tagwriter=System.Web.UI.HtmlTextWriter
</case>
<!-- Opera //-->
<case match="Opera[ /](?'version'(?'major'\d+)(?'minor'\.(?'minorint'\d+))(?'letters'\w*))">
<filter match="[7-9]" with="${major}">
tagwriter=System.Web.UI.HtmlTextWriter
</filter>
<filter>
<case match="7" with="${major}">
<filter>
<case match="[5-9]" with="${minorint}">
ecmascriptversion=1.5
</case>
<case>
ecmascriptversion=1.4
</case>
</filter>
</case>
<case match="[8-9]" with="${major}">
ecmascriptversion=1.5
</case>
</filter>
</case>
</browserCaps>
</system.web>

<system.webServer>
<httpErrors errorMode="DetailedLocalOnly" defaultPath="./error/404.html" defaultResponseMode="ExecuteURL">
<remove statusCode="404" subStatusCode="-1" />
<error statusCode="404" prefixLanguageFilePath="" path="./error/404.html" responseMode="ExecuteURL" />
</httpErrors>
</system.webServer>

</configuration>


I want buy the Mylittleadmin, but before i need be sure mylittleadmin works with plesk 10.
Thanks alot

Backuping or restoring a db requires a high permission level. Most of the time, in a shared sql environment, users do not have these privileges. Thus, myLittleAdmin offers the ability to use a sysadmin connection to perform the backup and/or restore.
This is fully explained in the installation guide, pages 5-12