IIS web service does NOT access the database

Question

I published my web site to create IIS web service. but the problem is when I browse my web service by clicking on Browse *:80, it redirect me to my web-service home page which contains the list of my methods. But when I choose a method for test, it allows me to enter the inputs but when clicking the invoke button, it gives an error page. the error is:

System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Users\Nourah\WebSite1\App_Data\SBMSDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

I searched in the internet to find solution but couldn't. I tried different ways to solve it like the solution here but no result. !An attempt to attach an auto-named database for file failed in Vb.Net

Maybe it occur because I choose to Detach the database when publishing the website!! but still I have to do that because if I don't Detach the database, Visual Studio show an error and it doesn't publish the website.

I don't know how to solve this problem. please help me..

score 0 · Answer 1 · answered Mar 14 '14 at 12:59

0

You need to have "User Instance=True;" in your connection string.

    <add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress or your instance    name;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory or path of filename|youfilename.mdf;"/></connectionStrings>

answered Mar 14 '14 at 12:59

Jalpesh Vadgama

13,653
19
72
94

can you paste your connection string? – Jalpesh Vadgama Mar 14 '14 at 13:09
– user3287580 Mar 14 '14 at 13:21
You are missing userInstance=true semicolon – Jalpesh Vadgama Mar 14 '14 at 13:23
now it shows me this error: System.Configuration.ConfigurationErrorsException: The entry 'sbms' has already been added. (C:\Users\Nourah\Desktop\myWS\web.config line 33) – user3287580 Mar 14 '14 at 13:27
You are using sbms two times.http://social.msdn.microsoft.com/Forums/vstudio/en-US/23d02d5d-92b8-4a1e-9ea0-74b5c8b89e8c/webconfig-and-the-entry-key-has-already-been-added?forum=netfxsetup change to something diffrent – Jalpesh Vadgama Mar 14 '14 at 13:29
Should I chang it in the website (Visual Studio) or in the folder of the web-service? or in both? – user3287580 Mar 14 '14 at 13:30
if you have two entries in two web.config change it in one – Jalpesh Vadgama Mar 14 '14 at 13:31
it shows me this error: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Users\Nourah\WebSite1\App_Data\SBMSDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. – user3287580 Mar 14 '14 at 13:36
Dude is this files is already there or you are creating that? because its trying to create a new file – Jalpesh Vadgama Mar 14 '14 at 13:37
I have two web.config. the first one I created it. but the second one is already created. – user3287580 Mar 14 '14 at 13:40
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/49749/discussion-between-jalpesh-vadgama-and-user3287580) – Jalpesh Vadgama Mar 14 '14 at 13:40

IIS web service does NOT access the database

1 Answers1