Hi !

I always receive:

Error Installing DotNetNuke

Current Assembly Version: 04.03.05

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

I give up. Have to look for another freeware portal application. I have spent 3-4 days with this problem but it seems that noone can help me with this or have had the same problem. I have a new installation of XP Pro + VS2005 Pro + SQL Server 2005 Express.

I am using all default settings in the dnn packages.

I have tried the installation package and source package but always receive the same result.

Rgds/Gunnar Snellman

Hi Robert !

Yes I have.

----

  <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=;"/>
    -->
    <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="PersistentCookieTimeout" value="0" /><!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->
  </appSettings>

----

I have not manually created a database

Rgds/Gunnar

Gunnar,

Yes, you do need to manually create the database.

When I configure my connections (since I am using SQL Server 2k/2k5) it looks like this*:

<code>

  <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=SomeUserName;pwd=ThatUsersPassword;"
      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=SomeUserName;pwd=ThatUsersPassword;"/>

</code>

Note how I change the comments to comment out SQL Express and then I configure the SQL Connection info.  If you are using SQL Express then you would not do this.

Best Regards,

Robert J Collins | Co-Founder & President

Netlogic Corporation