Hi, There
I add the PlanetWrox.mdf database to my vs2010 App_Data folder .I check Security tab and i have full control over this folder.But When I try to Open Database( By Double-click on it) I get following message :
Connections To SQL server database files(.mdf) require SQL server 2005 express or SQL server 2008 express to be installed and running on the local computer.
I check in services that my sql server express instance[SQLEXPRESS] is running and check both mdf file( 2005 and 2008).
Really i don't know what i must do.

I don't think this error message comes up if the problem is permissions. But I could be wrong about that.
You will get that error message if the service isn't started or the instance you're trying to connect to isn't running. You'll also get it if you installed a full version of SQL Server 2008 instead of the Express version. Neither of those look like they apply to you.

IN VWD, go to the Tools menu and select Options.... Then locate the Database Tools heading and expand it. Then click on Data Connections.

The value in the box should contain the name of your SQL Server Express instance (SQLEXPRESS). If the name appears to be correct you can try deleteing it and leaving the box blank: this tells VWD to use your default instance, which is handy because you don't need to know the name of the instance in order to use it.

So i check this it's started.

You tried:

1) Restarting VWD?
2) Restarting your PC.

I had this issue and once I'd done 1 of the above options (can't remember which one), it worked.

Yes but still i have that problem.

Can you try the following?

1. Log into your SQL Server using SQL Server Management Studio

2. Create a new query, enter the following command

SELECT @@version

and hit F5 to execute it.

What does it tell you there?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Hi Imar
It tell me following text :
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

Thank's

That's not the Express edition so the error message is correct.

Did you follow the instructions in Chapter 1 on installing VWD and SQL Server Express?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

However, in my services i see that sqlexpress instance is running.
I use this instance for another scenario and its work's fine . Is there any back up of database that i restore it ?
Thanks.

I have another irrelevant question:
Why You and another users have level and activity percentage bar but i have not?
It is really problem for me.
Thanks