Re: ASPNET user

From: Patrick.O.Ige (patrickige_at_optusnet.com.au)
Date: 11/05/05 

Date: Sun, 6 Nov 2005 01:14:40 +1100

Yes if you use Integrated Windos Auth which is Windoows Auth.
You would use ASPNET acct to access the DB if you add the acct to SQL server
But you need to assign permission to the acct to access your
tables,Stored_prco etc..
If you impersonate then you would be using the acct AS WHO YOU ARE to access
the DB.
Patrick
** **

"Tumurbaatar S." <spam_tumur@magicnet.mn> wrote in message
news:e22Gc#g4FHA.3324@TK2MSFTNGP10.phx.gbl...
> If Windows authentication used to connect to SQL server from ASP.Net
> application, a database should be accessible for ASPNET user account.
> Yes? But if I map ASPNET user to SQL server and grant it database
> access, then other ASP.Net applications can access my database. Yes?
> Also, if impersonation is enabled, then ASPNET is not used in this case,
> but IUSR_XXX. Yes?
>
>

Relevant Pages

  • Re: PLEASE HELP: Problem with security
    ... if it worked under inetpub then the problem is probably not the ASPNET ... > How do I make sure ASPNET has access to SQL Server? ... So the only way I can get the apps to work is move ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: PLEASE HELP: Problem with security
    ... How do I make sure ASPNET has access to SQL Server? ... ASPNET full access rights to the directory I am running out of. ... So the only way I can get the apps to work is move them ... >> the inetpub wwwroot directory. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Using Sql Server 2005 w/ ASP 2.0, attaching a .mdf
    ... but I need to use Sql Server 2005. ... Sql Server Setup ... I have changed to connection string in the local WroxUnited ... Service and ASPNET are users. ...
    (microsoft.public.inetserver.asp.db)
  • Use VS2005 with Sql Server 2005 and attach a .mdf (ASP 2.0)
    ... but I need to use Sql Server 2005. ... Sql Server Setup ... I have changed to connection string in the local WroxUnited ... Service and ASPNET are users. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: concatenate function
    ... Thanks Tom and Mark for your code. ... > acct int not null ... > Columnist, SQL Server Professional ... > col2: shipto primary key ...
    (microsoft.public.sqlserver.programming)
Loading