During Installation the installer may fail with the following error


Product: BizTalk360 -- Error 26204. Error -2147217900: failed to execute SQL string, error detail: Password validation failed. The password does not meet Windows policy requirements because it is too short., SQL key: CreateSqlLoginWin SQL string: IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'biztalk360')
BEGIN
CREATE LOGIN [biztalk360] WITH PASSWORD=N'Pa$$w0rd!', DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
END


Cause:

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. 


Solution:

You can solve this problem by manually creating the SQL login using the following command


CREATE LOGIN [biztalk360] WITH PASSWORD=N'<<YOUR PASSWORD>>', DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON


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