MS SQL Server Error 233

Hi,
When I try to login to SQL Server 2005 from Microsoft SQL Server Management
Studio, I got following:
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: 233)
I use the "SQL Server authentication" mode and user name and password seems
correct.
I went to the "Surface Area Configuration for Services and Connections" and
check the "Remote Connections" under "Database Engine", it is "Using TCP/IP
only".
Also I checked "SQL Server Configuration Manager", under "SQL Server 2005
Network Configuration" -> "Protocols for MSSQLSERVER", "Shared Memory",
"Named Pipes" and "TCP/IP" are all "Enabled"
Please advise!
Thanks!
enable tcp/ip and you are good to go.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
sql