How to cache a dxp that uses data connections

I have a dxp file thats connected to a MS SQL Server


I saved the data connection in the library, but when admin goes to cache the dxp he gets a permissions error


How can I cache this dxp and all of the data it pulls from the data connection?

(1) Answer