The error for SQL Server 2005 Express I get now says:

"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 2 - Connection was terminated)"

I was using Windows authorization.

Any ideas on why this goofs up?