I'm trying to access an SSAS server from SSMS v17.4 (2017).
I'm using Windows Authentication. I know the credentials are correct and can actually connect successfully from Visual Studio 2015.
However in SSIS, with the connection string (note my credentials are not my actual Windows login but an assumed identity/ different username I think).
Server type: Analysis Services Server name: myServerName.com\myCatalog Authentication: Windows Authentication
Data source = myServerName.com; User ID = myUserID; Password = myPassword; Initial Catalog = myCatalog; Provider=MSOLAP.7; Format=Tabular;
I know the connection string is registering as correct because when I put in a wrong/ dupe password, a different error results. The system knows the password is correct.
I'm getting the error
Element 'return' not found. Line 5, position 2. (System.Xml)
So I'm not sure what's going wrong here. What is the best client to connect to an SSAS environment to view Cube definitions and MDX queries etc? What could be going wrong here where the connection otherwise works fine in Visual Studio 2015 from the same computer?
I heard it could be .dll files of some sort. No idea where to begin here.