April 12, 2019 at 8:26 pm
Maybe this is an easy question, but I am a bit stumped. We're writing SSIS programs which execute T-SQL to bulk load data from files on our LAN. It was failing when we test-ran it with our personal AD accounts, even though we could get to the underlying file system location through Windows Explorer. It took us a bit until our Network folks found a post which dealt with Kerberos Delegation, and the change allowed the service account used for MSSQL to impersonate users. Then it started working.
So, as a further curiosity, I tried running a restore database command, pointing to a file that I know the service account could not get to, and, the restore didn't occur. I guess I was thinking that the Kerberos fix would work here as well, and recognize my permissions when reading in the file.
When referring to a LAN location, does the service account's permission apply only to certain types of commands, while the executors permissions apply in others?
Thanks,
--=Chuck
April 12, 2019 at 9:18 pm
The service account is the same as any other account. They have permissions or they don't. It's possible they set permissions for the agent account rather than the service account, so check that. They could have also limited permissions to certain machines/shared.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply