Clearing Credentials Cache in Excel when connecting to cubes

Paul Mauriello
Paul Mauriello used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,

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.

Cheers
Paul MaurielloSoftware Programmer Developer Analyst Engineer

Author

Commented:
Thank you for your help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial