Unable to create ContinuumDB on new Standalone system using SQL Express. SA password must be a strong password.

Issue

Pop-up error message displayed when trying to create ContinuumDB on stand-alone system. Unable to get past this to create the database.

Error message similar to below:

"Microsoft SQL Server 2005 Setup
The sa password must meet SQL Server password policy requirement. For strong password guidelines, see Authentication Mode, in SQL Server Books Online."
 

Product Line

Andover Continuum

Environment

Continuum Stand-alone

SQL Express

Cause

When SQLExpress was installed a "strong" SA password was not defined.

Resolution

  1. Download and install management studio express.
    http://www.microsoft.com/download/en/details.aspx?id=8961
  2. Change SA password so that it now complies as a strong password. (includes upper case, lower case, number, letter, minimum length of 8 characters)
    1. Find the SA user under Security\Logins.
    2. Change the Password.
  3. Run Database Initialization again and create the new database using this new SA password.