Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

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 (http://support.microsoft.com/default.aspx?scid=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

 
discard

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.