Problem with connection string to SQL express

Question

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

score 0 · Answer 1 · answered Sep 02 '09 at 11:54

0

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.

answered Sep 02 '09 at 11:54

Pete

12,206
8
54
70

The are same user account at the web folder and on the app_data folder – Sep 02 '09 at 11:57
The IIS user obvoiusly has read access then, but does it have write access? – Pete Sep 02 '09 at 12:43

score 0 · Answer 2 · answered Sep 02 '09 at 11:54

0

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

answered Sep 02 '09 at 11:54

MRG

3,219
1
26
35

The database exist in the folder – Sep 02 '09 at 11:56
i am just curious whether you have any file named MyDatabase.mdf in "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" folder ? – MRG Sep 02 '09 at 11:58
Not in that folder, in the app_data folder for my web project – Sep 02 '09 at 12:00
Do you have given permission APP_Data folder for NETWORK_SERVICE user ? – MRG Sep 02 '09 at 12:01
Can you check the link below http://msdn.microsoft.com/en-us/library/ms998320.aspx Check sections named File Access and SQL Server and confirm if your IIS and Local SQL Server has enough permissions. – MRG Sep 02 '09 at 12:12

score 0 · Answer 3 · answered Sep 02 '09 at 12:07

0

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

Best Regards!!!

answered Sep 02 '09 at 12:07

MRFerocius

5,509
7
39
47

Well, if it allready have that? And it not working with that? – Sep 02 '09 at 12:09
Try this, gives you some steps to solve the issue; http://www.aspspider.com/resources/Resource170.aspx Also give permission to NETWORK SERVICE on that folder.- – MRFerocius Sep 03 '09 at 12:07

score 0 · Accepted Answer · edited Dec 27 '22 at 15:03

0

I solve the problem with this two links: Link

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

edited Dec 27 '22 at 15:03

Glorfindel

21,988
13
81
109

answered Sep 05 '09 at 14:48

Problem with connection string to SQL express

4 Answers4

Linked