Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade from 4.5.5 to 4.8... Okay IUpgrade from 4.5.5 to 4.8... Okay I'm pulling my hair out now!
Previous
 
Next
New Post
2/16/2008 7:03 PM
 

Okay, I thought I found a great resource (it's still good just not complete) for upgrading to DNN 4.8. I have followed the instructions line by line, all four pages and everything went well until I tried to hit the ..../Install/Install.aspx file to initialize the upgrade.

I get an error.... of course...

Error Installing DotNetNuke
Current Assembly Version: 04.08.00
ERROR: Could not connect to database specified in connectionString for SqlDataProvider

So in my research I read I needed to comment out the "sqlexpress" comment, but it didn't work. Plus it's in the old web.config file anyway, and it worked there.  So here is what I have, can anyone tell me what I am missing?

 

</configSections>
 <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="Data Source=SQLB16.WEBCONTROLCENTER.COM;Database=DotNetNuke;uid=(XXXXXXX);pwd=(XXXXXXXX);"
      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="Data Source=SQLB16.WEBCONTROLCENTER.COM;Database=DotNetNuke;uid=(XXXXXXX);pwd=(XXXXXXXX);"/>
    -->

 

Am I that dumb and can't see this or is looking at it now for 8 hours causing the problem? Any bit of help or advice would be great!

 


Mike DeBaise President/CEO Trial by Fire Web Design, LLC. URL: www.TBFWD.com Email: President@TrialByFireDesigns.com
 
New Post
2/16/2008 8:00 PM
 

Michael,
I see only two misplaced end comment markers (-->) but no begin comment markers and am surprised you did not get some sort of parse error for an invalid web.config.  The following should be correct: (note yellow highlighted changes):

</configSections>
 <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="Data Source=SQLB16.WEBCONTROLCENTER.COM;Database=DotNetNuke;uid=(XXXXXXX);pwd=(XXXXXXXX);"
      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="Data Source=SQLB16.WEBCONTROLCENTER.COM;Database=DotNetNuke;uid=(XXXXXXX);pwd=(XXXXXXXX);"/>
     
  

Your comment about this being an old web.config worries me - although you may only be saying that you used the connection strings from the old web.config. Be sure that you are using the new release.config (renamed to web.config) from the 4.8 installation and that you have transferred all of the importand customizations from the old web.config - most importantly (after the connection strings) the MachineKeys, object Qualifier and databaseOwner values.


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
2/16/2008 8:13 PM
 

well I made those changes and now I'm getting a Runtime Error..... I give up.... I did EXACTLY as I was supposed to and it still didn't work. Thank for your help though.

 

 


Mike DeBaise President/CEO Trial by Fire Web Design, LLC. URL: www.TBFWD.com Email: President@TrialByFireDesigns.com
 
New Post
2/17/2008 12:31 PM
 

Please post the ENTIRE runtime error you are receiving and indicate when/upon what user action it appears.


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
2/17/2008 1:50 PM
 

Michael DeBaise wrote

well I made those changes and now I'm getting a Runtime Error..... I give up.... I did EXACTLY as I was supposed to and it still didn't work. Thank for your help though.

  

It's critical that you do it right the FIRST time.  Once you make a mistake, it is best to start all over from the beginning.  Otherwise, it does not matter how well you re-follow the directions, it won't fix the problems you've already created.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade from 4.5.5 to 4.8... Okay IUpgrade from 4.5.5 to 4.8... Okay I'm pulling my hair out now!


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out