Change SQL Server Express authentication mode
When you install SQL Server Express you can select the authentication mode. If you want to enable SQL Server authentication mode (username and password) later on, you can use T-SQL to do it:
ALTER LOGIN sa ENABLE;
GO
ALTER LOGIN sa WITH PASSWORD = '<strong password>';
GO
LinkedIn profile
@jpalomaki
me@stackoverflow
juhap@github
juhap@iki.fi