I keep getting the following error...
Unable to open the physical file "C:\Inetpub\wwwroot\AppointmentBooking\App_Data\as pnetdb.mdf". Operating system error 32: "32(failed to retrieve text for this error. Reason: 1815)".
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\AppointmentBooking\App_Data\asp netdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I have imported the .MDF file into SQL, my installation doesn't use an instance name, but Im accessing through the sa user.
<add name="AppointmentBooking" connectionString="server=PCNAME;Initial Catalogue=ASPNETDB;User Id=sa;Password=password;User Instance=true"/>
Doesn't need a SQL instance name does it?