I am trying to install Sitecore 9 on my Windows 10 local developer machine runnin SQLExpress 2016. I have to attend developers training soon and for that I need Sitecore 9 running.
For some reason, I cannot pass forward this error. My SQL Express admin password is 2!SiteCore
which is strong enough but it keeps complaining that Error: Password validation failed. The password does not meet Windows policy requirements because it is too short.
It has been 24 hours for me and I have searched left right and center. I have tried many different options.
Please help
Thanks
Complete error message:
Info: Adding database (user id=sc9;data source=.\SQLEXPRESS;initial catalog=sitecore9_MarketingAutomation)
Info: Adding database (MsDeploy.Site/dbFullSql[@path='user id=sc9;data source=.\SQLEXPRESS;initial catalog=sitecore9_MarketingAutomation']/sqlScript)
Info: Opening SQL Connection with connection string 'data source=.\SQLEXPRESS;initial catalog=sitecore9_MarketingAutomation;user id=sc9;pooling=False'. The 'transacted' setting for this connection is 'False'.
Error: Password validation failed. The password does not meet Windows policy requirements because it is too short.
Error count: 1.
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 [marketingautomationuser] WITH PASSW"
Password validation failed. The password does not meet Windows policy requirements because it is too short. http://go.microsoft.com/fwlink/?LinkId=178587 Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_SQL_EXECUTION_FAILURE.
Install-SitecoreConfiguration : Command C:\Program Files\iis\Microsoft Web Deploy V3\msdeploy.exe returned a non-zero exit code - (-1)
At C:\sitecore\install\installation.ps1:57 char:1
+ Install-SitecoreConfiguration @xconnectParams -Verbose
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Install-SitecoreConfiguration
[TIME] 00:01:25
Transcript stopped, output file is C:\sitecore\install\xconnect-xp0.180608 (2).log
Invoke-CommandTask : Command C:\Program Files\iis\Microsoft Web Deploy V3\msdeploy.exe returned a non-zero exit code - (-1)
At C:\Program Files\WindowsPowerShell\Modules\SitecoreInstallFramework\Public\Tasks\Invoke-WebDeployTask.ps1:36 char:2
+ Invoke-CommandTask -Path $Path -Arguments $msdeployArgs -TaskName ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Invoke-CommandTask
Error points to the line 57 of my installation.ps
which is last line below
$xconnectParams = @{
Path = "$PSScriptRoot\xconnect-xp0.json"
Package = "$PSScriptRoot\Sitecore 9.0.0 rev. 171002 (OnPrem)_xp0xconnect.scwdp.zip"
LicenseFile = "$PSScriptRoot\license.xml"
Sitename = $XConnectCollectionService
XConnectCert = $certParams.CertificateName
SqlDbPrefix = $prefix
SqlServer = $SqlServer
SqlAdminUser = $SqlAdminUser
SqlAdminPassword = $SqlAdminPassword
SolrCorePrefix = $prefix
SolrURL = $SolrUrl
}
Install-SitecoreConfiguration @xconnectParams -Verbose // Line # 57
It has nothing to do with my SQL password. My SQL Server password is very complex. It have tried several complex passwords. It is trying to create a user from what i see and fails there
"CREATE USER [marketingautomationuser] WITH PASSW"
sitecore91234###9900
as a password? – Mark Cassidy♦ Jun 8 '18 at 10:16admin1234##9900
– Sallu Jun 8 '18 at 10:19