In reply to Reema Patel:
Hi All,
For my case it is resolved by installing below Dacfx framework as suggested by Nic
You may need to install the newer version for below:
1. Microsoft SQL Server Data-Tier Application Framework (DacFx) version 2016 - www.microsoft.com/.../details.aspx
x64 machine require to install both x64 & x86
2. SQLSysCLRTypes.msi x64 - go.microsoft.com/.../
3. SQLSysCLRTypes.msi x86 - go.microsoft.com/.../
But I need to set registry value in below manner
Set the path to the Data-Tier application framework in Windows Registry:
Locate the installation folder of the MS SQL server version that you are using: \%ProgramFiles(x86)%\Microsoft SQL Server\<version>.
Find the Microsoft.SqlServer.Dac.dll file in one of the subfolders: \DAC\bin or \SDK\Assemblies.
Store the full path to this subfolder as a DacFxPath value (String type) under the registry key \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\3.
Set the path to the SQL ScriptDOM and CLRTypes components in Windows Registry:
Locate the installation folder of the MS SQL server version that you are using: \%ProgramFiles(x86)%\Microsoft SQL Server\<version>.
Find the Microsoft.SqlServer.TransactSql.ScriptDom.dll and Microsoft.SqlServer.Types.dll files in one of the subfolders: \DAC\bin or \SDK\Assemblies.
Store the full path to this subfolder as a DacFxDependenciesPath value (String type) under the registry key \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\3.
In my case I have set the registry path for both the registry key as :
C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin
Because I can find " Microsoft.SqlServer.Dac.dll" ,Microsoft.SqlServer.TransactSql.ScriptDom.dll and Microsoft.SqlServer.Types.dll
these dll in same folder.
Before this please check you have installed IIS on the machine.