App_Data Path and ASP.NET Membership

[PinkBishop]

Question regarding the ASP.NET 2.O Membership / Role component

The following works fine on local machine and networked dev box.

ASP.NET Membership protecting files and folders.

I am trying to run the Membership component.

I have loaded to production where host is running Win2k Server, IIS 5,
ASP.NET 2.0, SQL Express

I have a group of .aspx files that run fine without the protection of
Membership on host and with protection on local machine and networked
staging server.

After loading the Membership application I instructed host to make
appropriate db permissions and enable SQL.

The project folder is in a sub of the root. The app_data folder with
the .mdf file is in this sub project folder.

After enabling SQL and running the login application we keep getting
the message

"Your login attempt was not successful. Please try again"

At first we thought it was incorrect permissions set on DB.

But then we discovered that in the root of the web is another folder
named App_Data with the .mdf file in there as well. Some how the db
folder and db file were duplicated from the sub project folder to the
root.

It appears that the login.aspx file is trying to read and write to the
App_Data in the root based on the time stamp that is on the file
showing that a modification has been made to the db file.

So to the questions...

How do we get the project to work from the sub folder App_Data .mdf
file?

How did this duplication occur?

Kindest Regards...