I have an installtion of 4.0.2 working under sql2000 on one machine. I backed up the database.
I installed 4.0.2 on another machine. On this machine I have SQLExpress. I've set up config to point to SQLExpress.
I created the mdf in c:\dnn402\website\app_data.
I then restored my SQL2000 db into the new DNN402.mdf.
When I attempt to start DNN I get ...
Error Installing DotNetNuke
Current Assembly Version: 04.00.02
ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: Unable to open the physical file "C:\DNN402\WebSite\App_Data\DNN402.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
The appropriate web.config settings are ...
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<add name="DotNetNuke" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|DNN402.mdf;" providerName="System.Data.SqlClient" />
<!-- Connection String for SQL Server 2000/2005
<add name="DotNetNuke" connectionString="Server=(local);Database=DNN402;uid=DotNetPortalUser;pwd=dnpu;" providerName="System.Data.SqlClient" />
-->
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="DotNetNuke" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|DNN402.mdf;" />
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
<add key="DotNetNuke" value="Server=(local);Database=DNN402;uid=DotNetPortalUser;pwd=dnpu;" />
-->
Thanks 