Re: MDF file vs. Local Sql Server...what's the connection?
- From: "Mark Fitzpatrick" <markfitz@xxxxxxxxxx>
- Date: Sat, 3 Nov 2007 09:18:17 -0500
The main difference is: the file that's in the app_data folder is a SQL
Server database, but it's not technically attached to the database as the
ones in your view are. You are connecting to the database as an independent
file, which is typical of a sql server express database in an app_data
folder. So, technically SQL Server Express is handling requests to it, but
is not attaching it as a constantly running database.
Make sure that your hosts supports SQL Server Express as a lot of them
don't. If they don't you'll have to publish the database to a full SQL
Server and it won't be running from the app_data folder.
Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression
"Darrel" <notreal@xxxxxxxxxx> wrote in message
news:OxXzvDiHIHA.5232@xxxxxxxxxxxxxxxxxxxxxxx
I'm still having a hell of a time figuring out this whole SQL Express set
up.
I finally discovered why I couldn't run the aspnet_regsql...my local sql
server wasn't running.
I turned that on, and now I can see a list of DBs running locally.
However, the .mdf file I have in my app_data folder does NOT appear on
this list.
I'm confused. Is my local SQL server (installed with VS.net) NOT the same
as my SQL Express DB in my app_data folder? If not, how do I set up my MDF
file to accept the membership provider tables?
Any help appreciated. This has been a huge road block for me.
-Darrel
.
- Follow-Ups:
- References:
- Prev by Date: Re: Newbie ASP.NET/Blog question
- Next by Date: Re: Newbie ASP.NET/Blog question
- Previous by thread: MDF file vs. Local Sql Server...what's the connection?
- Next by thread: Re: MDF file vs. Local Sql Server...what's the connection?
- Index(es):
Relevant Pages
|
