February 9, 2018 at 7:15 am
We are testing out using always encrypted and the developer has written a SSIS Package to load a table with an encypted column. It works fine when he runs the package from his local workstation. When we deploy the package to our server and run it using an agent job running under a service account the package errors with a message that it can not find the certificate with the proper thumbprint in certificate store 'My' in certificate location 'CurrentUser'.
Server is Windows 2012. I've imported the certificate to pretty much every store location I can think of. Putting it in the sql server or sql agent service account personal certificate store didn't work. Anyone know where the correct store location is?
February 28, 2018 at 6:37 am
Mike Reigler - Friday, February 9, 2018 7:15 AMWe are testing out using always encrypted and the developer has written a SSIS Package to load a table with an encypted column. It works fine when he runs the package from his local workstation. When we deploy the package to our server and run it using an agent job running under a service account the package errors with a message that it can not find the certificate with the proper thumbprint in certificate store 'My' in certificate location 'CurrentUser'.Server is Windows 2012. I've imported the certificate to pretty much every store location I can think of. Putting it in the sql server or sql agent service account personal certificate store didn't work. Anyone know where the correct store location is?
is this a user or computer configured cert?
the account will need permissions to access the cert also
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply