Take the 2-minute tour ×
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. It's 100% free, no registration required.

(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 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.

1  
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 at 18:03
add comment

Browse other questions tagged or ask your own question.