Hi there --
I'm trying to connect to an SSAS server via SSMS (the preferred client I'd guess but who knows).
Data Source=xxxx;Initial Catalog=xxx;User Id = xxxxx;password=xxxxx;Provider=MSOLAP.7 (this one is optional I think); Format=Tabular (this one also optional);
The SSMS was version 17.x but I downloaded 17.9 (most recent) as well.
The SSAS version? Well, who knows, I can't connect. The 'creator' is long gone. Actually via Visual Studio it looks like 10.0.5500.0.
ALL CREDENTIALS ARE ACCURATE.
I get the following error
"Element 'return' was not found. Line 5, position 2. (System.Xml)"
The credentials are reading as accurate because changing the user ID or password to anything else results in a different "connection denied" error. So the credentials are being accepted.
ALSO I can connect to the SSAS server just fine using Visual Studio 2015. It connects and shows me all tables.
So WHY the cryptic error in SSMS? What file or .jar or .dll or whatchamacallit BS is necessary here?
Googling the cryptic error message reveals nothing, so I wouldn't try. It only shows one Microsoft Peon claiming it's a connection timeout setting thing and to raise that. It's not that, and raising it does nothing.
So anyone know what to do here?
I'm not even concerned with deducing what the error means per se; is there a checklist in how to connect to SSAS with SSMS? All the credentials are right. I'm using the same connection string in MS Visual Studio 2015.
In Visual Studio 2015, I am selecting ".Net Framework Data Provider for OLE DB" and then "MS OLE DB Provider for Analysis Services Version X.0"
In SSMS, I'm selecting Analysis Services connection, and using the Windows Authentication (with connection string that provides user id and password, again the credentials are being accepted, there is a random cryptic error).
What's going on here? Very frustrating.