SQL/IIS/Active Directory

From: Pranav (pranav.desai_at_eyt.com)
Date: 06/28/03 

Date: Sat, 28 Jun 2003 04:57:03 -0700

Scenario: A Win2k service is running under a domain
account. The domain account has permissions to SQL
server. Domain authenticated users make web requests thru
IE 6 & IIS 5. These requests are directed to the Win2k
service which in turn accesses the SQL server data via
OLEDB and returns results back to the user.

Question: Is there a way to utilize object level
permissions assigned to the individual users using SQL
server roles in the above scenario or will it always use
the win2k service account's permissions?

Thanks

Relevant Pages

  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL CE Synching Problems
    ... install location of SQL CE instead of under Inetpub like I had done before. ... > so the issue has to be between the server tools and the publisher. ... >>I ran the wizard again to check all the permissions and this is what it ... >> A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Disable Sysadmin to view metadata in SQL2005
    ... you are looking for a DRM solution for your database. ... Server does not provide such a solution. ... SQL Server Engine ... If the permissions are not granular ...
    (microsoft.public.sqlserver.security)
  • Re: Restore leaves DB in Loading state
    ... I think your problem may have something to do with permissions. ... SQL Agent account controlling the job or the context the job runs under does ... Senior Database Administrator ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)