Can't create an EPiServer MVC project within VS2012 - Password Policy Error

dga
dga
Vote:
 

Hi Folk!

When I create a new EPiServer MVC project within Visual Studio 2012 I get following error:

At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\System Scripts\Install Database (SqlServer).ps1:170 char:20
+ Add-EPiSqlSvrUser <<<< -SqlServerName $wizard.Database.DatabaseServerName -SqlServerPort $wizard.Database.DatabaseServerPort -DatabaseName $wizard.Database.DatabaseName -LoginName $wizard.Database.InstallerDatabaseLoginName -LoginPassword $wizard.Database.InstallerDatabaseLoginPassword -UserName $wizard.Database.ProductDatabaseLoginName -UserPassword $wizard.Database.ProductDatabaseLoginPassword
System.Data.SqlClient.SqlException (0x80131904): Password validation failed. The password does not meet Windows policy requirements because it is too short.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at EPiServer.Install.SqlServer.Installers.AddDatabaseUserInstaller.Install(IDictionary stateSaver)
at EPiServer.Install.Common.AppDomains.NonTransactedSqlInstaller`1.Install()
at EPiServer.Install.Common.AppDomains.NonTransactedSqlInstaller`1.Install()
at EPiServer.Install.Common.AppDomains.RunInAppDomainInstaller.Install(IDictionary stateSaver)
at EPiServer.Install.InstallationManager.Install(Installer installer)
at EPiServer.Install.SqlServer.SqlServerInstallationManager.AddNonTransactedSqlInstaller[T](Object[] constructorParams)
at EPiServer.Install.SqlServer.SqlServerInstallationManager.AddDatabaseUser(String sqlServerName, Nullable`1 sqlServerPort, String databaseName, String loginName, String loginPassword, String userName, String userPassword)
at EPiServer.Install.SqlServer.Cmdlets.AddDatabaseUserCmdlet.ProcessRecord()
at System.Management.Automation.Cmdlet.DoProcessRecord()
at System.Management.Automation.CommandProcessor.ProcessRecord()
ClientConnectionId:e3ef3fae-d4ed-47fa-bc2e-59f9f5e3abef

The password policy, which is enforced by my company, requires a 12 character password and I haven't got the privilege to change it.

I think that the error comes from following reason:

# need to generate a random password for the db user
$wizard.Database.ProductDatabaseLoginPassword = Get-EPiRandomPassword -PasswordLength 10

Since 10 < 12 = Password policy is violated!

How can I fix that?

Thank you for your valuable help!

Cheers,

Daniel

#64074
Dec 10, 2012 15:35
Vote:
 

Hi Daniel,

You could just change the line to be 12 instead and remove the signing hash from the script. Then lower the allowed script threshold for powershell scripts on your machine (Set-ExecutionPolicy Unrestricted). Rerun the installation then set the allowed level back up (Set-ExecutionPolicy Restricted)

#64080
Dec 10, 2012 16:19
dga
Vote:
 

Hi

I have tryied what Petter proposed and I still get following error:

At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\System Scripts\Instal
l Database (SqlServer).ps1:170 char:20
+ Add-EPiSqlSvrUser <<<< -SqlServerName $wizard.Database.DatabaseServerName
-SqlServerPort $wizard.Database.DatabaseServerPort -DatabaseName $wizard.Databa
se.DatabaseName -LoginName $wizard.Database.InstallerDatabaseLoginName -LoginPa
ssword $wizard.Database.InstallerDatabaseLoginPassword -UserName $wizard.Databa
se.ProductDatabaseLoginName -UserPassword $wizard.Database.ProductDatabaseLogin
Password

True
=
Get-EPiIsBulkInstalling

An unhandled error has occured:
Password validation failed. The password does not meet Windows policy requireme
nts because it is too short.
When executing

At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\System Scripts\Instal
l Database (SqlServer).ps1:170 char:20
+ Add-EPiSqlSvrUser <<<< -SqlServerName $wizard.Database.DatabaseServerName
-SqlServerPort $wizard.Database.DatabaseServerPort -DatabaseName $wizard.Databa
se.DatabaseName -LoginName $wizard.Database.InstallerDatabaseLoginName -LoginPa
ssword $wizard.Database.InstallerDatabaseLoginPassword -UserName $wizard.Databa
se.ProductDatabaseLoginName -UserPassword $wizard.Database.ProductDatabaseLogin
Password


At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\System Scripts\Install Database (SqlServer).ps1:170 char:20
+ Add-EPiSqlSvrUser <<<< -SqlServerName $wizard.Database.DatabaseServerName -SqlServerPort $wizard.Database.DatabaseServerPort -DatabaseName $wizard.Database.DatabaseName -LoginName $wizard.Database.InstallerDatabaseLoginName -LoginPassword $wizard.Database.InstallerDatabaseLoginPassword -UserName $wizard.Database.ProductDatabaseLoginName -UserPassword $wizard.Database.ProductDatabaseLoginPassword
System.Data.SqlClient.SqlException (0x80131904): Password validation failed. The password does not meet Windows policy requirements because it is too short.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at EPiServer.Install.SqlServer.Installers.AddDatabaseUserInstaller.Install(IDictionary stateSaver)
at EPiServer.Install.Common.AppDomains.NonTransactedSqlInstaller`1.Install()
at EPiServer.Install.Common.AppDomains.NonTransactedSqlInstaller`1.Install()
at EPiServer.Install.Common.AppDomains.RunInAppDomainInstaller.Install(IDictionary stateSaver)
at EPiServer.Install.InstallationManager.Install(Installer installer)
at EPiServer.Install.SqlServer.SqlServerInstallationManager.AddNonTransactedSqlInstaller[T](Object[] constructorParams)
at EPiServer.Install.SqlServer.SqlServerInstallationManager.AddDatabaseUser(String sqlServerName, Nullable`1 sqlServerPort, String databaseName, String loginName, String loginPassword, String userName, String userPassword)
at EPiServer.Install.SqlServer.Cmdlets.AddDatabaseUserCmdlet.ProcessRecord()
at System.Management.Automation.Cmdlet.DoProcessRecord()
at System.Management.Automation.CommandProcessor.ProcessRecord()
ClientConnectionId:291955a2-4763-4e57-b671-9dd03b6f9d52

