Here is the connection part of WEB.CONFIG. I am using SQL Server 2000 Enterprise locally with SQL Server authentication. Listed is example database parameters. Should I delete the SQL Server Express 2005 line?
I was able to get DNN3 working very easily about a year ago, and it ran nicely for a while. Something is different with the new DNN4 config that is driving everyone crazy trying to get it to install. Any help would be appreciated.
- My SQL server is (local)
- Database Name: DotNetNuke
- Fake Username: dnnuser
- Fake Password: password
<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=;"/>