This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 73%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
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
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.
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 65%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
Are you find the answer for the above problem?
I'm facing the same issue with same scenario what you mentioned in your post.
kindly reply if you find the solution or not?
Hi,
no I did not find a solution, we changed the way of working, now I do not use Sync.
Regards
Massimo
Hi Olaf, both servers are using the Enterprise version, in both I've installed the last cumulative update (cu4). Thanks Massimo
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 20%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi @Massimo De Fanti , were you able to resolve the issue? We have similar issue with deployment to a SSAS2022 clustered instance. We can successfully deploy when the role is on the server 01, but receiving the same "file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize'" error, when SSAS role is owned by the server 02.
Hi Sergei,
no, I was not able to solve the issue, as workaround, I'm processing tabular directly on the '01' server.
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: