MicrosoftSQLServerManagementStudioExpress uses SQL to verify Login

Set MicrosoftSQLServerManagementStudioExpress to use SQL to authenticate Logon (for example, when using SQL to authenticate logon for many sa users who use SQLServer2005Express for the first time, for example, an error occurs when using the sa account. The solution is as follows, select properties from the menu. The following dialog box is displayed:

Set Microsoft SQL Server Management Studio Express to use SQL to verify Logon (for example, when using SQL to verify logon, for example, an error occurs when using the sa account to log on to SQL Server 2005 Express for many sa users for the first time, solution: Right-click the server and select Properties from the menu. The following dialog box is displayed:

Set Microsoft SQL Server Management Studio ExpressUseSQLVerifyLogin(For exampleUseSa user

Many initialUseSQL Server 2005 Express friends,UseSQLVerifyFor exampleUseAn error occurred while logging on to the sa account. The solution is as follows:

Right-click the server and select "properties" from the menu ". The following dialog box is displayed. Select "SQL Server and Windows identity ".VerifyMode ".

ThenLogin(Provider: named pipeline provider, errror: 0-there is no process on the other end of the pipeline .) (Microsoft SQL Server, error: 233)

Solution: Open "start-all programs-Microsoft SQL Server 2005-Configuration tool-SQL Server Configuration Manager", and find "SQL Server 2005 network configuration" in the pop-up window ", enable "Named Pipes" and "TCP/IP" under "MSSQLSERVER protocol", and then restart SQL Server.