Permissions problem



When I run a certain SQL server process, I see the following in my filemon log:

4:56:52 AM sqlservr.exe:1232 QUERY FORMATION
C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp SUCCESS Attributes: D
4:56:52 AM sqlservr.exe:1232 CREATE
C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp\JETE108.tmp SUCCESS Options: Create
Access: 0013019F
4:56:52 AM sqlservr.exe:1232 QUERY INFORMATION
C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp\JETE108.tmp SUCCESS Length: 0

Strange thing is, the folder referred to (
"C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp") seems not to exist. When I log in on
the administrator account via remote desktop, and look at the file system, no
such folder is visible (even allowing for truncation of the name; I assume
the complete path would be"C:\Documents and Settings\Networ[something]\Local
Settings\Temp").

Perhaps the problem is this folder is only visible to the account under
which SQL server runs. But I can't tell what account that is, and it does
not seem to be an account with a login on the server. (The system has a
typical 5 CAL license.)

I need to somehow change the permissions on this non-existent folder. How
can that be done?

Is this totally obvious to everyone but me? Where is this documented?
.



Relevant Pages

  • Re: dts and access db
    ... How can I setup permission for sa account under \\server\data folder? ... The service account for SQL Server ... >>already opened exclusively by another user, or you need permission to view ...
    (microsoft.public.sqlserver.dts)
  • RE: Get permission error after mdb move.
    ... You can give the Network Service account that Express is running under rights ... Check the security permissions that were granted to the folder on ... LocalService and Network Service are both low privilidged accounts. ... and attached to an instance of SQL Server 2005 ...
    (microsoft.public.sqlserver.server)
  • Re: could not read file snapshot.pre due to OS error 5
    ... Is the snapshot folder shared? ... the SQL Server Agent account or the account you are impersonating with have ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Error while generating Snapshot
    ... another box then it'll need to be a domain account with the correct ... impersonating it in the sql server agent and not using a proxy (SQL Server ... in the creation of the snapshot folder. ... full and no account can create a folder in the snapshot share - can you just ...
    (microsoft.public.sqlserver.replication)
  • Re: How to change system user name in the Documents and Settings f
    ... Restart the computer after changing your account name in the Control ... and check the profile folder in the Windows Explorer ... I tried to change the name with no success. ... I tried changing the rights to RWMD with no ...
    (microsoft.public.windowsxp.general)