Hot answers tagged

10 votes
Accepted

8000 character limit in OPENQUERY against Analysis Server

I need to query Analysis Service with OPENQUERY, handle the query of length greater than 8000, save the results to a temporary table or select them directly. sql-serverssasmdxEdit tags Instead of ...
user avatar
4 votes

8000 character limit in OPENQUERY against Analysis Server

You could try to avoid openquery and use something like SSIS or Azure Data Factory or some other ETL tool which doesn't have the 8K character query limit. Alternatively if you want to keep using ...
user avatar
  • 15.4k
2 votes

No connection to the analysis service

As per the Microsoft Books Online for the SQL Server Browser service: The SQL Server Browser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL ...
user avatar
  • 24.2k
1 vote

How to install SSAS in SQL server 2019

Yes now it works in this way. Install SSDT with Visual Studio 2019
user avatar
  • 3,347
1 vote

What version of MSOLAP provider am i using?

You can use SysInternals Process Explorer to find which DLL is in use. Find > Handle or DLL. Type MSOLAP in the search field then connect to your DB and hit search in Process Explorer. The result ...
user avatar
  • 11
1 vote

Server side tracing for SQL Server Analysis Services

maybe you can setup the query log in the ssas instance properties.
user avatar
  • 3,347
1 vote

how to find the error description for the error codes found in the extended events file XEL generated by SSAS Tabular query end event

I think you should look at the [TextData] field. Based on Microsoft doc here: https://docs.microsoft.com/en-us/analysis-services/trace-events/errors-and-warnings-events-data-columns?view=asallproducts-...
user avatar
  • 3,347
1 vote

Analysis Services backup error: File system error: Access is denied

I fixed similar error message on Windows Server 2016 / SQL Server 2017 by granting an access on backup folder to SQL Server Analysis Services (MSSQLSERVER) service account (NT Service\YourAccountName)....
user avatar
  • 11

Only top scored, non community-wiki answers of a minimum length are eligible