Correct me if I'm wrong, you created the login name under the security node of the database, not in the security node of server? If that's the case AFAIK you should create the user into the server security also.
You should be able to connect from Management Studio Express so it's definitively a login/username/access permission problem. Please, check the following link and see if you can find a better explanation as to the cause of the error.
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspxEnmanuel
>Hello,
>
>The application and SQL 2005 Express are loaded on the same Vista Ultimate computer. Since I can connect using NT Authentication, I presume I ought to be able to connect using SQL Authentication provided the username and password are typed in correctly -- I have typed them several times and made sure to be carefull to type them correctly. TCP/IP is enabled.
>
>It seems as though I should be able to "TEST" the connection when I type in the username and password when I go to properties in the Server Node. Any idea why I error out in there? I am in SQL 2005 Express manager -- you would think I should be able to connect!
>
>Thanks for any other suggestions you might have,
>
>TFISHER
>
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain