Use SQL Database Via LAN using C# Windows Form Application

Question

I have developed an desktop application in C# and sql server 2008 R2
now i want my application to be access by more than one user at the same time access database.
That is databse should be on 1 PC (server) and application will be installed on other PCs (clients ) all connected in a LAN.
Now I want all user from different PCs(clients) can access the DB (on SERVER) and perform CRUD operations.

Please decribe how it work?

Laxmidhar Sahoo · Answer

sir mr. Jitendra Shekhawat post a good thing. appart thet you can use remoting

Jitendra Shekhawat · Answer

try this.. https://www.youtube.com/watch?v=dEVIflBgny4

Prakash Mondal · Answer

any body Please describe with screen shot...any complete video link that will be very better for me.

Jitendra Shekhawat · Answer

https://blogs.msdn.microsoft.com/walzenbach/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008/

Jitendra Shekhawat · Answer

By default Remote connections in SQL Server Express is turned off. Just turn on the remote connections for SQL Express enable TCPIP protocal and restart the service check errorlog whether it's listening on all network adapters Now try to connect using the machine name (since it's dynamic) from the client pc here is a step Open SQL Server Configuration Manager Select SQL Server Network Configuration Chose your instance of SQL Server Make sure that TCP/IP protocol is enabledRight click TCP/IP protocol Select propertiesClick IP addresses tabScroll down to IP4. The IP address of the server should be here. Set active to yes and enabled to yes. Set TCP port to 1433 (don't know if this is necessary. Can some expert comment) Scroll down to IPAll. Set TCP port to 1433 Make an inbound firewall rule for port 1433 open sql server management studio right click server instance properties->connections-> allow remote connections. Security-> SQL Server and Windows Authentication moderestart sql server service restart sql server browser now use sql connection string COMPUTERNAME for E.g data source=COMPUTERNAME;database=databasename;user id=sa;password=pass; providerName=System.Data.SqlClient