VB application connection wirh SQL server 2000

I have develop an application in VB6, this application connects sqlServer 2000 through ODBC. the problem is that when we run applicaiton from the computer where database resides, its works. but if we run application from different comupter (within the LAN), it does not work and raise following error.

Connection failed
SQL State '01000'
SQL Server error 53
[microsoft][ODBC SQL Server Driver][DBNETLIB]connection open
Connection failed
SQL State '08001
SQL Erro 17
[microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Please advise any help.

Thanks and best regards.
Imran