RE: ASPNETDB.mdf

Phillip,

An end user instance of a sqlexpress database runs just fine in the app_data
folder in a website. It works fine with sql authentication.
A sqlexpress database is ideal for a small non-profit organisation that
can't buy a complere SQL server.

Arne.

"Phillip Williams" wrote:

> You cannot. Under the same section where the link that I posted was, there
> is another article that applies to your question on roles:
>
> http://msdn2.microsoft.com/en-us/library/ms178375.aspx
>
> Quoted from the above article
> "SQL Server Express Edition
> When a process attaches to a SQL Server Express Edition database (.mdf
> file), the process must have administrative permissions. In general, this
> makes SQL Server Express Edition databases impractical for production Web
> sites because the ASP.NET process does not (and should not) run with
> administrative privileges. Therefore, use SQL Server Express Edition
> databases only under the following circumstances:
>
> Use as a test database while developing your Web application. When you are
> ready to deploy your application, you can transfer the database from SQL
> Server Express Edition to a production instance of SQL Server.
>
> Use if you are running a Web site that can use impersonation and you can
> control the privileges of the impersonated user. In practice, this strategy
> is practical only if the application is running on a local area network (not
> a public Web site).
>
> Store the .mdf file in your site's App_Data folder, because the contents of
> the folder will not be returned to direct HTTP requests. You should also map
> the .mdf extension to ASP.NET in IIS and to the HttpForbiddenHandler handler
> in ASP.NET using the following element in the site's Web.config file:
>
> <httpHandlers>
> <add verb="*" path="*.mdf" type="System.Web.HttpForbiddenHandler" />
> </httpHandlers>
> "
>
> --
> HTH,
> Phillip Williams
> http://www.societopia.net
> http://www.webswapp.com
>
>
> "Arne" wrote:
>
> > Phillip,
> > That article tells me how to connect to a SQLExpress database. It tells me
> > nothing about membership and roles that are administered on a website with
> > the ASPNETDB.MDF.
> > In Visual Studio there is a ASP.Net configuration for members and roles, but
> > this tool may not deploy to production.
> > How can I administer users in production?
> >
> > "Phillip Williams" wrote:
> >
> > > http://msdn2.microsoft.com/en-us/library/ms247257.aspx
> > > --
> > > HTH,
> > > Phillip Williams
> > > http://www.societopia.net
> > > http://www.webswapp.com
> > >
> > >
> > > "Arne" wrote:
> > >
> > > > How do I create aspnet.mdf on a production machine?
> > > > How do I administer users on a production machine?
.

Quantcast