SQLTeam.com | Weblogs | Forums

Access SQL Server From Multiple Computers


#1

Hi,
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.

Thanks


#2

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.