Hi
I have this major problem:

I used to use sql 7.0 with vb6 thru this line of code connection:
.ConnectionString = "Data Source=" & SQL_SRV & ";User ID=sa" & ";Initial Catalog= NorthWind" //no password

Through an executable file, i was able to run my program from different stations (LAN network; database sql at my station)

Lately, i shifted from 7.0 to sql 2005.
With the following line of code connection:
.ConnectionString = "Data Source=" & SQL_SRV & ";User ID=sa" & ";Password=****" & ";Initial Catalog= NorthWind"

or through windows authentication:
.ConnectionString = "Data Source=" & SQL_SRV & "; Initial Catalog=NorthWind; Trusted_Connection=yes"

if i run my executable file on my station, it works perfectly fine.
But when i try to run the executable file from any other station, the following occurs:

run-time error '-2147467259 (80004005)':

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Any clue where could be the problem?

Thanks

The following article has some good information about this error:

http://support.microsoft.com/kb/328306/en-us