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