During Installation the installer may fail with the following error
CREATE LOGIN [biztalk360] WITH PASSWORD=N'Pa$$w0rd!', DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
By default, the installer will create a SQL login/user with the name 'biztalk360' and password 'Pa$$w0rd!'. This credential is mainly used by the UI and monitoring service to access the custom "BizTalk360" configuration database. Sometimes the SQL password policy enforcement will be in place, and the above supplied password may not be meeting the requirement.
You can solve this problem by manually creating the SQL login using the following command
Then run the BizTalk360 MSI installer. Once the installation is complete, then manually edit the connection string in the following two configuration files
C:\Program Files (x86)\Kovai Ltd\BizTalk360\Web\web.config
C:\Program Files (x86)\Kovai Ltd\BizTalk360\Service\BizTalk360.Monitor.exe.config