locked
Web Deploy ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER RRS feed

  • Question

  • User225627229 posted

    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.

    msdeploy.exe -verb:sync -source:dbDacFx='C:\Users\tsyme\Documents\int_testing\.build\New folder\Database.dacpac' -dest:dbDacFx='Data Source=localhost;Initial Catalog=SkyWirePOS;Integrated Security=true',computername='https://ServerIpHere:8172/msdeploy.axd',username='InsertAdminHere',password='InsertPassHere',authType=Basic -allowUntrusted -enableRule:DoNotDeleteRule

    Thanks, would appreciate any feedback 

    Friday, March 31, 2017 4:10 PM

Answers

  • User-460007017 posted

    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

    Here is the disuccsion and the solution about your issue:

    http://stackoverflow.com/questions/39854285/the-sql-provider-cannot-run-because-of-a-missing-dependency-please-make-sure-th

    Best Regards,

    Yuk Ding

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Monday, April 3, 2017 6:37 AM

All replies

  • User-460007017 posted

    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

    Here is the disuccsion and the solution about your issue:

    http://stackoverflow.com/questions/39854285/the-sql-provider-cannot-run-because-of-a-missing-dependency-please-make-sure-th

    Best Regards,

    Yuk Ding

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Monday, April 3, 2017 6:37 AM
  • User225627229 posted

    Thank you for your response.

    I was able to get past the error after using the gacutil on the .dll

    However, I had to manually place the .dll into the folder in order for this to work. Which meant searching my C drive for the correct dll and then copy pasting it into the folder. It seems that somehow installing ssdt sometimes does not place the files into the correct locations for web deploy.

    Wednesday, April 5, 2017 8:54 PM