Hi.

I'm trying to install the appointment system and I've done what I'm supposed to do (page 349 - setting up the appointment booking system). I'm running XP. The aspnet process has read/write/list etc. on the app_data folder. I've tried a number of things trying to connect. I've also attached the file in sqlmanagement studio and copied the string into web.config but that does not work either..
"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Utvikling\ WebRoot\AppointmentBooking\App_Data\ASPNETDB.MDF;I ntegrated Security=True;Connect Timeout=30;User Instance=True"

The persistent problem I have is that is that I'm getting the error:
"An attempt to attach an auto-named database for file D:\Utvikling\WebRoot\AppointmentBooking\App_Data\a spnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. "

I also get the same error message when trying to use the other applications.... And yes, I'm quite new to .net...

Thanx in advance

Morten

Hi there,

What happens if you create a brand new web site, add a <asp:Login> control to the Default.aspx page, run it by pressing Ctrl+F5 in VWD and try to log in?

When you do that, you should get an ASPNETDB database.

That at least confirms SQL Server is set up correctly.

Also, try detaching the database again in SQL Server.

Finally, is D a disk drive local to your machine?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004