Cannot connect to SQL server when installing software in Win7 Solution

When installing the software, the default access SQL server account is sa, and Management Studio Express is logged on by default using Windows identity authentication. The sa account is found in the Login directory of the system default instance Security, check that it was the default Administrator Account of SQL server, and many security vulnerabilities are said to have occurred. Since it is only used locally, you don't have to consider that much.

Open Management Studio Express with administrator permissions. At this time, you cannot log on with an SQL account. After logging on with Windows identity authentication, right-click the SQL server name under the instance, select Properties, and click Security on the left, change Win authentication to SQL Server and Windows hybrid identity authentication, so that you can log in with the SQL server account, but the individual account has not set whether it can log on.

Find the sa account under the instance, Security directory, and Login subdirectory, open its attributes, change its password, enable the Login attribute, and save and exit.

Use the SQL Server 2005 peripheral application configurator to restart the SQL Server service. During this installation, enter the user name sa and the new password, which is unobstructed ~