Hi Guys,

Have been trying to get a website retored for a while now and am tearing my hair out .....

A server went down however i recovered the website files (inetpub source folder) and the dnn database.mdf. I pointed to the correct folder in IIS and then started the webpage and went to it for install. The install process begins and i get to the database install and point it to the correct one and it begins install. However after about 97 "undefined...Success" it hangs!

Anyone have any suggestion that i could follow - ive tried a lot of different option etc like resetting the cache use IE9 etc however I am now stuck bigtime

Anyone help me out?

thanks a lot,

Ger.

Hey Cathal,

thanks for the reply - at least now I know the issue is in web.config, however i am still stuck without knowing what to do. Apologies for being such a noob.

So this is where i am at now:

I followed this thread to create a udl - http://www.dnnsoftware.com/forums/forumid/107/threadid/496677/scope/posts/threadpage/2

the udl comes gives: 

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DotNetNuke;Data Source=MMRRCSERVER\SQLEXPRESS

So ive changed my web.config file from this:

<connectionStrings>

<!-- Connection String for SQL Server 2005/2008 Express -->

    <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

    <!-- Connection String for SQL Server 2005/2008

<add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" /> 

    --></connectionStrings><appSettings>

    <!-- Connection String for SQL Server 2005/2008 Express - kept for backwards compatability - legacy modules   -->

    <add key="SiteSqlServer" value="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" />

    <!-- Connection String for SQL Server 2005/2008 - kept for backwards compatability - legacy modules

    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>

    -->

To this:

<!-- Connection String for SQL Server 2005/2008 Express -->

    <add name="SiteSqlServer" connectionString="Data Source=MMRRCSERVER\SQLEXPRESS;initial catalog=DotNetNuke;Integrated Security=SSPI;User Instance=True" providerName="System.Data.SqlClient" />

    <!-- Connection String for SQL Server 2005/2008

    <add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" /> 

    -->

  </connectionStrings>

  <appSettings>

    <!-- Connection String for SQL Server 2005/2008 Express - kept for backwards compatability - legacy modules   -->

    <add key="SiteSqlServer" value="Data Source=MMRRCSERVER\SQLEXPRESS;Initial Catalog=DotNetNuke;Integrated Security=SSPI;User Instance=True" />

    <!-- Connection String for SQL Server 2005/2008 - kept for backwards compatability - legacy modules

    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>

    -->

Do I have this correct?

If i reload the webpage i still get to the install page.....so still something wrong here, is there anyway to figure out what the issue is? ie i do not get any warnings errors etc - 

thanks again for any help you can give me,

cheers,

Ger.

Hi Richard,

Recover files seem correct - ie database is 30mb in size as last modified date is when i last updated website etc.

I have tried to keep to a pure recovery however i did not setup the original server/website and have had some issues restoring as pure - the database itself was version 706 (SQL server 2012) so i had to export scripts and import them again in 2008 to get it as 655. Also wasn't sure where the database.mdf file should be kept physically - but guessed it should be within the App_data folder.

Everything else i have kept as the same (as far as i know). However on starting website i get an error relating to web.config string "Unrecognized attribute 'requestValidationMode'. Note that attribute names are case-sensitive." i have removed the (requestValidationMode="2.0") from my config file

Do you think either of these have any repercussions? ie are they the cause of my failure

Thanks again,

Ger.