Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just set up a new server with SQL Server Express 2005, and I want to connect remotely.

  1. I set both Windows and SQL logins.
  2. I modified so both local and remote connections are allowed.
  3. I restarted the server.
  4. Windows firewall is not connected; I have an external firewall with a hole at port 1443.
  5. 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.

share|improve this question

Did you add the user as a SQL login?

share|improve this answer
yes I did that ofcourse :) – user2659 Dec 8 '09 at 12:31

Here is the Microsoft 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!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.