Azure Analysis Services

Deleting Cached Logins For Azure Analysis Services In SQL Server Management Studio

When Azure Analysis Services was announced I had to try it out right away. Of course I didn’t read the instructions properly so when I tried to log in to my Azure Analysis Services instance from SQL Server Management Studio, like an idiot I logged in with the wrong username. The problem is that once you’ve done this, with current versions of SQL Server Management Studio there’s no way of logging out and logging in as a different user. Luckily Igor Uzhviev of Microsoft had a solution for me and I thought I’d share it for anyone else who’s made the same mistake. Here’s what you need to do:

  • Go to your user local app data folder (the path is like this: C:\Users\<your_user_name>\AppData\Local\)
  • In this directory you need to delete:
    1) Any .dat files with names that start with "omlibs-tokens-cache…"
    2) The folder AADCacheOM, if it exists
  • You also need to open Internet Explorer and delete  all cookies and website data, because IE caches auth tokens too

Once you’ve done this, the next time you try to connect to Azure Analysis Services from SSMS you’ll get prompted to log in again. Future releases of SSMS will have proper support for logging in and out of Azure SSAS, but even with the latest version (version 16.5) you’ll still need to following these steps.

4 thoughts on “Deleting Cached Logins For Azure Analysis Services In SQL Server Management Studio

  1. Hi,
    Currently I am having similar issue using SSMS 18.7.1.

    Unable to obtain authentication token using the credentials provided. If your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please remove the user name and password from the connection string, and then retry. You should then be prompted to enter your credentials.

    Is there any way to clear token cash for newer versions ?

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.