Integrated security + Forms authentication

  • Thread starter Thread starter Markus Stehle
  • Start date Start date
M

Markus Stehle

Hi all!

I would like to create a new asp.net web application that uses forms
authentication. When accessing e.g. a MS SQL database, what user acount will
be used for that? Is it possible the enable integrated security so that
roles based on user groups can be created for the database?

Thanks

Markus
 
you'll find that the .NET framework created a local user called "ASPNET"
which has a strong password. If both SQL Server and IIS are on the same
machine, you can give database permissions to this user (your ASP.NET app
will use this as its identity). Otherwise, you can create a different user
and configure to use that one instead. There's plenty of doco on it in the
..NET documentation and there's also doco inside your machine.config and
web.config files. See if this helps:
http://msdn.microsoft.com/library/d.../vbconAccessPermissionsForWebApplications.asp

regards,
stephen
 
Back
Top