sql user not associated with a trusted connection

Question

just setup a new server with sql server express 2005. (want to connect remotely)

1. I set logins both windows and sql
2. I modified so both local and remote connections are allowed
3. I restarted the server
4. windows firewall is not connected. (have an external firewall with a hole at port 1443)
5. user account is active, no password policy or forcing to change on next login etc.

If I even try to connect using this username locally on the server using 'file | connect to object explorer' I get the same message that the user is not associated to a trusted connection.

Answer 1

Did you add the user as a SQL login?

Answer 2

Here is the Microsoft KB (http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277)for connecting remotely using SQL Express 2005. I would say go through the exact steps as described just one more time to make sure nothing has been left out. Good luck and I hope it helps!