Hi Everyone,

I am having a really BIG problem over here…

My web site, which is heavily borrowed from, Damon Armstrong, is working great! However, I need to modify it just a little bit.

The site is in C#, (http://stage.rivier.edu), and it is a Web Parts portal, if-you-will. And I want to authenticate against Active Directory, as well as insert the users into the database, so it will remember user’s settings. Right now, I am using the ASPNET.MDF database through VS 2005. Ideally though, I would like to use SQL Server. But, I cannot attach to the database through SQL Server; I get errors.

Anyway, this is KILLING me!!!

I am fairly new to all of this and I need to have this done for, “testing” by April 2nd. I really need some help. I know I sound desperate… But that’s because I am.

Thank you all for any help you can give me. It is GREATLY appreciated, and I only hope I can lend a helping hand in the future.

Cheers,

Dan

Ok, first you did NOT have to spam the board with identical posts to get a reply. This is more annoying then helpful to your cause.

Do you have any version of SQL Server installed that you are trying to attach the MDF to? What version of SQL was the MDF created in?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

I'm sorry dparsons, you are right. I just know that with some boards, people can be round-about, and redirect you to another forum, like: Next time, you'll want to post this in the [fill_in_the_blank] forum. But you're right, I shouldn't have done that and I apologize.

Now, to answer your question. I do have SQL Server 2000 installed, as well as SQL Express. The MDF is actually the MDF file that VS 2005 and SQL Express creates, which is the default: ASPNET.MDF.

Hope that helps, and thanks again!

This would solve the 2000 vs 2005 issue:

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Imar will probably need to correct me (or provide a simpler solution) on this as using Visual Studio to manage my database files is not my forte.

If you have the ability to create a backup of the database, you could use the .BAK file to populate a database in your SQL Server instance but, like I said, I have no experience with this so I do not know if that is even an option.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

You can't restore a SQL 2005 to a 2000 instance.

However, you can use DTS or other methods (like scripting the data) to move the data from the 2005 version to 2000.

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Imar, thanks for clearing that up. I didn't imagine you could but I have never tried so didn't know. ^^

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

FYI: you can't do the reverse either. Both type of .bak files are tied pretty much to their respective versions.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.