ASPNETDB.MDF

[GaryDean]

I noticed that my asp.net project contains a 10 meg ASPNETDB.MDF database
in the App_data folder. I never intentionally put it there, have never ran
regsql.exe. Reading back on my logs it got there on March 7th the day I was
adding some web references.

How might this have gotten added to the project?

--
Regards,
Gary Blakely

[Cowboy \(Gregory A. Beamer\)]

Re: ASPNETDB.MDF

Did you ever run the web site administrative tool? If so, it creates one.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

http://gregorybeamer.spaces.live.com

*************** *************** ***************
Think outside the box!
*************** *************** ***************
"GaryDean" <GaryDean@newsg roups.nospamwro te in message
news:uud$JjQgHH A.3368@TK2MSFTN GP03.phx.gbl...

>I noticed that my asp.net project contains a 10 meg ASPNETDB.MDF database
>in the App_data folder. I never intentionally put it there, have never ran
>regsql.exe. Reading back on my logs it got there on March 7th the day I
>was adding some web references.
>
How might this have gotten added to the project?
>
--
Regards,
Gary Blakely
>
>

[Steven Cheng[MSFT]]

Re: ASPNETDB.MDF

Hi Gary,

Have you used any of the ASP.NET 2.0's services (such as Membership,
RoleManager, Profile ....) in your ASP.NET application? For all these
services, ASP.NET 2.0 by default use a connectionstrin g pointed to a local
"ASPNETDB.m df" (under App_Data folder). here is the default
connectionstrin g in the machine.config file:

============
<connectionStri ngs>
<add name="LocalSqlS erver" connectionStrin g="data
source=.\SQLEXP RESS;Integrated
Security=SSPI;A ttachDBFilename =|DataDirectory |aspnetdb.mdf;U ser
Instance=true" providerName="S ystem.Data.SqlC lient" />
............
============

Also, whenever your ASP.NET application has called any code that use those
services, if the runtime found that the "aspnetdb.m df" is not existed, it
will try creating it. That's is possibly the cause why you find the
"ASPNETDB.m df" file be created without your interactive operation.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



=============== =============== =============== =====

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

=============== =============== =============== =====



This posting is provided "AS IS" with no warranties, and confers no rights.

[Steven Cheng[MSFT]]

Re: ASPNETDB.MDF

Hi Gary,

Does the information help you some? If you have any further question on
this, please feel free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.