We are trying to install Sitecore 9.0.1 rev 171219 (XP0)
on-premise.
Everything goes fine until it tries to create Sitecore.Messaging
Database. As the installation have already created MarketingAutomation, Processing.Pools and ReferenceData Databases successfully in SQL server. But when it is creating Sitecore.Messaging Database, throwing below exception:
Info: Opening SQL Connection with connection string 'data source=mysqlserver;initial catalog=Sitecore.Messaging;user id=sitecoresvc;pooling=False'. The 'transacted' setting for this connection is 'False'.
Error Code: ERROR_SQL_EXECUTION_FAILURE
More Information: An error occurred during execution of the database script. The error occurred between the following lines of the script: "9" and "12". The verbose log might have more information about the error. The command started with the following:
"CREATE USER [messaginguser] WITH PASSWORD = '123"
Password validation failed. The password does not meet Windows policy requirements because it is too short.
Looks like while creating this Database it is not respecting the password provided in ps1 file parameter but picking the default one.
Any help is much appreciated!!!