ConstantineK

Let us continue this discussion in chat.

So none of the same troubleshooting steps would apply? Testing permissions for the service, verifying it can actually write files via another method (which you said it cant, therefore showing that you need to grant the account with whoami reporting permissions)?

Your account, or the 'whoami' account? Because then it might be just writing to the root of the drive is an issue. Otherwise, issue resolved?

Its possible, but I am unsure, try it with valid data.

It tells us that your folder within the c drive is writeable, can you change your first command (with ACE) to reference that location?

Right, but the %appdata%\local\temp folder isnt where you are writing the file, its C:\test.xls

if you want to find out who is running the service and it isnt clear to you, you can always run exec xp_cmdshell 'whoami'

Sorry for the confusion, I meant the folder location where the file will end up. Good news if you got access denied, your issue is reproducible! I would reccomend making subfolder (such as C:\Temp) and granting access there to test.

@MAW74656 maybe not, but we dont want to know that you can access the files, we want to know if the account running the sql service that creates the file has access. I just gave a method which would create a file in another fashion, there may be others, I just am unaware of them atm.

dba.stackexchange.com/questions/120239/… seems about right

Yep, I already was trying to find the most generic response since they didnt include a state

let me check if I can find one on here, because that is a common question

Ah, thank you for further clarification, I misunderstood

I probably should have just posted it here

@AndriyM sorry I posted the duplicate link in the comment in that link

dba.stackexchange.com/questions/133527/… anyone with karma want to close with a duplicate question

Dogfishhead is good stuff

SQL Server is pretty good at logging failed logins and the reasons for why, so you should be able to trace the request via profiler checking logins and executions -> profiler on source server -> tcpdump/firewall/port monitoring to ensure network traffic makes it -> profiler on dest server, procmon on dest server

If you are using SA/your account and getting different results, your idea about double hop could be a thing, but then I would check for failed logins on the server that is supposed to get the request

I misread one of your earlier comments, I didnt see that the user and the service both have permissions to access that file/folder location. The only way I could see it being a permissions issue at that point is if the Jet Provider somehow runs in another context, which I dont know how to trace beyond procmon type of of watching file access.

Hey @Maw74656, moved this to discussion based on SO's advice

So none of the same troubleshooting steps would apply? Testing permissions for the service, verifying it can actually write files via another method (which you said it cant, therefore showing that you need to grant the account with whoami reporting permissions)?

Your account, or the 'whoami' account? Because then it might be just writing to the root of the drive is an issue. Otherwise, issue resolved?

Its possible, but I am unsure, try it with valid data.

It tells us that your folder within the c drive is writeable, can you change your first command (with ACE) to reference that location?

Right, but the %appdata%\local\temp folder isnt where you are writing the file, its C:\test.xls

if you want to find out who is running the service and it isnt clear to you, you can always run exec xp_cmdshell 'whoami'

Sorry for the confusion, I meant the folder location where the file will end up. Good news if you got access denied, your issue is reproducible! I would reccomend making subfolder (such as C:\Temp) and granting access there to test.

@MAW74656 maybe not, but we dont want to know that you can access the files, we want to know if the account running the sql service that creates the file has access. I just gave a method which would create a file in another fashion, there may be others, I just am unaware of them atm.

sweet, just hit 2000

and no I cannot back that up with a source

in terms of battery life

kyle, the stated reason in apple's docs somewhere was that the ipod touch was somehow "optimized" for audio playback

that makes me happy that people are reading my words and getting use from them

one thing I like about this place is even when I leave I get karma

Nice one

Dont call me a liar fool

I wouldnt say the message was the liar as much as the man who wrote it was

(removed)

Same, I am not linguistically capable

I thought it would be like top rep listed for one site, since I didn't really contribute to those sites, and never used any SE but this

Oh, I never really went to any other sites except for once, so its cumulative for all the piddly+100 I get for viewing another site

Also weeeird, I have 1999 points in the chatroom but only 1500 in actual rep anywhere

so now I get to maintain like 15 different emails so I dont leave a very obvious pattern and they can probably cross reference geoip data and my user-agent string

@balpha thanks for looking, I guess I found a little bit related to this issue and that was the closest description on the nets and I hoped there was some other morsel not there

Actually I think my problem is different enough, I will just post my own question

Question for the chatters, I found this thread superuser.com/questions/188184/… which was closed as an exact duplicate, but the link it is linked to has been flagged as a dupe and then the dupe was removed, is there some way to see that information?