Search code examples
visual-studio-2013dacpacms-release-management

Release Management- DACPAC Deployer failed over untrusted domain connectivity


I have tried Database deployment to a server which is in a different domain using DACPAC Deployer. The server connectivity established through ghost accounts and i had successful deployments to the same server using XCOPY Deployer earlier.

DACPAC Deployment have been rejected and I have got following error message.

The installation command \"C:\Users\rmghost\AppData\Local\Temp\ReleaseManagement\ROMEO.DB Deployer\201408121235204725703-3\sqlpackage.exe /Action:Publish /SourceFile:".dacpac" /TargetServerName:"" /TargetDatabaseName:""\" failed with the exit code \"-2146232576\".

Please share your thoughts to resolve this issue.


Solution

  • "Microsoft.SqlServer.TransactSql.ScriptDom.dll" was missing in the target DB server, which is a prerequisite for DACPAC deployment. So I installed " Microsoft SQL Server 2012 Transact-SQL ScriptDom" and triggered the release from RM. The release was successful.

    Thank you very much for the support... !!!