myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

unable to restore database Options · View
Caspar
Posted: Friday, April 23, 2010 3:43:21 PM
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=311
I 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)
elian
Posted: Friday, April 23, 2010 5:24:02 PM

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.

Caspar
Posted: Tuesday, April 27, 2010 9:36:36 AM
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?
elian
Posted: Wednesday, April 28, 2010 8:39:17 AM

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.

Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.