Error Code: ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER

Hit another build error yesterday, this time on deployment of a DACPAC via WebDeploy:

##[error]Error Code: ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER
More Information: The SQL provider cannot run with dacpac option because of a missing dependency. Please make sure that DacFx is installed.  Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER.
Error count: 1.

This one was pretty easy to troubleshoot and fix thanks to documentation from Microsoft:

image

In my case, I only needed to install the Data-Tier Application Framework via Web Platform Installer:

image

Or if you prefer directly from the Microsoft.com Download Center:

image

1 thought on “Error Code: ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER”

Leave a Reply