Application Roles with IIS

From: Greg Frazer (anonymous_at_discussions.microsoft.com)
Date: 06/07/04 

Date: Sun, 6 Jun 2004 20:21:02 -0700

I wish to use SQL Server 2000 Application Security with an ASP (Classic) application.
When I run the ASP app and look at SQL Server Current Activity Process Info , the column Application is showing "Internet Information Services". How do I align SQL Server and IIS so that Application Security can be utilised?

regards

Greg
PS I have already set the Application Name for this site in IIS.

Relevant Pages

  • Passing IIS Anonymous Account to SQL Server
    ... I was hoping some one could clear up an ASP.Net security question I ... I am writing an ASP.NET application that connects to SQL Server. ... Some clients will undoubtedly wish to have IIS ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to disable all this security?
    ... Disable ALL security? ... How about disable IIS and SQL Server altogether? ... It seems your ASP.NET cannot access Pub database on SQL server. ...
    (microsoft.public.vsnet.general)
  • Re: EXECUTE PERMISSION DENIED on executing Sproc
    ... It has to do with SQL Server's security settings. ... to the account you're using to work with your SQL server DB. ... That will depend on how you've configured SQL Server, ... which in turn depends on which version of IIS you're using. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: security : a good approach ?
    ... to protect your SQL server ... against IUSR_x and against IIS using COM+ impersonation. ... COM+ impersonation in fact, never is recommended to increase security, it is ...
    (microsoft.public.inetserver.asp.general)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)