I am trying to install Sitecore Commerce 9.0 Update-3 on my machine, but I am getting the following error.
System.Management.Automation.PSArgumentException: Cannot find type [Microsoft.SqlServer.Dac.DacServices]: verify that the assembly containing this type is loaded. at System.Management.Automation.MshCommandRuntime.ThrowTerminatingError(ErrorRecord errorRecord) Invoke-DeployCommerceDatabaseTask : Cannot find type [Microsoft.SqlServer.Dac.DacServices]: verify that the assembly containing this type is loaded. At X:\Program Files\WindowsPowerShell\Modules\SitecoreInstallFramework\Public\Install-SitecoreConfiguration.ps1:253 char:21 + & $entry.Task.Command @paramSet | Out-Default + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Invoke-DeployCommerceDatabaseTask
The assembly mentioned above is located in my machine "X:\Program Files\Microsoft SQL Server\120\DAC\bin\Microsoft.SqlServer.Dac.dll".
I also have installed all the prerequisites mentioned in the documentation.
Has anyone been through this issue during Commerce installation?