Use SQL Database Via LAN using C# Windows Form Application

Prakash Mondal

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?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo8y ago
sir
mr. Jitendra Shekhawat post a good thing.
appart thet you can use remoting
Jitendra Shekhawat8y ago
try this..

https://www.youtube.com/watch?v=dEVIflBgny4
Prakash Mondal8y ago
any body, Please describe with screen shot...any complete video link that will be very better for me.
Jitendra Shekhawat8y ago
https://blogs.msdn.microsoft.com/walzenbach/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008/
Jitendra Shekhawat8y ago
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"