Hello,

This is my first time here and I hope someone can help me to get this product installed.

First, I am using MS SQL SERVER 2005 EXPRESS and I have a total of about 4 hrs experience with it.  I am also using the Microsoft SQL Server 2005 Express Edition management tool.  I have worked with SQL enterprise ed. at work but, not alot.  Just doing installs and we generally use the SQL security.  The SQL server is on the local host.

When setting up the security for this project, I used Windows authentication mode and created a user on my server.  I feel I set the appropriate rights as described in the DOTNETNUKE documentation.

When editing the web.config, I am unsure if I have the settings correct settings.  Here is what I have:

 <appSettings>
  <add key="SiteSqlServer" value="Server=(local);Database=prooffroad2;uid=saadmin;pwd=XXXXXX;" />
  <add key="MachineValidationKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902" />
  <add key="MachineDecryptionKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902F8D923AC" />
  <add key="MachineValidationMode" value="SHA1" />
  <add key="InstallTemplate" value="DotNetNuke.install.resources" />
  <add key="AutoUpgrade" value="true" />
  <add key="UseDnnConfig" value="true" />
  <add key="InstallMemberRole" value="true"/><!--optionally install the MemberRole scripts -->
  <add key="ShowMissingKeys" value="false" /><!-- Show missing translation keys (for development use) -->
  <add key="EnableWebFarmSupport" value="false" /><!--Set to true to enable web farm suppot.  See Web Farm Support documentation for additional configuration steps.-->
  <add key="EnableCachePersistence" value="false" /><!--Some cached items can persist an app recycle by serializing the object to disk. Set to "true" to enable this performance enhancement.-->
 </appSettings>

Here is the error returned by the browser:

Error Installing DotNetNuke

Current Assembly Version: 03.02.02

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

I have looked in the event logs and have'nt noticed anything significant  Any suggestions are welcomed.  I feel this is a simple database connection error.

Thanks, Kenny