SQLServer2005 mixed-mode logon configuration (user logon error 18452,233,4064) _mssql2005

Error prompt: User logon failed, the user has no association with trusted SQL Server connection error 18452

The reason for this is that the remote login is not configured properly and the configuration is as follows:

1: Open SQL2005 remote connection function

The configuration tool->sqlserver the perimeter Application Configurator-> 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 to determine.

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

This allows you to connect using a data connection string, such as (server=localhost;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.

Second, forgot the login password for the SA that logged on to Microsoft SQL Server 2005

Workaround: Log in with Windows Authentication first, then in ' security '-' login '-right click ' sa '-' properties ', modify password (sa password can not be too simple, it is best to have numbers, letters, underscore characters, and the length of the best more than 10 characters); Click OK.

Third, the connection to the server was successfully established, but the error occurred during the logon process. (Provider: Shared Memory provider with no processes on the other end of the error:0-pipeline.) ) (Microsoft SQL Server, error: 233)

WORKAROUND: Open ' programs '-' All Programs '-' Microsoft SQL Server 2005 '-' Configuration Tools '-' SQL Server Configuration Manager ', and in the form that pops up, find ' SQL Server 2005 Network configuration ' and ' "Named pipes" and "TCP/IP" under MSSQLServer's protocol, and then restart Microsoft SQL Server 2005.

Four, unable to open the user default database. Login failed. User ' sa ' login failed. (Microsoft SQL Server, error: 4064)

Workaround: Log in with Windows Authentication first, and then in ' security '-' login '-right click ' sa '-' properties ', set the default database to master, and click OK.