Why does an SL User that is not in the Administrators Group to click Trust Connection when they want to run a pivot table w/in QQ?
Is there a fix for this issue other than adding the user to the Administrators Group?
Thanks,
Chuck
Why does an SL User that is not in the Administrators Group to click Trust Connection when they want to run a pivot table w/in QQ?
Is there a fix for this issue other than adding the user to the Administrators Group?
Thanks,
Chuck
Chuck,
Thank you for posting this to the forum. I am sorry for it going so long without an option or answer. What yo might look at doing, if you have not already, create your view for QQ with a Run As. The standard QQ views have the "Run As E8F575915A2E4897A517779C0DD7CE" so that the Windows/SL individual is not setup to have direct permissions.
Hope this helps. I have never setup a pivot table w/in the QQ, but can you use the E8... user or other SQL managed user to run as to get the data without granting the Windows user the Admin level of permissions?
Thank you,
Carolyn
MSDSL Technical Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148