Hi,
I've been running DotNetNuke using the SQL Express option, however yesterday I decided (not knowing the implications) to attach the database.mdf file to SQL Server 2008.
As soon as I did this, I got the installation page, which obviously indicates it isn't connecting to the database correctly.
I then detached the file, however this doesn't solve the problem - it's obviously done something which is disallowing DNN to connect to the database through either method.
So, I've reattached the database, all the data is still there (I had a look through some tables), I just need to work out how to connect the database through SQL Server 2008.
Quick Details
Root Directory: http://localhost/
Computer Name: Doherty
Username and Password: I never gave the database any username or password when I attached it. This should be left blank then yes? Or Windows Authentication?
Database Name: Gave it the name 'ConquestWebsite' inside SQL Server 2008
Database File: App_Data/database.mdf
OK, So here are the connection strings I have:
<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=DOHERTY;Database=ConquestWebsite;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>
And Legacy Connection:
<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="DOHERTY;Database=ConquestWebsite;Integrated Security=True"/>
</appSettings>
Can anyone please help me, or point me in the right direction with an article or something. This is really frustrating knowing that my whole website is there but I can't access it...