Limit application access via integrated security

From: Alex (Alex_at_discussions.microsoft.com)
Date: 07/13/05 

Date: Wed, 13 Jul 2005 13:47:01 -0700

We currently have a foxpro app that is retrieving data from a sql server. We
are using sql security but need to change it to integrated security.
However, short of installing an application level firewall, can we insure
that users setup with integrated security only access the sql server via the
Foxpro app and not through Excel or any other third party app?

Relevant Pages

  • Re: Limit application access via integrated security
    ... "Alex" wrote in message ... > We currently have a foxpro app that is retrieving data from a sql server. ... > are using sql security but need to change it to integrated security. ...
    (microsoft.public.sqlserver.security)
  • Please explain loss of token between web server box and sql box
    ... relating to Integrated Security with Asp.Net IIS 5 and Sql Server 2k. ... The problem arises when endeavouring to use Integrated Security at all ... grant the group Sql Server access and rights to the relevant database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Active Directory and SQL Server Connection
    ... when you say that you intend to use integrated security, ... creating a WindowsIdentity and calling Impersonate on that. ... > Thanks Sahil, ... so they have access to the sql server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Please explain loss of token between web server box and sql box
    ... The client user principal is a W2K AD domain member, the users accounts must be set up as "delegatable" in the AD. ... The IIS server's "machine account" is trusted for delegation in the AD. ... The SQL server SPN must be registered in the AD, or must run under "localsystem" identity. ... > relating to Integrated Security with Asp.Net IIS 5 and Sql Server 2k. ...
    (microsoft.public.dotnet.framework.aspnet.security)