Attach and Detach SQL Express Database

T

Tamer Ibrahim

Hi,
I'm developing a web site using visual studio 2005 [Pro. Edition]. I created
my databse in the folder App_Data to be attached automatically to sql
express 2005 when I run the site. So far, so good. In order to add microsoft
membership database to my web site database, I opened sql server 2005
management studio and I got my web site databse attached then I used the
aspnet_regsql utility to add the membership database. Then I got my database
detached again.
So far, so good. When I tried to rum my web site again, It kept showing this
error message :

An attempt to attach an auto-named database for file
c:\inetpub\wwwroot\Project\App_Data\xxx.mdf failed. A database with the same
name exists, or specified file cannot be opened, or it is located on UNC
share.

Any help will be most appricated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,756
Messages
2,569,535
Members
45,008
Latest member
obedient dusk

Latest Threads

Top