I am a newbie to ASP.Net MVC and trying out example applications from the books. I created a simple application in MVC 3 and I found MVC using a database to store user information's created under the App_Data folder of the project. I wanted to create and use a separate database other than which I can create using VS. So I created a database using SQL Server 2008 R2 Express under the App_Data folder of my web application and tried to add a new connection to that SQL Database file using .Net Framework Data Provider for SQL Server.
When I browse to the database file and tried to select, I am getting the error "You dont have permission to open this file. Contact the file owner to obtain the permission". I am trying to access the database using SQL Server authentication.
So, I have created a role and given the admin privileges to the database and added a user with that role. But still I am getting the error while trying to add the connection.
I'd like to know how to create an MVC application that stores it database internally inside its project and how to access it.
