Related Tags:
CMS A content management system (CMS) is a software application or set of related programs that are used to create and manage digital content. CMSes are typically used for enterprise content management (ECM) and web content management (WCM) Learn More, Sitecore Sitecore is one of the leading enterprise-level content management systems built on ASP.NET, enabling web content editors and marketers to have full control over all aspects of their website from social integration and blog posts to advanced personalisation, e-commerce and more. Launched in 2001, Sitecore has used the .NET platform from the beginning of the language itself, and has been growing in popularity over the last few years. Currently on its 7th major version, it now runs on .NET 2.0/4.0, and the core has been rewritten from scratch to take advantage of the improvements made in ASP.NET 4.5. Learn More, Sitecore 9 Sitecore is a Web Content Management System (CMS) built on Microsoft This tag is for sitecore version 9. Learn More, Sitecore 9.0.2 (Sitecore 9 Update 2) It is an updated version of Sitecore. Sitecore released Sitecore 9.0.2 (Sitecore 9 Update 2) on 22nd June 2018. Learn More,

During the installation of sitecore 9 update 2 ,getting the "ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER" error

Description:I am getting following error during installation of sitecore 9 update 2,

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:
Install-SitecoreConfiguration : Command C:\Program Files\iis\Microsoft Web Deploy V3\msdeploy.exe returned a non-zero
exit code - (-1)
At C:\resourcefiles\install.ps1:49 char:1
+ Install-SitecoreConfiguration @xconnectParams -Verbose
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Install-SitecoreConfiguration
[TIME] 00:00:18
Invoke-CommandTask : Command C:\Program Files\iis\Microsoft Web Deploy V3\msdeploy.exe returned a non-zero exit code -
At C:\Program Files\WindowsPowerShell\Modules\SitecoreInstallFramework\2.1.0\Public\Tasks\Invoke-WebDeployTask.ps1:36
+ Invoke-CommandTask -Path $Path -Arguments $msdeployArgs -TaskName ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Invoke-CommandTask

While I have installed the prerequisite which is "Microsoft SQL Server Data-Tier Application Framework"
Note: I am installing sitecore 9 update 2 through powershall script and that was the final script I have run, I have installed all prerequisites and solr as well.

Posted by: | Posted on: Oct 24, 2019

2 answers



I have also gone through the same problem and what I realize after some research on the error that there are two versions of "DacFramework" I have installed "EN\x64\DacFramework.msi" but missed "EN\x86\DacFramework.msi" one.
We need to install both x64 and x86 , for the purpose you can goto that link and click on "click here to download manually" where you can check and download both("EN\x64\DacFramework.msi", "EN\x86\DacFramework.msi") and install both .msi files, thats it try runing your script again that should work.

Replied by: | Replied on: Oct 28, 2019


Thanks it really helped me :)

Replied by: | Replied on: Oct 15, 2020


Code block Hyperlink bold Quotes block Upload Images