SQL Server + Express mixed-mode logon settings

After the VS2005 is installed, you will have the SQL Server2005 Express Edition, and for ease of management, you need to install an Enterprise Manager that downloads Microsoft SQL Server Management Studio Express ( Download name: Sqlserver2005_ssmsee.msi). Because the default is to log on only in Windows System logon mode, the following configuration is required if you want to log in in mixed mode:

1: Open SQL2005 remote connection function

The Configuration tool->sql the server perimeter configuration-> service and the perimeter configuration of the connection-> open the Database engine node under SQLEXPRESS, select Remote Connection, and select "Use both TCP/IP and Named pipes ", after determining, restart the database service.

2: Login to Mixed mode

Open the manager, connect to the database with Windows, right-click Data Server-Properties, security, under Server Authentication, select SQL Server and Windows Authentication mode, and login audit to select failed and successful logins.

3: New user and password, similar to sql2000, do not introduce

This allows you to connect using a data connection string, such as (server=.\\sqlexpress;uid=sa;pwd= password; database= database name ")

If you connect in SQL Server mode, the error "has successfully established a connection to the server, but errors occurred during the logon process"

Expand Security on the server-> login name-> Select the sa login account (right)-> status-> login modified to enable.