Issue with Deploying Biztalk application using powershell script

[Sakshi2190]

Hi All,

I am trying to deploy the msi created by btdf to BizTalk environment using powershell script. The scripts fail at the line : Run “BTSTask.exe AddApp -ApplicationName:”AppName” -Description:”AppDescription”
With error : “Unable to validate the given database “BizTalkMgmtDb” and server “SQLSERVER”.

I am running the script on the box that has BizTalk installed on it which is connecting to sql instance that is installed on a different machine.
Thanks

[suryasreepada]

Any update on this issue? I am facing the same problem while trying to deploy the App using Jenkins Build.

I am exactly following below post for deployment, but using Jenkins
https://vikas15bhardwaj.wordpress.com/2015/02/06/biztalk-application-deployment-using-btdf-and-powershell/

[tfabraham]

Are you actually running the commands on the BizTalk server, or are you running them within a remote PowerShell session? This is not an issue with the Deployment Framework. You can copy and paste the BTSTask.exe command line above into a Command Prompt and run it completely outside the BTDF process. Until you get that working, you'll have various issues.

[suryasreepada]

Thanks for your quick response.
I found the problem and fixed it.

Problem: Jenkins Windows Service is running under "Local System Account" which does not belong to any of the BizTalk AD groups, thus not having permission to access BizTalk databases.

Solution: Changing log-on User for Jenkins Windows Service to a Service Account with access to BizTalk resources.

If possible, it would be helpful to add an additional message along with "Unable to validate the given database “BizTalkMgmtDb” and server “SQLSERVER" message.