I am getting a "failed to generate a user instance of sql server due to a failure in start the process for the user instance" error in visual studio. I get the error when I try to connect to an .mdf file in the app_data folder of an asp.net mvc project.
Within this same project ( same login ) I can connect to a database in the sqlexpress sql server. Also, when I login as administrator I can connect to the same .MDF file I am having the problem with in my user login. In sql mgmt studio, I went
to server roles and created a login for the windows user that has this problem with the .MDF file.
What could the problem be with this .MDF file and my user account?
thanks,
View Complete Post