how to connect to desktop application in other computer?

[nebrom]

i have developed desktop application that runs on local computer pc1. now i want to access it from other computers ( pc2 ,pc3,p4)connected in LAN network.
the database and software is installed in pc1 and working fine in there. now i want to install the software on pc2,pc3,pc4 so that i can access the data from pc1. how can i do that. i dont want to access using remote desktop,but i want to develop a client application that enables me to connect to pc1 or to the server.
my application is developed using ms sql 2008 and c#
thanks

[techgnome]

If it's SQL Server (there is no such thing as MS SQL) then it should be installed onto a SQL Server server... so that anyone can connect to it... then you just need to install the softwarde on the computers that will access it, and make sure the connection string is configured to point to the server... and that's it.

-tg

[nebrom]

thanks TechGnome.
i am using C# and ms sql 2008 express.
my database connection in the local pc1 is =pc1\sqlexpress.
this works fine in pc1, but how do i make it to access from the other computer, should i install the software with connection string of
ipAddressOfPc1\sqlexpress
or any solutions?
thanks again

[Blagojce]

You can access from other computer by their names or ips.
In SQL Server Configuration Manager enable TCP/IP or Named Pipes and start Sql Browser service to view sql server on pc1 from other computers.

Also you may need to allow sql port in firewall on pc1.