sql user not associated with a trusted connection
- by homestead
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.