Re: SQL 7 Server does not seam to respect NTFS permissions.....

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/04/03


Date: Thu, 3 Jul 2003 21:12:06 -0400


Just to add somewhat to that answer. There is also an account that the SQL
Server Agent runs under and a proxy account as well. These may or may not
be the same account as the one sql server runs under. They are used for
other purposes that may or may not need access to the underlying file system
or OS. While this seems unrelated, if you read down some it talks about how
the proxy account may or may not be used.
http://www.support.microsoft.com/?id=269074

-- 
Andrew J. Kelly
SQL Server MVP
<.> wrote in message news:egXmcibQDHA.1712@TK2MSFTNGP12.phx.gbl...
> Thank you Andrew, that clears that up.
>
>


Relevant Pages

  • Re: Newbie Help!
    ... I agree with Andrew. ... Senior Database Administrator ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: New Server RAID setup
    ... Andrew thank you for all your help! ... Ideally yes it would be best to have IIS etc on another ... > sharing resources with SQL Server. ... > server as SQL for performance & security reasons. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Dual Processors INSERTS take long time
    ... Andrew J. Kelly SQL MVP ... > find is that the transactions per sec, is a lot lower on the server. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Problem with Transaction backups
    ... Andrew, ... Since I couldn't get a Y2K3 Server with SQL Y2K5 on it I used the same ... SQL Y2K5 SP3 shutdown the WindowsXP SP2 test machine with a blue screen. ... The SQL window opened up with a built up query like it was ...
    (microsoft.public.sqlserver.server)
  • Re: Memory
    ... a server that has SQL Server and another app I try to set the Max memory ... setting in such a way as to always leave memory for the other app. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)

Quantcast