Home / server / Questions / 1052031
In Process
David Rogers
Asked: 2021-02-02 16:49:53 +0800 CST

Unable To Access SSAS via MSMDPump File and URL

  • 772

I had this same issue when trying to connect to SSAS via a MSMDPump file, as stated in this article.

String reference not set to an instance of a String. Parameter name: s (mscorlib)

I got the following error message when trying to connect to my MSMDPump.dll via SSMS:

enter image description here

This when I tried to connect via excel:

enter image description here

When I examined the Event Log on this server I would see "Audit Failures":

enter image description here

windows sql analysis olap

1 Answers

  1. It appears I got my usernames confused, the "David.Rogers" user didn't exist, instead my user name should've been "DavidRogers", a very confusing set of error message to determine that the user account "David.Rogers" didn't exist.

    • 0