SSIS The computer must be trusted for delegation error

Question

I have an SSIS package that is tested locally and working fine. It basically just does a few queries to a database and that's it.

So, now I'm trying to deploy it. The environment is a bit different. We have a SQL Standard instance that we use for SSRS. It's a Windows instance. That's where we decided to put SSIS since we weren't sure if we could get everything we needed on the other instance. The other instance is SQL Server Web on Linux.

I'm testing it by executing directly from SSMS. I'm logged in as a domain user. But in the execution logs I see this:

Package:Error: An error happened while reading data from the provider: 'The requested operation cannot be completed. The computer must be trusted for delegation and the current user account must be configured to allow delegation. '

If I understand correctly, the SQL instance that the package is installed on (our SQL Standard instance) needs to be trusted for delegation and then my domain account needs trusted for delegation. Is that correct?

I'm making the assumption this has something to do with the SQL tasks in my package that are connecting to the Web edition SQL Server. But I don't understand why this is necessary. Why can't it just make a normal SQL connection, get the data, and continue on?

Answer 1

Hi @Dan Ulery ,

(1) The AD account under that SQL Server instance with SSIS is running needs a Kerberos setting for delegation configured. Which is not always possible. That is the reason for the error message you received.

(2) Please try to connect to the SSIS run-time server via Remote Desktop (RDP protocol).
After that conection is established, connect locally to the SQL Server instance in SSMS.
Such setup will allow you to execute SSIS packages without any problems.