SQL Server - how to resolve the error 233 in sql sever 2005 in windows 7

 Hi Friends

 i m creating a new login using sql server authentication.

a new login is created.

when i m tring to login with sql server authentication there is an error

Cannot connect to (SERVER NAME) i.e name\sqlexpress

Additional Information:
"A connection was successfully established with the server, but then an error 
occurred during the login process. (provider: Shared Memory Provider, 
error: 0 - No process is on the other end of the pipe.) (Microsoft SQL 
Server, Error: 223)"

I hv already enabled all the protocols running as administrater. set authentication mode both windows and sql sever authentication

Pls pls help me in this regards

If you are getting this erro while connecting to sql express server then you need to make changes mentioned below.

1. Click on Start menu > Programs > Microsoft Sql Server > Configuration Tools
2. Select Sql Server Surface Area Configuration.
3.  Now click on Surface Area configuration for services and connections
4. On the left pane of pop up window click on Remote Connections and Select Local and Remote connections radio button.
5. Select Using both TCP/IP and named pipes radio button.
6. click on apply and ok.

here is good link for this
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

hope this will help you