tcombre wrote
After days, I finally have the right connection string for sql express.
"Data Source=.\SQLEXPRESS;Initial Catalog=DotNetNuke;Integrated Security=True;"
Also, you should create the database first and make sure the owner is sa...not the default.
I hope this saves someone the days of agony I had.
Yes, it did! Thanks for posting that.
To follow up, here's the applicable sections of web.config for SQL EXPRESS:
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DotNetNuke;Integrated Security=True;" providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express -->
<add key="SiteSqlServer" value="Data Source=.\SQLEXPRESS;Initial Catalog=DotNetNuke;Integrated Security=True" />
<add key="InstallTemplate" value="DotNetNuke.install.config" />
<!-- Alternative Install Templates (included in package)
<add key="InstallTemplate" value="Club.install.config" />
<add key="InstallTemplate" value="Personal.install.config" />
<add key="InstallTemplate" value="SmallBusiness.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="InstallationDate" value="5/27/2006" />
</appSettings>