To ssaunders,

Your connection strings look OK.  Am I correct that you have manually created the database and the user/password login and added it to the database logins with db_owner rights? Are you able to connect to the "DotNetNuke" database in SQL Server Management Studio using the same username and password that is in the DNN connection strings (that is, using SQL Server Authentication mode and not Windows Authentication mode)?  Was there any additional information given in the error message besides "cannot connect to the database"?

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner

I hope that someone can help me I'm currently having a lot of trouble setting up on my localhost and have had a few different errors over the last week that I have been at it.
I'm fairly sure the problem is in the database. I have actually got my portal to work but its like me and  my success with  women . Any success I have had is short lived and cannot be replicated in any useful way in a real world environment.
I got the site to work by debugging the default file in vwd2005 when I did this the site installed and ran no problem but when I try and access the site from localhost it gives the following error

DotNetNuke Upgrade Error

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

ERROR: Could not connect to database.

Cannot open database "dotnetnuke" requested by the login. The login failed. Login failed for user 'WS00073\ASPNET'.

I have tried a couple of conn strings this is the one I am currently using with the one I tried previously commented out

<connectionStrings>
    <!-- Connection String for SQL Server 2005 Express -->
    <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;Database=dotnetnuke;" providerName="System.Data.SqlClient" />
    <!--<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;Database=dotnetnuke;" />
    <!--
    <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=;"/>
    -->

I've created a couple of databases
one in SQL Server 2005 using the management studio and that one's in the sql express data directory and I made a copy of that blank database and put it in the App_Data folder I have also created two new user groups in the security tab in the properties for the dnn site folder I have granted modify permission to ASP.NET and NETWORK SERVICES just to be sure.

Because I can get the site to work in vwd2005 I think I must be nearly there, it's a bit frustrating to say the least.

Any help appreciatted, thanks