Hi!

I search tons about installation in the forum, but can't figure out what's wrong with my web.config file. When I supply my url, http://localhost/MyWebNuke/ I receive,

Installing DotNetNuke

Current Assembly Version: 04.03.04

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

My web.config about the SQLs is like below:

  <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"
   type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
      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-->
  </appSettings>

Im running a local IIS 5.1 with Win XP SP2 (updated), with Framework 2.0, and a SQL Server 2000. Connection to local database, DotNetNuke, is tested with linking an Access 2000 database to it.

Any suggestions will be apreciated

TIA

 

Thanks for your effort to help, but I'm stuck here. I have find the comment, and removed it, so it's ok now, but there must be a problem with my connectionstring. It's easy to connect to the database using Win XPs admin ODBC tools, so I wonder how my connectionstring should be configured. An explation of the tags within the web.config file would maybe solve the problem.

I use SQL Server 2000. In the web.config there are:

1) name="SiteSqlServer"
    Is that correct, or what should be in this field?

2) connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
    I run the a local SQL Server (for test at first) with the local database "DotNetNuke".
    No uid or password is defined.
    Is that correct, or what should be in this field for a local server?

3) providerName="System.Data.SqlClient"
    Is that correct, or what should be in this field?

TIA

i've got the same problem i commented out sql server 2005 express because i'm not using it and i still get the same error this is my web.config connection and app section sample:

  <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=DNN;uid=DNN;pwd=DNN;"
      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=DNN;uid=DNN;pwd=DNN;"/>
    <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-->
  </appSettings>

can anyone help me?