Register | Log In
Download Contact
Resources > Forums
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...Restoring and Connecting Locally to SQL ExpressRestoring and Connecting Locally to SQL Express
Previous
 
Next
New Post
6/13/2012 2:10 PM
 
User is offline Jeremy Tyler


www.conhecendodeus.com.br
Joined: 12/31/2009
Posts: 22

I am having some trouble connecting to my database in SQL 2008 R2 Express to activate a site on my local machine. I have done this several times in the past, but I am having issues on this new computer.

The files have been downloaded, the database backed up, downloaded, then restored in SQL 2008 R2 Express with the login user added. However, I am not able to restore the website locally.

I was able to create a new instance of DNN, but I cannot connect the older instance to the database that I have restored. I did add the portal alias "localhost" to the database. Gave DefaultAppPool full permissions to the folder. Changed my web.config file to...

<add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=mydatabase;User ID=myuser;Password=mypassword" providerName="System.Data.SqlClient" />

It seems as though the IIS is not configured correctly. The DefaultAppPool has been selected in IIS 7.5.

Then I got a machine key error.  I have tried with WebMatrix and without it. Here is the error below.  

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS.

Source Error: 

Line 99: </system.webServer>Line 100: <system.web>Line 101: <machineKey validationKey="F96644F22F506793CDA1101F8D81B887F338825B" decryptionKey="9BA9D4FC3F355F3EFD902F17B2B91355EF0094AA48FE4715" decryption="3DES" validation="SHA1" />Line 102: <!-- HttpModules for Common Functionality -->Line 103: <httpModules>


Source File: C:\inetpub\wwwroot\maranata\web.config    Line: 101


Version Information: Microsoft .NET Framework Version:2.0.50727.5456; ASP.NET Version:2.0.50727.5456

 

Any help would be appreciated!

Jeremy 
 
New Post
6/13/2012 7:04 PM
 
User is offline Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 36759
please make sure that your IIS website points to the DNN root folder and that there is NO web.config file in any sub directory
Cheers from Germany,
Sebastian Leupold (DotNetNuke MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals
 
New Post
6/14/2012 7:34 AM
 
User is offline Mark Eckeard


Joined: 1/20/2004
Posts: 773
Like Sebastion said, either IIS doesn't have an entry for the website or there are multiple web.config files within DNN and that's causing the issue. Check both and let us know if it works.

Mark
 
New Post
6/14/2012 11:42 AM
 
User is offline Jeremy Tyler


www.conhecendodeus.com.br
Joined: 12/31/2009
Posts: 22
Thanks Sebastion and Mark for the help. I will file this so as not to make the same mistake again. I had tried this dozens of times and though I ran into the machinekey problem once or twice, that was not my biggest problem. A simple rechecking (with your help) got me past that issue.

My problem was that I constantly kept getting the install wizard, or an index.html file though default.aspx was set. I tried different browsers and at first it gave me an error. I restarted the browser and IIS and all of a sudden the site appeared on a different browser. Come to find out I had the right connection strings and everything, but I had not deleted the cache in my browser. Everything else seemed to be set correctly. Though I had read many posts, nothing that I read mentioned the cache which was probably there from an initial trial run with incorrect settings. Though I deleted folders, database, and everything, the portal alias kept pulling up the cache.

Well, I am glad that is over! Maybe this post will help someone else.
 
 Page 1 of 1
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...Restoring and Connecting Locally to SQL ExpressRestoring and Connecting Locally to SQL Express


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Start Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP