Workarounds for SQL Server 2008 error 233

Issue one, forgot login password for the SA that logged on to Microsoft SQL Server 2008

Workaround: Log in with Windows Authentication first, then in ' security '-' login '-right-click on ' sa '-' properties ' and change the password to click OK.

Problem two, the connection to the server has been successfully established, but a mistake occurred during the logon process. (Provider: Shared Memory provider, no process on the other end of the error:0-pipeline.) ) (Microsoft SQL Server, error: 233)

WORKAROUND: Open ' programs '-' All Programs '-' Microsoft SQL Server 2008 '-' Configuration Tools '-' SQL Server Configuration Manager ', in the popup form, locate ' SQL Server 2008 network configuration ', put ' MSSQLServer the protocol ' Named Pipes ' and ' TCP/IP ' start, and then restart Microsoft SQL Server 2008.

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

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

Workarounds for SQL Server 2008 error 233