Share Sql Database file

Question

I have developed a c# application and used sql server 2008 r2 for database. Now I want to do is install this application and SQL Server 2008 in a shared folder in PC1 and access this application from PC2. But use same single database in PC1. (When data inserted to c# application from PC2, data saved in database in PC1.)

This is a Users Information Handling System. Receipt print option also available in this application. PC1 and PC2 both are connected through LAN. How to Use Sql DataBase File At Time two or more user.

Krishna Rajput Singh · Answer

Hello parvez khan thanks for writing fistly when you install SQL SERVER then you need to create database in .mdf file after that when you developed your window application and deploy your application exe file need to add .mdf file its use same database use your apps to another pc below linbks for how to install sql server http://www.codeproject.com/Articles/305113/How-to-Install-SQL-server-on-Windows https://blogs.msdn.microsoft.com/bethmassi/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010/ http://www.c-sharpcorner.com/UploadFile/ff0d0f/sql-server-2008-installation-step-by-step/ if find answer as helpful mark as correct.

Shubham Kumar · Answer

if your system on LAN so its not a problem just provide the ip address to pc1 where your db is installed and access through other ip address in other pc and don't worry about multi user access db at same it db handle it.