Select the Service tab and, using the arrow next to Start Mode, change the setting to Automatic. Select, Start – All Programs – Microsoft SQL Server 2012 – Configurations Tools – SQL Server Configuration Manager. it must contain both uppercase and lowercase letters and a numeric character.
Note: This password must be complex, i.e. During the installation of SQL Express, you will be prompted to select the authentication mode that the SQL Server will use for incoming connections.Select the Mixed Mode Authentication option and enter a password for the SQL Server administration (sa) user account.Note: The screen shots below are taken from a Microsoft SQL Server 2012 Express installation, but the method and configuration are also applicable when using SQL Server 2005, 2008, 2014, 2016 or 2017 Express.
If installing Microsoft SQL Server Express on Windows Server 2003, please ensure that you have applied the latest updates using Windows Updates. Configuration of Microsoft SQL Server Express and DNA installation requirements
