For over a week i have been trying to install dotnetnuke, but i can`t figure it out. I am getting an error message of can`t connect to database, and this is really frustrating since the connection string is correct.

I bet someone with a little better knowledge than myself could figure this out in i matter of minuts, maybe even seconds. I someone would be so kind as to help me solve this problem, and provide me an answer of what i did wrong, i will reward that person with US 50.

Contact me here or via email at morten.myhre@vekstfokus.no
or skype at username nyttfirma

Thank you, and i hope someone takes the time to help me out. Payment prefferably to Ewallet such as paypal upon DNN up and working.

Copy of connection string from web config file. Password XXXX`out.

<!-- 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="sql01.fastname.no;Database=krching;uid=krching;pwd=XXXXXXX;"
      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=;uid=;pwd=;"/>
    -->

Now the code looks like this, and i get a runtime error instead.

(<!-- 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="sql01.fastname.no;Database=krching;uid=krching;pwd=afce54e6;"
      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=sql01.fastname.no;Database=krching;uid=krching;pwd=afce54e6;"/>
  
    <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"/>

Try the settings below.

Make sure that you do not have duplicate <connectionStrings> and <appSettings>

Hope it helps

Tony Stallan

  <connectionStrings>
    <add
      name="SiteSqlServer"
      connectionString="sql01.fastname.no;Database=krching;uid=krching;pwd=afce54e6;"
      providerName="System.Data.SqlClient" /> 
  </connectionStrings>
  <appSettings>
    <add key="SiteSqlServer" value="Server=sql01.fastname.no;Database=krching;uid=krching;pwd=afce54e6;"/>
    <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>