Issues with SQL Server Express or MySQL when using WebMatrix or WebPI
by Chris Sfanos
The following article will grow to cover issues when using SQL Server Express or MySQL and WebMatrix or WebPI (Web Platform Installer)
Issue: The SA (SQL Express) or root (MySQL) password you entered (or have stored) is not valid
Error Message: The specified password for user account 'SA'/'root' is not valid or failed to connect to the database server
Potential solutions
The password you entered may not match the required security settings of SQL Express or MySQL. The following articles detail the password strength requirements:
- SQL Express: https://msdn.microsoft.com/library/ms161959.aspx
- MySQL: No complexity requirements
The password that WebMatrix or WebPI has stored does not match the database you are trying to connect to
- Delete the reg key that is storing the password (hashed) and try the install again
- Delete the mysql_pwd or sql_pwd key stored at HKCU\Software\Microsoft\WebPlatformInstaller
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for