Booking System

foz604020 · July 12th, 2010, 10:30 AM

Hi,

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.

Code:

<connectionStrings>
		<add name="AppointmentBooking" connectionString="server=PCNAME;Initial Catalogue=ASPNETDB;User Id=sa;Password=password;User Instance=true"/>
	</connectionStrings>

Doesn't need a SQL instance name does it?

thanks,

Dave.

foz604020 · July 13th, 2010, 04:33 AM

Hi think i've got past this now, just need to set permissions on my ASPNET login. thanks.