connecting over LAN

Aug 29 2006 4:30 AM
Hi,

I am trying to RUN windows application on one machine and connect/fetch Data from another machine(Running SQL server) in our LAN. I am using C# studio 2.0 and SQL server 2000.

Precisley speaking I am tring to Run the application on one machine and try to fetch the data from another machine. both machines are in our LAN.

But the connection is timed out and I am stucked. please let me know if there may be any solution for that.

My connection string is.

string sMyConString = "data source=xxx.xx.x.xxx;initial catalog=wtl;persist security info=False;user id=xxxx;password=xxxx;";

Any help,
Regards.