asked
linked server & permissions
Hello all, [see previous question & answer for background][1] $env:temp | out-file C:\\Users\\Tony\\Documents\\out.txt -append I know this was a while ago but I find myself in the same position as you were then and could do with a couple of pointers. i followed your advice and ran the powershell commands as above. 1 component as Network service logon. Tony C:\\Users\\Tony\\AppData\\Local\\Temp 2 component as Local service logon. C:\\Users\\Tony\\AppData\\Local\\Temp Tony 3 component as local system C:\\Users\\Tony\\AppData\\Local\\Temp Tony as can be seen the system always seems to point to the "tony temp" I have changed the permissions to temp to allow network service and local service full control. The services directory, as mentioned in your previous answer, also has permissions for full control. The odd bit about this is that i have 3 or 4 times managed to get the access database to return data. 1st time I changed from network service to local system. It all worked until I started the computer the next day. After a few attempts I changed to network service and it started to work again. Then after a restart it would not work and this time no swithing to alternative component logons has any affect. I changed the permissions to allow "everyone" but with no luck. Oh I am using 32 bit and have the access database engine installed. Also i am using 2008 r2 developer version. [1]:
http://ask.sqlservercentral.com/questions/77455/location-of-user-account-temp-dir-for-service-accounts-jet-drivers-on-64-bit?page=1#78033
What error do you get? What query are you executing? Did you read and follow all the links in the previous question? I had to try multiple things before arriving at a satisfactory conclusion. Using the [SysInternals ProcMon tool][1] was useful in determining/clarifying that it was those directories I needed, but that was only after many earlier steps of getting the 64 bit drivers configured properly. [1]:
http://technet.microsoft.com/en-gb/sysinternals/bb896645
