Problem with connection string to SQL express

Question

Hello,

I get this error message when i try to using sql express:

An attempt to attach an auto-named database for file C:\Users\Name\Documents\Visual Studio 2008\Projects\MyProject\MyWeb\App_Data\MyDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

My connection string

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True;User Instance=True;

I can't finde out what the problem is. The database exist, it work when i trying to debbug. but not when i run IIS7 at localhost

Answer 1

My guess is that IIS7 is running under a different user account that doesn't have both read and write access to the directory and mdf file.

Answer 2

Do you have any database named MyDatabase or database who has create MyDatabase.mdf as data file in your sql express ?

Answer 3

Add read/write premissions for IUSR to the folder where the database is;

Best Regards!!!

Answer 4

I solve the problem with this two links: http://geekswithblogs.net/ProjectLawson/archive/2009/05/05/iis-system.web.aspnethostingpermission-exception-on-windows-7-rc.aspx

http://aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx