In the "Step by Step" section for Chapter 18 - Using the ADO.NET Entity Framework. When I click on OK in Step #15, I get an error saying that the MDF file is version 655. This server supports version 612 and earlier.

How can I get a version of the file that will work. I have Visual Web Developer 2010 Express.

Thank You

All of the database files were created using SQL Server 2008 Express. You can download a free copy from - http://www.microsoft.com/express/Database/.

Regards,


Toi Wright

Thanks for the info Toi!

Toi,

I still need some help. I have tried SQL Server 2008 Express both with and without the R2. I keep getting this message:

Connections to SQL Server database files require Sql Server 2005 Express or 2008 Express to be installed and running.

I am on a notebook with:
Windows 7 Ultimate
Visual Studio 2010 Ultimate
Microsoft Visual Web Developer 2010 Express
SQL Server 2008 Express
- I downloaded SQL Server from the Express web page, but when
I go to "about", it says nothing about being an Express version, is that normal?

I have tried every combination I can think of over the last 5 or 6 days, and simply cannot add either your MDF file or a database I create on my own to my projects. Any idea what I am doing wrong?

Thank you again for your time.

- Richard M. Garber

Are you sure that SQL Server is running? To check, follow these steps:

1. Right-click the task bar and select Start Task Manager.
2. Click on the Services tab.
3. Look for MSSQL $SQLEXPRESS and make sure that it is not stopped.
4. If it is stopped, right-click it and select Start Service.

Regards,


Toi B Wright

Toi,

I have verified that the service is running. The service is listed as
SQL Server (SQLEXPRESS)

This time I installed sql server 2008 R2 express with all the default settings.

Now, when I attempt to add a sql data source in visual web developer, I am getting:

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

So it sounds to me like visual web recognized that I do in fact have SQL installed and running as a process on my machine. What does it mean by "User instance"?


Believe it or not I got it working. I followed the advice on
http://blog.krisvandermast.com/Faile...lBeClosed.aspx

After my new install, I had to make sure the process was started with LocalService, which it wasn't, then I had to manually delete a folder
in my user's appdata called sqlserverexpress, which apparently was holding some incorrect data from previous installs.
I believe that the installer should handle this for the end user.

Now I have added your recipes.mdf file to my project and can continue with the lesson!!

BTW Toi, is there a quick way to determine a correct connection string, does Visual Studio have a way to find it?

Thanks again!

- Richard

Richard,

Have you installed the SQL Server Management Studio, http://www.microsoft.com/downloads/d...isplaylang=en? It is free and it will allow you to manage your SQL Server instance. From your error message it sounds like you now have a rights issue. You can use SQL Server Management Studio to view who has rights. Also, you may want to view your event log to see more detailed error information.

I hope this helps,


Toi B Wright

An MDF file is an Alcohol 120 file. I could be wrong, but I think Daemon Tools will open it up. If not, just rename it to an .iso and see if that works. Or change the .mds file to that. I can't remember which one is the actual disk image and which is the media descriptor file. It's one or the other, whichever one is bigger.

_________

SEO services | PSD to HTML

I've never heard of Daemon Tools, what do you like about it. For the most part I've stuck to SQL Server Management Studio just because there are so many people who use SSMS and are familiar with it. Support has always been a big deal for me.

__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.