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

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Import .mdf databse file to SQL 2005Import .mdf databse file to SQL 2005
Previous
 
Next
New Post
9/11/2007 7:07 PM
 

Hi,

I'm trying to work in a development scenario set up with VS 2005 & SQL Server 2005 (full) but I'm getting a lot of trouble importing the data base into my full sql engine.

Theres a file called Database.mdf inside the App_Code directory (I've downloaded both: install and source versions), when I try to attach this file to a Database node in SQL Server it says that Database.mdf contains 2 files: Database_2.mdf and Database_2_log.ldf which is untrue, because those files don't actually exist in any of the downloadable packages.

So, I've been unable to import the mdf dabase file into a database of mine and thus, I can't run the solution. I've changed web.config to connect to my SQL Server and it works, but obviously it states: Stored Procedure X is not found because the Dummy database I created for the application is empty.

I even created a log file for the Database.mdf file using the SQL sentence sp_attach_singl_file 'db_name', 'phisical_path' and it creates a log file, but it doesn't work

I haven't found any help information on this issue and I've been fighting with it for some days now.

Any cooments would be welcome.

Thanks.

 
New Post
9/12/2007 6:22 AM
 

The file you are trying to attach is for 2005 Express. It would be better for you to create a new empty database in your SQL server, modify your connection string to match the new location and then just let the installation process run all the SQL scripts to populate the DB.

 
New Post
9/12/2007 2:21 PM
 

I agree with bhopkins on this, I would create a new blank database and then run the install process, it will build the needed tables and stored procedures for your automatically, I personally NEVER use the database.mdf file that is included in DNN for ANY of my projects.

If you need assistance with the setup I have a tutorial on my website http://www.mitchelsellers.com


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
9/12/2007 2:28 PM
 

Thanks for the reply,

The very first thing I did was just that: created a new database in my sql server and changed the connection string in web.config.

Then I ran the solution with VS 2005 and the obvious happened: "could not find stored procedure XXX", the database was empty.

After that, I started searching for a way to import the database found in the App_Data folder into my new and empty database but the result was the previous post: nothing worked.

Maybe I missed something in the installation process, because I haven't seen any scripts to populate the empaty database. Where can I find them?

Thanks in advance.

 

 

 

 
New Post
9/12/2007 3:25 PM
 

Ok, I think I missed an important point as I said before as I didin't know of the installation wizard located at \install\InstallWizard.aspx. I tried previously to run Install.aspx but it prompted an error.

So I think I moved forward a little step. I ran the installation wizard and I've reached the point where the scripts are going to be run to populate the database. I check the connection with the test button and it works. However when I start the populating step I get this messages:

Installing Database - Version 4.4.0...undefined...Success
Installation of Database Complete

Nothing happened within the database, nothing was created. The wizard shows these messages and the "Next" button again. At this point the installation process is stalled...

If I click the Next button it runs the scripts again and the same tng happens, so I cannot move forward.

Something is wrong writing to the database I supose, but the connection was OK and I've given write permissions to the user I created for DNN.

I'm stalled again...

 

 

 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Import .mdf databse file to SQL 2005Import .mdf databse file to SQL 2005


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