Clearing Credentials Cache in Excel when connecting to cubes

I want Excel to prompt me each and every time for credentials each time i try to connect to the cubes. I don't want them saved ever.

Where does that setting live?
Paul MaurielloSoftware Programmer Developer Analyst EngineerAsked:
Who is Participating?
dfkeConnect With a Mentor Commented:

basically the idea then is not to use Windows Authentication but SQL authentication on the SQL database and keep away from using an SSS (Secure Storage Service database) or even the connection file.

Read up here.

Paul MaurielloSoftware Programmer Developer Analyst EngineerAuthor Commented:
Thank you for your help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.