## 2 replies

Last post Apr 05, 2017 08:54 PM by tylersyme

• ### Web Deploy ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER

Hello all,

I am currently trying to use the dbDacFx provider to deploy a dacpac to a remote sequel server. However, when I do this, I get an ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER. I am doing this via command prompt.

This error, thankfully, gave me a link which showed the dependencies I would have to install. So I went ahead and installed all the ones which weren't already installed and attempted to run the command again but ended up with the same error.

I tried uninstalling web deploy and all the dependencies and then used Web Platform Installer to install web deploy. This also installed all required dependencies. No change. I did this for both my desktop and the remote server.

This is the command I am running. I am often using msdeploy to deploy .zip packages to this server, so I know my connection is fine.

Thanks, would appreciate any feedback

• ### Re: Web Deploy ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER

Apr 03, 2017 06:37 AM|Yuk Ding|LINK

Hi typlersyme,

The error message  ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER could be fixed by running following command to register the command:

"C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.2 Tools\gacutil" /i "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\Microsoft.SqlServer.TransactSql.ScriptDom.dll"


If it doesn't work ,you could try to install SQL Server Data Tools or install some feature in web platform install:

• Microsoft SQL Server 2012 Data-Tier Application Framework

• SQL Server 2012 Transact-SQL ScriptDom

• SQL Server System CLR Types 11.0

Best Regards,

Yuk Ding

Yuk Ding

MSDN Community Support