SQLTeam.com | Weblogs | Forums

Access SQL Server From Multiple Computers


I want to create my Sql Server Database on a central computer, and access that from multiple computers by using C# based application. Kindly help me out to resolve this.



This is the normal way in which most SQL Server installations are used, so you are not doing anything unusual. The basic steps are:
a) make sure that remote access is enabled on the SQL Server. See here: https://msdn.microsoft.com/en-us/library/ms191464.aspx

b) Connect from your C# code using the appropriate connection string. See here http://www.connectionstrings.com/

You can search the web for tutorials on how to set up your scenario and you will find a lot many.