|
Rank: Newbie Groups: Member
Joined: 4/23/2010 Posts: 4 Points: 12 Location: Netherlands
|
Just like cclemon in topic http://forum.mylittleadmin.com/yafnet/Default.aspx?g=posts&t=311I am unable to do a restore of the database. Could you name an example on how i should be able to restore the database? My server is server web 2k8 with mssql 2k8 once again the exact error: Code: Offending URL: http://XXXXX/tools/restorewh.aspx
Source: mla_gui
Message: Object reference not set to an instance of an object.
Stack trace: at mla_gui.RestoreWH.btnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Target site: Void btnSubmit_Click(System.Object, System.EventArgs)
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
We need to know which version/release you are running. We also need a copy of your web.config and config.xml files.
|
|
Rank: Newbie Groups: Member
Joined: 4/23/2010 Posts: 4 Points: 12 Location: Netherlands
|
Sorry for my late reaction Here is the information: Version myLittleAdmin V 3.6 config.xml Code: <myLittleAdmin>
<sqlservers> <sqlserver address="127.0.0.1" name="localhost" /> </sqlservers>
<languages> <language culture="en-US" name="English" default="true" /> </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="\\IP-address-server\dbbackup\" backupurl="http://xxxxxxx/dbbackup" usesysadminconnection="true" /> <restorewh uploadfolder="\\IP-address-server\dbupload\" deleteafterrestore="true" usesysadminconnection="true" /> <mylittlebackup url="http://localhost/mlb/silentlogon.aspx" /> </tools>
<connection> <authentications> <authentication value="sql" name="lSqlAuthentication" localization="true" /> </authentications> <protocols> <protocol value="" name="lDefault" 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>
web.config Code: <?xml version="1.0" encoding="utf-8"?> <configuration> <appSettings> <add key="Version" value="3.6" /> <add key="Release" value="0065" /> <add key="Build" value="3678" /> <!-- Sysadmin connection value //--> <add key="SysAdminLogin_1" value="sa" /> <add key="SysAdminPassword_1" value="password" /> </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="Off" />
<authorization> <allow users="?" /> </authorization>
[...]
</system.web> <system.webServer> <staticContent> <mimeMap fileExtension=".bak" mimeType="application/x-xip-compressed" /> </staticContent> </system.webServer>
</configuration>
is there something else you might need?
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Change your sqlserver definition in the config.xml so that you allow sysadmin connection Code:<sqlserver address="127.0.0.1" name="localhost" sysadminconnection="false" sysadminconnectionid="1" /> And change the sysadmin credentials in the appSettings section of the web.config file Code:<appSettings> <add key="Version" value="3.6" /> <add key="Release" value="0065" /> <add key="Build" value="3678" /> <!-- Sysadmin connection value //--> <add key="SysAdminLogin_1" value="sa" /> <add key="SysAdminPassword_1" value="password" /> </appSettings> This is fully described in the installation guide.
|
|
Guest |