SQl 2022 Deploy SSAS project and db sync

Massimo De Fanti 10 Reputation points
2023-06-01T10:11:44.7533333+00:00

I'have installed SQL Server 2022 analysis services On 2 servers. In server "02" I have also installed Visual Studio 2022 with Data Tools and the "Analysis Services" component. I have developed some "SSAS Projects", I'm able to deploy the SSAS db on the 02 server and on that server I'm able to process the db. I'd like, after processing on server 02 to sync on server 01.

I'm not able to sync, I've tried with the "Synchronize Database Wizard" selecting the db on the "02" server as source and server '01' as destination but I get an error message "opening the .... 0.CryptKey.bin" file

I've also tried to deploy from Visual Studio directly to server 01 but I got this error:

"An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize')."

NOte: I'm migrating from a SQL 2026 enviromente where the processe on a "02" server and then the sync on the "01" server works.

Any help will be appreciated.

Massimo

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,261 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,258 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,846 Reputation points
    2023-06-02T06:03:52.06+00:00

    First question: Which Edition of SQL Server/SSAS are you using?

    Database Sync is only supported in the Enterprise Edition, so if you have the Standard Edition, Sync is not supported, see:

    https://learn.microsoft.com/en-us/analysis-services/analysis-services-features-by-edition?view=asallproducts-allversions

    0 comments No comments

  2. Massimo De Fanti 10 Reputation points
    2023-06-02T06:36:41.1733333+00:00

    Hi Olaf, both servers are using the Enterprise version, in both I've installed the last cumulative update (cu4). Thanks Massimo