Does anybody else have an idea where the error comes from?

Cheers,

Daniel

 

#64314
Dec 17, 2012 16:23
Vote:
 

Doesn't the wizard (at least in deployment center) allow you to select the account to use with the database? In that case you can create an account manually from SQL Management Studio and select that account to use with your database instead of letting deployment center create a new one. When you create accounts in management studio you can set any password length required and even override the password policy to set a shorter password than it requires.

#64475
Dec 21, 2012 9:13
Vote:
 

Hello, I am getting below error message while installaing EPiServer CMS 7.0.586.1

Database used - SQL Server 2008 Advanced Version

Can you please help?

EPiServerInstall Verbose: 0 : Executing database script "C:\Program Files\EPiServer\Framework\7.0.859.1\Database\sql\EPiServer.Data.sql",
EPiServerInstall Verbose: 0 : Progress Status: Activity:Installing Description:Installing,
EPiServerInstall Verbose: 0 : Progress Status: Activity:Installing Description:Installing,
EPiServerInstall Verbose: 0 : Progress Status: Activity:Installing Description:Installing,
EPiServerInstall Verbose: 0 : Executing database script "C:\Program Files\EPiServer\CMS\7.0.586.1\Database\MSSQL\EPiServerRelease70.sql",
EPiServerInstall Verbose: 0 : Progress Status: Activity:Installing Description:Installing,
EPiServerInstall Warning: 0 : An error has occured and the transaction will be rolled back,
EPiServerInstall Warning: 0 : Error dropping database user 'dbUserExampleEPiServerSite'. Please drop manually.,
EPiServerInstall Warning: 0 : Cannot open database "dbExampleEPiServerSite" requested by the login. The login failed.
Login failed for user 'pcname\username'.,
EPiServerInstall Warning: 0 : Rolledback,
EPiServerInstall Verbose: 0 : ,
EPiServerInstall Verbose: 0 : An unhandled error has occured:,
EPiServerInstall Verbose: 0 : Password validation failed. The password does not meet Windows policy requireme,
EPiServerInstall Verbose: 0 : nts because it is too short.,
EPiServerInstall Verbose: 0 : When executing,
EPiServerInstall Verbose: 0 : ,
EPiServerInstall Verbose: 0 : At C:\Program Files\EPiServer\CMS\7.0.586.1\Install\System Scripts\Install Data,
EPiServerInstall Verbose: 0 : base (SqlServer).ps1:170 char:20,
EPiServerInstall Verbose: 0 : + Add-EPiSqlSvrUser <<<< -SqlServerName $wizard.Database.DatabaseServerName ,
EPiServerInstall Verbose: 0 : -SqlServerPort $wizard.Database.DatabaseServerPort -DatabaseName $wizard.Databa,
EPiServerInstall Verbose: 0 : se.DatabaseName -LoginName $wizard.Database.InstallerDatabaseLoginName -LoginPa,
EPiServerInstall Verbose: 0 : ssword $wizard.Database.InstallerDatabaseLoginPassword -UserName $wizard.Databa,
EPiServerInstall Verbose: 0 : se.ProductDatabaseLoginName -UserPassword $wizard.Database.ProductDatabaseLogin,
EPiServerInstall Verbose: 0 : Password ,
EPiServerInstall Verbose: 0 : ,
EPiServerInstall Verbose: 0 : True,
EPiServerInstall Verbose: 0 : =,
EPiServerInstall Verbose: 0 : Get-EPiIsBulkInstalling,
EPiServerInstall Verbose: 0 : ,
EPiServerInstall Verbose: 0 : An unhandled error has occured:,
EPiServerInstall Verbose: 0 : Password validation failed. The password does not meet Windows policy requireme,
EPiServerInstall Verbose: 0 : nts because it is too short.,
EPiServerInstall Verbose: 0 : When executing,
EPiServerInstall Verbose: 0 : ,
EPiServerInstall Verbose: 0 : At C:\Program Files\EPiServer\CMS\7.0.586.1\Install\System Scripts\Install Data,
EPiServerInstall Verbose: 0 : base (SqlServer).ps1:170 char:20,
EPiServerInstall Verbose: 0 : + Add-EPiSqlSvrUser <<<< -SqlServerName $wizard.Database.DatabaseServerName ,
EPiServerInstall Verbose: 0 : -SqlServerPort $wizard.Database.DatabaseServerPort -DatabaseName $wizard.Databa,
EPiServerInstall Verbose: 0 : se.DatabaseName -LoginName $wizard.Database.InstallerDatabaseLoginName -LoginPa,
EPiServerInstall Verbose: 0 : ssword $wizard.Database.InstallerDatabaseLoginPassword -UserName $wizard.Databa,
EPiServerInstall Verbose: 0 : se.ProductDatabaseLoginName -UserPassword $wizard.Database.ProductDatabaseLogin,
EPiServerInstall Verbose: 0 : Password

thanks,

Saurabh

#66315
Feb 27, 2013 7:46
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.