I have a similar issue, but I'm not using an sp. In fact, it's an empty package and does absolutely nothing. If I execute the package from SSIS, it's works...

I am still getting the error

"Msg 7850, Level 16, State 1, Line 2

The SQL Server Service account does not have permission to register the supplied URL on the endpoint...