Hello, i'm trying to generate a user profile web service call from an SSRS report to pull in the current user's profile properties.  The current error I'm receiving is 

The remote server returned an error: (500) Internal Server Error.
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<soap:Fault><faultcode>soap:Server</faultcode>
<faultstring>Server was unable to process request. ---&gt; Attempted to perform an unauthorized operation.</faultstring>
<detail />
</soap:Fault>
</soap:Body>
</soap:Envelope>

I can make the call using JavaScript from within a SP site without any issues, but out side of a site (SoapUI, SSRS Report) I get the attempted to perform an unauthorized operation error.

I've read a couple articles that suggest adding the service accounts and web app pool identity to the "Manager" and "Permissions" for the UPA service (full control).  This hasn't resolved the issue.  I even tried adding my personal account and testing with SoapUI and still receive the same error.

I've tried it on web apps with anonymous enabled and disabled with the same results.

Any help will be appreciated.

Hi Jared,

The SOAP UI is a third-party product; thus, we dont know how it runs. Since Reporting Services supports the Web Service type data source, is it possible for you to access the SharePoint Web Service directly or use the built-in SharePoint List type data source in the report? If so, please see:

• Consuming SharePoint 2010 Lists Data in the SSRS 2008 R2 Reports
• Reporting Services: Using XML and Web Service Data Sources

Besides, here are resources about SoapUI authentication that may be useful for you:

• Authenticating SOAP Requests
• Web Service Sample Project

Hope this helps.

Regards,