just setup a new server with sql server express 2005. (want to connect remotely)
- I set logins both windows and sql
- I modified so both local and remote connections are allowed
- I restarted the server
- windows firewall is not connected. (have an external firewall with a hole at port 1443)
- 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.