MS Tabular connection error
Hi Team,
We are getting error while taking the MS Tabular and MS OLAP connection .
We tried all the possibilities but we didn't get the connection could you please check it once.
Thanks,
Praveen.
5 replies
-
Hi Praveen,
Please search for the "Feature pack" of your MS SQL server.
You can find more information and the feature pack at this link:https://support.microsoft.com/en-us/help/2735567/how-to-obtain-the-latest-versions-of-msolap
Install the correct pack and check if this is solving the problem.Let me know if that helped.
-
from those list file which one i need to download?
please find the attached file your reference.
Thanks,
Praveen.
-
Dvir Buzaglo
i am using sql server version as:
"Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)"
-
Dvir Buzaglo
Thanks Dvir,
It is working fine now.
I got the solution from the below link.
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers
-
Hi, Try IP Address or Server Name instead of localhost. Having two types of SSAS installation means you have 2 separate instance name even though you have one server. So for TAB it should be the TAB instance and OLAP for another. In addition, I assume the Active Directory domain in which the SSAS server is installed is in PyramidG2. Make sure this has Administrator access in both instances. To check if this is Pyramid issue or a configuration issue. Open your SSMS (SQL Server Management Studio) and test this out using the account you provide. Good luck on Pyramiding, CM