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 ...Upgrade problems from 3.x to 4.5.3 on sql server 2000Upgrade problems from 3.x to 4.5.3 on sql server 2000
Previous
 
Next
New Post
6/22/2007 3:22 PM
 
Mike Klein


Joined: 12/20/2004
Posts: 140

I am trying to upgrade an old website.  I have both sql2000 and sql2005 express version.  This is on an XP box.

I downloaded it to my local machine and got it running perfectly.  Now I am trying to upgrade it to the newest version.  I have changed my config file including the sql2000 settings and the 2 machine keys.

I go through the installation and I end up with this error

An attempt to attach an auto-named database for file C:\webs\cchiv33\App_Data\Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

There is no Database.mdf in the directory shown above.  Should there be ?  Shouldn't an upgrade from 2000 to 2000 be easier then this ?

Did I do anything wrong here:

Select Database:
 

Server: Enter the Name or IP Address of the computer where the Database is located. (if using Oracle enter the Data Source (SID))
Database: Enter the Database name
Integrated Security: Check this if you are using SQL Server's Integrated Security, which means you will be using your Windows account to access SQL Server. If you are using SQL Server Express then you will most likely need to check this option. If you have been given a UserId/Password to access your Database, leave this unchecked, and provide the UserId/Password combination.
User ID: Enter the UserID for the Database
Password: Enter the Password for the Database
Run as db Owner: Check this if you are running the database as Database Owner - if left unchecked you will be running as the User ID specified
Object Qualifier: Enter an optional "prefix" to use for all your database objects - this helps ensure that there are no object name clashes.

 
New Post
6/22/2007 3:59 PM
 
Mike Klein


Joined: 12/20/2004
Posts: 140

OK.  I commented out the sql2k5 express stuff in the config file.

I am now getting this error:

Installing Database - Version 4.4.0...Upgrading Database to Version ERROR: See C:\webs\cchiv33\Providers\DataProviders\SqlDataProvider\04.04.00.log for more information...FAILURE 400 - Conversion from string "ERROR: See C:webscchiv33Provider" to type 'Integer' is not valid.

After trying to find the answer to this on these forums I can tell you for sure, there is NO log.  None.  I have tried the installation as sql user and the sql dbo with no luck.  There seem to be several people that are having this problem but no one with solutions.

Anyone ?
 
New Post
6/24/2007 1:26 PM
 
Frederick M. Kist

www.kistenterprises.com
Joined: 6/21/2005
Posts: 222

Maybe try setting up your new web.config manually and using the "AUTO" function of the installer. It seems to work a lot better for me.

Good luck,

Mike

Kist Enterprises
www.kistenterprises.com
 
New Post
6/25/2007 1:46 PM
 
Mike Klein


Joined: 12/20/2004
Posts: 140

Mike,

I was going to attempt to try your way of installing the upgrade.  I restored my old 3.x database but left all the files in the dnn directory the same except for the web.config file.  I deleted the current web.config and brought over the renamed the release.config to web.config and manually filled in my sql server 2k credentials (commented out the sql express 2k5 statements) and copied the machine keys.  I then browsed to it and the installation ran, asking me no questions.  When it finished it was up and working fine.

I am not sure why this worked, over the upgrade dialogue boxes so I can only guess.  The only thing I did different is to comment out both sql2k5 express settings and THEN browse to the site for the upgrade

Comment this 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" /> -->

Uncomment and fill in:

"Server=(local);Database=databasename;uid=databaseuser;pwd=;"

Obviously you would do the opposite if you are using sql2k5 express edition.  I really hope this helps others with this proble.  Please post if it does.  I am going to post this answer to the other threads on the same topic
 
New Post
6/25/2007 11:58 PM
 
Frederick M. Kist

www.kistenterprises.com
Joined: 6/21/2005
Posts: 222

Actually this is the way I do all of my installations - whether running a SQL Express database or not I use the SQL2000/2005 connection string. Instead of commenting out I just delete the Express string altogether. Bypassing the Install Wizard seems to solve any installation errors that I have had.

Glad things worked out for you - spread the wealth of knowledge learned.

Mike

Kist Enterprises
www.kistenterprises.com
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade problems from 3.x to 4.5.3 on sql server 2000Upgrade problems from 3.x to 4.5.3 on sql server 2000


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