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
As per Microsoft SQL password policy Strong passwords must meet the following guidelines:
- The password does not contain the account name of the user.
- The password is at least eight characters long.
- The password contains characters from three of the following four categories:
- Latin uppercase letters (A through Z)
- Latin lowercase letters (a through z)
- Base 10 digits (0 through 9)
- Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign (#), or percent (%).
Passwords can be up to 128 characters long. Use passwords that are as long and complex as possible.
To change the SQL password:
- Download and install management studio express.
http://www.microsoft.com/download/en/details.aspx?id=8961 - Change SA password so that it now complies as a strong password.
- Find the SA user under Security\Logins.
- Change the Password.
- Find the SA user under Security\Logins.
- Run Database Initialization again and create the new database using this new SA password.
