sql user not associated with a trusted connection

Posted by homestead on Server Fault See other posts from Server Fault or by homestead
Published on 2009-12-08T03:16:23Z Indexed on 2010/03/23 16:03 UTC
Read the original article Hit count: 205

Filed under:

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.

© Server Fault or respective owner

Related posts about sql-server-2005