Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

SL 2015 Quick Query Pivot Table SQL Server Login Trusted Connection Required

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

*This post is locked for comments

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SL 2015 Quick Query Pivot Table SQL Server Login Trusted Connection Required

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans