Swapnil Nandane

Swapnil Nandane

  • NA
  • 121
  • 17k

access analysis database from excel with users old password

Oct 26 2018 1:13 AM
Hello Guyz,
 
I have windows user xyz and one analysis (SSAS) database associated with this user and only xyz can access it, no other users.
I can access this database from Microsoft Excel using analysis database connection in pivotal tabular form using windows user credentials.
 
Now i have one strange issue, i have changed password of user xyz, but it still connect to database using old password even connect with new password too.
I have never store password while connection.
 
Please let me know where i'm wrong
 
thanks in advanced
 
regards
Swapnil