Ms SQL 2008 : A connection was succesfully established with the server, but then an error occured during the login process

Distraught and feel tired, kept me wondering for hours how to fix setup default 'sa' login id for MS SQL Server 2008 working on Windows 7, did you found this error 233 before?

Finally I found a solution how to fixed it. Win 7 was configured default ports to disable for example as :
1. Named Pipes
2. TCP/IP

What gonna do first is, make sure your Server authentication setting was set to "SQL Server and Windows Authentication mode" [Right click on server, select Server Properties -> Security ].

Next, set security folder, under logins for 'sa' right click and select properties choose Status. Under Setting, select 'Grant' for Permission to connect to database engine and select 'enable' for login as illustrated below:

Next, close your MS SQL Server 2008 and open Sql Server configuration manager.

Select protocols for SQL under Sql Server configuration manager and enable it 'Named Pipes' and 'TCP/IP' as illustrated  below.

Go to services.msc and start "SQL Server" Service, than open your Sql Server configuration studio and login as 'sa'.  It will work!

source library : ms sql server