Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

(I am very familiar with MySQL but not SQL Server).

On my dev machine is installed:

  • SQL Server Express 2008 (Windows Authentication)
  • SQL Server Management Studio
  • Visual Studio 2010 (with ASP .NET MVC 3)

The database that was created using the studio now needs to be added to a MVC project.

Inside VS2010 I selected the 'Entity Data Model Wizard' and am able to browse for my database file. Once the database file is selected I get a 'You don't have permission to open this file' error message.

Is Visual Studio trying to use another user type other than Window authentication?
How do I give permission to that user?

share|improve this question

closed as off-topic by Max Vernon, Paul White, Mark Storey-Smith, Marian, Michael - sqlbot Jan 17 '14 at 3:50

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Paul White, Mark Storey-Smith
If this question can be reworded to fit the rules in the help center, please edit the question.

Are you attempting to select an .mdf file? Is it still in use by SQL Server? That might throw a permission denied error message. – Max Vernon Nov 5 '13 at 23:45
I was trying to select a MDF file (created by Visual Studio). The DBAs at work setup permission on the server and now I can access the files. – John M Jan 15 '14 at 18:03