Attempt to attach an auto-named database for .mdf file failed

Question

I am currently building a Web Application Project in Visual Studio 2010 and, until recently, have not needed to use the scaffolded code for Memberships, Users and Roles etc that are stored in the ASPNETDB.mdf database file. I have been running the project on the Visual Studio Web Server, IIS Express (from Visual studio) and also IIS7.5 without a problem.

However, I now need to incorporate User accounts and when I use the scaffolded code to log in, I get a server error stating:

An attempt to attach an auto-named database for file C:\Users\User\Documents\COMP6059\PomumV2\PomumV2\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

This error only occurs when I am using either the IIS Express or IIS7.5 web server. The Visual Studio Web Server works fine.

I have followed instructions from http://support.microsoft.com/?kbid=2002980 to no avail.

Below is my connection string for the database:

<add name="ApplicationServices"
     connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
     providerName="System.Data.SqlClient" />

The error occurs on the following line of the AccountController.cs file (which is auto-generated)

...  if (Membership.ValidateUser(model.UserName, model.Password)) { ...

I did read somewhere that I might need to move the database into SQL Server Management Studio and then attach visual studio via that, but I was unable to log into the database.

I want this to be able to run on IIS7.5. Does anyone have any ideas on how to solve this issue?

Solution 1

This is potentially an issue with the account you are running IIS under not having access to that file.

Assign full permissions to that folder for the Network Service account.

You can temporarily try 'everyone' and see if it resolves the issue, and work backwards from there.

Also ensure its not in use by the other web server (process explorer/sysinternals can help show you that)

Solution 2

check that your folder is not read-only. Works for me

Comments

[Mabbage]

The groups Everyone and NETWORK SERVICE have full control over the App_Data directory but am still getting the same thing. Fairly certain its not being used by any other web server. Got hold of process explorer, but not sure what I'm looking for.

[Adam Tuliper]

search for the db name in process explorer and if its in use it will show the process that has it open. it could be open in Visual studio, the VS web server could still be holding on, etc.

[Mabbage]

I've given 'full control' to NETWORK SERVICE over my entire Documents folder and that seems to have resolved the above issue. I am now presented with another error about 'failed log in for NT AUTHORITY\NETWORK SERVER', but shall pose as another questions as it seems a separate enough issue.