Allow SQL Compare Users to set the default password
When using SQL Compare and deploying a database to a new server, you may experience an error that "Password validation failed. This is caused by the password not meeting Windows policy requirements because it is too short". This is due to the default password generated by SQL Compare called 'p@ssw0rd' being 8 characters long. If your company has a policy for Windows passwords to be minimum of 9 characters, the deployment will fail as the default password does not meet the policy requirements.
Would SQL Compare Users like to set their default password for SQL Compare?
I realize this is 2 years old but is there any workaround on this issue? The use of the default password violates the Windows password policy on our CI server. As yet, I have not found a way to override the default password via a command-line option/etc.
Matt Brauchler commented
I'd even be happy with them to change p@ssw0rd to p@ssw0rdddd to get around length requirements for local laptops....etc.
Steven Isaacs commented
It would be really helpful to be able to set the password for users. This would allow all information needed to be contained and migrated with SQL Compare and no other additional scripts required to add/modify user information.