Hi
I have what looks like exactly the same problem. I am running DotNetNuke version 5.1.1 in conjunction with SQL Server 2008 Express and Visual Web Developer 2008 Express Edition. Microsoft seems to cunningly arrange that when Visual Web Developer is first fired up against a user instance of SQL Server (Express only!), it copies and moves SQL Server Express database files behind the scenes. This has cost me many days of investigation! I have tried to change the web.config file to avoid user instances, and to open an explicit database fileset citing C:\DotNetNuke\App_Data\Database.mdf.
In the Modules table of C:\DotNetNuke\App_Data\Database.mdf, I can find Repository Dashboard by not Repository. More curiously, I think the Repository install process has created another database called DotNetNuke which I cannot currently access from SQL Server Management Studio.
The relevant part of my web.config file includes:
connectionStrings> Connection String for SQL Server 2005 Express -->add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=False;AttachDBFilename=c:\DotNetNuke\App_Data\Database.mdf;" providerName="System.Data.SqlClient" /> Connection String for SQL Server 2000/2005-->connectionStrings>appSettings> Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=False;AttachDBFilename=c:\DotNetNuke\App_Data\Database.mdf;" /> Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules-->
My guess is I should try to rename c:\DotNetNuke\App_Data\Database.mdf to DotNetNuke
Any ideas?
Richard
<!--
<
<!--
<add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" />
</
<
<!--
<
<!--
<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>
<