Hi All,

I'm trying to install DNN4 however I kept getting database error. I've SQL server 2005, XP, IIS6.0..

I followed every step in the installation document. Please help me,I've a deadline coming soon, and I can't figure this out.

Error Installing DotNetNuke

Current Assembly Version: 04.03.04

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

Here is my web.config file;

<connectionStrings>

<!-- Connection String for SQL Server 2005 Express

providerName="System.Data.SqlClient" />-->

<!-- Connection String for SQL Server 2000/2005-->

<add name="SiteSqlServer" connectionString="Server={local};Database=DotNetNuke4;uid=xx;pwd=xx;" 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=DotNetNuke4;uid=xx;pwd=xx" />

<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="InstallationDate" value="8/22/2006" />

</appSettings>

Thanks..