Q:

Installations on client connecting to remote SQL server

I wrote a C# application that connects to a SQL server.
I want to run this application on different computers (clients) in my network and make them connect to one central SQL server remotely.
I installed SQL Server 2008 only on the central computer, not on the clients.
The clients operating system will be Windows 7, 8 or Server 2012.
Should I need to install anything on the clients running my application in order to be able to connect to the SQL server? should I add DLLs to my application? or will it work naturally without problems?

A:

You can connect naturally to your clients, you need just to check some basic network things like firewalls,etc. And make sure that your sql server is configured to accept remote connetions check this link to see how to do this
http://support.microsoft.com/kb/914277#method2
if you have some doubt about how to write the connection string to connect to your server, you can use this site to help you:
http://www.developerfusion.com/tools/sql-connection-string/

