I just set up a new server with SQL Server Express 2005, and I want to connect remotely.
- I set both Windows and SQL logins.
- I modified so both local and remote connections are allowed.
- I restarted the server.
- Windows firewall is not connected; I have an external firewall with a hole at port 1443.
- The user account is active and there is 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 with a trusted connection.