Share Sql Database file

parvez khan

10y1.1k

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.

2 Replies

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

Krishna Rajput Singh10y ago
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.
0
Shubham Kumar10y ago
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.
0