Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ...Creating dev env from prod..Creating dev env from prod..
Previous
 
Next
New Post
2/9/2011 11:49 PM
 
Louis

Joined: 1/9/2007
Posts: 57
Vers: 5.1.2 at present, and I'm trying to set up a dev enviroment to test / work through an upgrade.

I've added localhost: :[port #] to the portal alias table,

I've copied the production db to a local version of the SQLExpress DB.

I've modified the web.config to point at the local DB version.

When I click on "Go" button in Dev Espress 2010 (using IIS 7.5 Express) -- I'm not getting the default home page, instead I'm getting put to the install wizard process. 
Since I'm there, I do the first couple "Tests" for files directory permissions and DB.. both come out good.

This tells me the database and IIS  / web pages are working (small YAY there.. cause microsofts new install "STUFF" makes me want to puke) ..

But I must have missed something to have it auto redirect to the install wizard.. any thoughts?
 
New Post
2/10/2011 8:49 AM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253

The install wizard is appearing because it cannot connect to your database. Here are a few questions that may help you identify the problem:

  • How did you "copy the production db to a local version of the SQLExpress DB"?
  • Did you create a backup of the production DB and then a restore of the backup (.bak file)   to local DB? If you only copied the DotNetNuke.mdf database file from the App_Code folder of the production site it is very unlikely that that was being used as the production site's database.
  • Did you create a new database user login on the local DB and grant that login db_owner rights?
  • What do your web.config connection strings look like? - NOTE: when posting to the forum, please use xxxx for userid and password.
  • Are you able to connect to the local database from MS SQL Server Management Studio or other similar tool using SQL authentication and the same credentials for userid and password?
  • In the Install Wizard, did you select SQL Server 2005/2008 rather than SQL Server 2005/2008 EXPRESS. Even when using SQL Express as your database server, you must select SQL Server 2005/2008 and NOT SQL Server Express if you are connecting to the database via SQL authentication and using a userid/username and password in the connection string.
  • Did you copy ALL the folders and files from the production site to local AND reset the filesystem permissions to full control on the root folder and all child folders using the proper ASP.Net worker process account for IIS 7.5? Note that this is most likely NOT "Network Service"
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/10/2011 11:25 AM
 
Louis

Joined: 1/9/2007
Posts: 57
William Severance wrote:

The install wizard is appearing because it cannot connect to your database. Here are a few questions that may help you identify the problem:

  • How did you "copy the production db to a local version of the SQLExpress DB
I used SQL Server Manager Studio  to import the database from the hosting provider to the local machine. 

  • Did you create a backup of the production DB and then a restore of the backup (.bak file)   to local DB? If you only copied the DotNetNuke.mdf database file from the App_Code folder of the production site it is very unlikely that that was being used as the production site's database.
No, import feature in SQL Managment Studio, 

  • Did you create a new database user login on the local DB and grant that login db_owner rights?
Yes, New database on local machine with the exact same database name as in production, same user name, same password, yes, the user is the DB owner as well.

  • What do your web.config connection strings look like? - NOTE: when posting to the forum, please use xxxx for userid and password.
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Database=C4751_DNN;UID=xxx;Password=xxx" providerName="System.Data.SqlClient" />

It echo's exactly how it is in production except the Data Source variable.  To make work on the hosting provider, it also includes the server IP, as well as the port.

  • Are you able to connect to the local database from MS SQL Server Management Studio or other similar tool using SQL authentication and the same credentials for userid and password?
Yes, was able to connect, do selects and even inserts.

  • In the Install Wizard, did you select SQL Server 2005/2008 rather than SQL Server 2005/2008 EXPRESS. Even when using SQL Express as your database server, you must select SQL Server 2005/2008 and NOT SQL Server Express if you are connecting to the database via SQL authentication and using a userid/username and password in the connection string.
Database option yes.  Event did the "test" connection and it gave me : Connection Success

  • Did you copy ALL the folders and files from the production site to local AND reset the filesystem permissions to full control on the root folder and all child folders using the proper ASP.Net worker process account for IIS 7.5? Note that this is most likely NOT "Network Service"
Yes, all files and folders, and when I did the "Test Permissions Summary" page on the DNN wizzard, everything passed.

 
 
New Post
2/10/2011 11:30 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212
you should either restore from backup or use copies of database files from your hoster, otherwise there might be permissions and other settings be missing.
Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
2/10/2011 1:20 PM
 
Louis

Joined: 1/9/2007
Posts: 57
I agree.. the back up and restore process would be more ideal, unfortunately the hosting providers tools for back are broke and I'm unable to retrieve any backup data. I've done the import process in the past and have found that usually has worked faithfully, as I don't do just do data, but the tables in their original format as well.

 Do you think there is something in the importing that caused this problem?
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Creating dev env from prod..Creating dev env from prod..


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