We have a Win2k3 R2 Std Server, SQL 2005 Server Express and Management Studio Express.
We have created DB=dnnDB, and using SQL Server Authentication with user=dnnUser, password=dnnUserPassword.

Can anyone please tell me exactly what we should have in our web.config file for ...
   • connectionString="  " in the <connectionStrings> section and
   • value=" " for the key="SiteSqlServer" in the <appSettings> section and
   • any other required changes we might be over looking
... in order to make the install work?

This is our first attempt at SQL Server Express and we have not been able to find any usefull references out there that will help us with this. Any help would be greatly appreciated!!!

(And if anyone knows where this may already be documented please forward us that reference! )

Thank you.

OK, so here is what I have ...

  <connectionStrings>
    <!-- Connection String for SQL Server 2005 Express -->
    <add
     name="SiteSqlServer"
     connectionString="Data Source=.\SQLEXPRESS;Initial      Catalog=dnnDB;uid=dnnUser;pwd=dnnUserPassword;"
 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>

and

  <appSettings>
    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->
    <add key="SiteSqlServer" value="Data Source=.\SQLEXPRESS;Initial Catalog=dnnDB;uid=dnnUser;pwd=dnnUserPassword;"/>

And when I run open the browser to the site I now get the following error...

What am I doing wrong/missing here?