The SQL provider cannot run because of a missing dependency. Please make sure that Microsoft SQL Server Transact-SQL ScriptDom is installed

sql-server visual-studio web-publishing scriptdom
irfandar picture irfandar · Oct 4, 2016 · Viewed 7.9k times · Source

Web deployment task failed. (The SQL provider cannot run because of a missing dependency. Please make sure that Microsoft SQL Server Transact-SQL ScriptDom is installed.

I get this error while publishing any web app in visual studio with update database enabled. It was working fine until I upgraded SQL SERVER MANAGEMENT Studio to 2016.

I tried unistalling and reinstalling sql server and all required components but in vain

Any suggestions will be appreciated

Thanks

Answer

fiat picture fiat · Nov 7, 2016

Registering the ScriptDom assembly in the GAC solved this for us:

"%ProgramFiles(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

Related questions

Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

I get the following error when trying to connect to SQL Server: Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the …

Read More
How to get the connection String from a database

I have created a database with SQL Server Management Studio, I would like to now use it in my C# application. I need the connection string? Where can I find the connection string, and where is my database stored? Do …

Read More
SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that …

Read More