Can't create Assembly Microsoft.AnalysisServices.dll on sql 2019 db with latest CU

Yihong Shan 1 Reputation point
2022-04-19T22:09:21.447+00:00

we can’t create assembly Microsoft.AnalysisServices.dll on sql 2019 db. Failed with dead loop:
Here is the dependency chains
Microsoft.AnalysisServices.dll -> Microsoft.AnalysisServices.Tabular.dll - > Microsoft.AnalysisServices.Core.dll -> system.web -> system.enterpriseservices -> system.runtime.remoting -> system.web

Please note: we can successfully create the assembly on both sql 2016 and 2017 without refers to system.web

194369-analysisservices-assembly.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,821 Reputation points
    2022-04-21T02:03:13.687+00:00

    Hi @Yihong Shan ,

    What's your version of the .net framework, please try to install the newest version for a try.

    In addition, please check the release of SSMS.

    Try to install SSMS18.11.1 to see if it could resolve the issue.

    download-sql-server-management-studio-ssms

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Erland Sommarskog 101K Reputation points MVP
    2022-04-21T21:35:25.907+00:00

    I guess the version of Microsoft.AnalysisServices.dll you are loading is different depending on which version of SQL Server you got it from. That is, maybe in older versions there was no reference to System.Web, but now there is.

    You could try adding System.Web, but it may be one of these system assemblies that are blocked from being added to SQL Server.

    0 comments