Is WebDeploy 3.6 compatible with Windows Server 2022 and SQL 2022

Yana Pivovarova 5 Reputation points
2023-11-02T12:33:08.3066667+00:00

Hello

The question is related to compatibility WebDeploy with Windows Server 2022 and SQL Server 2022. We are using msdeploy to deploy MSDeploy pakages with some dacpacs and sql scripts

  • Does Web Deploy support Windows Server 2022? What version of Web Deploy does support (or is going to support) Windows Server 2022?
  • Compatibility with SQL Server 2022. Now we are using DACFX(version 14.0.x) , CLRTypes (14.0.x, 13.0.x), SMO(13.3.x). But as doc said they are not compatible with SQL Server 2022. I tried to install new version of DACFX (162.1.167.1) - and got the error from msdeploy - msdeploy.exe : Error Code: ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER. (By the way there is now available only version for x64, as I remember msdeploy needs both x32 and x64)

So, the question is - what is supported versions of Windows Server and SQL server that is compatible with msdeploy, and what version of DACFX , CLRTypes and SMO we should use for it.

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,082 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,426 questions
0 comments No comments
{count} vote