Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 17th, 2007, 07:17 AM
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default Converting from SQL server 2005 back to express ed

Hi folks,

I was working on MS sql server 2005 evalution where i have built a number of databases. However, i came to discove that the evalution version has expried before i finished my work. Now i have disinstalled the sql server 2005 and installed the Sql express edition.

My concern here is how can i keep my databases so they can work with sql express edition?

Thank you very much in advance.


Reply With Quote
  #2 (permalink)  
Old February 17th, 2007, 10:41 AM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

This solution is fairly simple. I do the following:

1) Stop the SQL Server service for the Evaluation Edition
2) Copy the databases from the \Data directory to a different directory.
3) Uninstall the Evaluation Edition
4) Install the Express Edition
5) Download, and install, the SQL Server Management Studio for Express Edition (off of the MSDN web site (msdn.microsoft.com/vstudio/express/sql/download)
6) Copy the databases back to the data directory.
7) Within Management Studio, attach the databases you just copied.

You're Done!

Hope this helps...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
Reply With Quote
  #3 (permalink)  
Old February 17th, 2007, 06:15 PM
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you very much for your reply. Your answer worked very well. I only have another problem which i was trying to avoid from the begining but even with your method that i have followed it seems to be so far the result i want get to is not yet solved.

when i used SQL sever standard edition i have made my own tables in exactly the same database that have the membership. it is fine now all that database i have migrated to my sql server express edition. However, when i run the website and i like to log in with my user name and password, i recieve an error page saying that the projects creates automatically another database with the memebership. As a result when i debug and trace the problem i found there are two databases in my project. One that i have migrated and the other created automaticall by sql server express edition when i use the membership log in tool.

I was trying to copy my tables to the new database that have the membership but i couldn't. Also i don't understand why the system does not accept the membership database that is already in place.

Can you please hepl me?

Reply With Quote
  #4 (permalink)  
Old February 17th, 2007, 08:19 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

I'm confused. What do you mean "two databases in my project"? What project? Are the "membership" tables ones that you created? If so, i would try recreating (deleting and creating again) in the database you just attached. Also, it might be that you need to look at the credentials.

I am not too up on membership login tool, but I'll look into that and see what I can find. Also, you might be able to find some information on that in BOL

Scott

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
Reply With Quote
  #5 (permalink)  
Old February 18th, 2007, 04:05 AM
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Let me simplify it if i can. First time i started my project and wanted a membership database, i had to create a database and called it MCUK.mdf. and then follow the procedures located in file %WINDOWS%\Microsoft.NET\Framework\v2.0.50727 and run the file aspnet_regslq.exe so i can set up the membership database (this procedure is done because i was using SQL server 2005 Standard edition). However, as you may know, this is done automatically with sql server express edition. All you need to do is go to the Website configuration page and from there you can set the membership.

When i created my MCUK database membership i have added to it other tables that are related to my project. However when i migrated back to SQL server express edition, the tables i have created work fine but the membership on this database does not work. How's that happened? When i run my project and try to enter my username and password, an error occurs and says:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Cannot create file 'C:\DOCUMENTS AND SETTINGS\USER\MY DOCUMENTS\VISUAL STUDIO 2005\WEBSITES\MOROCCANCOMMUNITY1\APP_DATA\ASPNETDB _TMP.MDF' because it already exists. Change the file path or the file name, and retry the operation.
Creating the ASPNETDB_88bc58619c3d41ada0ce49f93f9fff07 database...
.

So far, i was only talking about MCUK database, but after this error occurs, the system attempts to set up another database called ASPNETDB_TMP.MDF.

The error says that the files are already exists. that's right because the files are in MCUK database. But why does the system need to create the same file in ASPNETDB_TMP.MDF wheras they already exist?

So that's what exactly happens and i hope this will help you define the problem.

Just to be clear of my aim: i want to keep those tables that i have created for my project (because they are many with loads of data on them) with the memebership tables in one database.

Thank you for your time.

Reply With Quote
  #6 (permalink)  
Old February 19th, 2007, 06:54 AM
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi There,

Can anyone help with my issue please.

Thank you for your time.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remoting and SQL Server 2005 Express Bob Bedell C# 2005 15 January 3rd, 2008 01:52 AM
SQL SERVER 2005 STANDARD (not express) proslambano BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 8 January 8th, 2007 08:55 PM
ASP.Net 2.0 Visual Web Developer 2005 Express Ed cpanson BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 2 February 26th, 2006 12:36 PM
SQL Server 2005 Express Problem asped_man BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 3 November 29th, 2005 05:07 AM



All times are GMT -4. The time now is 01:57 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.