SQL Server remote connection problem

I installed SQL Server 2005, and crated one user.

I am able to connect from the same systen, but while connecting from other开发者_如何学运维 system on the LAN it showing the error like below

login failed for the user xxxx. The user is not associated with a trusted sql server connection.

I googled the issue but nothing is sorted out for me. Even some posts on StackOverflow, where it mention to use SQL Server and Windows Authentication also didn't help.

---

Maybe there is an extra step you have to accomplish... Try to enable the TCP/IP trasport on the Configuration in SQL Server Surface Area Configuration.

This link can help you :

Configure MS SQL Server 2005

---

Try to set SQL Server and Windows authentication mode in server property. Enterprise Manager -> Right click on the server -> Properties -> tab Security -> Authentication: SQL Server and Windows authentication instead Windows Authentication mode