Please can somebody help me out here!

I am executing a clean install of DNN 4.03.07 via manual install as opposed to using the starter-kits installers, and always get the following confusing error message:

DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

Unable to open the physical file "C:\Inetpub\wwwroot\dotnetnuke\Website\App_Data\Database.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\dotnetnuke\Website\App_Data\Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.


I am not upgrading but making a clean installation. My resources are as follows

An HP/Compaq nw8240 mobile workstation
xp pro(sp2)
IIS 5
sqlserverExpress 2005
I also have VS.Net2005 installed on the machine meaning that my wwwroot folder is shared for hosting ASP.Net pages
Also I have placed the dotNetNuke source folder inside wwwroot and am accessing it from a browser as a virtual directory which I have called dnn.

I have created web.config and seen to it that all the parameters listed out on the howto manuals and books are in place.
I have attached the APP_DATA/database.mdf file using ms SQL server Management studio Express.
Seen to it that the database_log.ldf file was duely created.
Given full file(permission) control to the administrator/user under whose Windows authentication login I am connecting the SQLserverExpress 2005
Made sure that this user called dnnuser has role as dbowner and maps to {servername}\Administrator also is registered via ms SQL server Management studio Express as the default owner of the database.
Yet I still keep getting the frustrating error messages above.

Below are the relevant parts of my web.config file which I haven't needed to change anything in since all the manuals indicate that those values would universally map to the relevant destinations, automatically(Is this wrong?)




<connectionStrings>
    <!-- Connection String for SQL Server 2005 Express -->
    <add
      name="SiteSqlServer"
      connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
      providerName="System.Data.SqlClient" />
    <!-- Connection String for SQL Server 2000/2005
    <add
      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
      providerName="System.Data.SqlClient" />
   -->
  </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=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>
    -->
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false"/>
    <add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
    <add key="RemoveAngleBrackets" value="false" /><!--optionally strip angle brackets on public login and registration screens-->
    <add key="PersistentCookieTimeout" value="0" /><!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->
  </appSettings>




Please can somebody help me out on this. Thanks in advance

Thanks very much imagemaker. I did as you suggested and received the following reaction:

DotNetNuke Upgrade Error

The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.

Please also note the following :-
The database I attached is the database.mdf file which came with the source code and was placed in App_data folder. So I did not create the Db but made use of the .mdf file in the distribution.
After ataching it, it was listed in the databases tree in Management studio as Database.MDF.

so my new connection string and 'app settings' are as follows:

<connectionStrings>
    <!-- Connection String for SQL Server 2005 Express
    <add
      name="SiteSqlServer"
      connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
      providerName="System.Data.SqlClient" /> -->
    <!-- Connection String for SQL Server 2000/2005 -->
    <add
      name="SiteSqlServer"
      connectionString="Server=.\SQLExpress;Database=Database.mdf;uid=dnnuser;pwd=obyno123;"
      providerName="System.Data.SqlClient" />
  
  </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=True;AttachDBFilename=|DataDirectory|Database.mdf;"/> -->
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
    <add key="SiteSqlServer" value="Server=.\SQLExpress;Database=Database.mdf;uid=dnnuser;pwd=obyno123;"/>
   
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false"/>
    <add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
    <add key="RemoveAngleBrackets" value="false" /><!--optionally strip angle brackets on public login and registration screens-->
    <add key="PersistentCookieTimeout" value="0" /><!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->
  </appSettings>


I hope all thses make meaning to you. Thanks a bunch.

If you continue to have problems, try either one of these two methods and tell me where you get stuck

Setting-up the Environment (using IIS)

Setting-up the Environment (without IIS)

---

Michael Washington
http://ADefWebserver.com

A Free Open Source DotNetNuke Help Desk Module