how to connect a single SQL server database to two different C# WPF applications over the network

Question

i am developing an app where i am having a common sql server database .mdf put on a LAN Server which is needed to be connected to two or more different instances of a same application as other stations.

i am able to select the database but it is giving me and error posted below:

how to overcome this? the connection string is

connectionString = @"Data Source =(LocalDB)\MSSQLLocalDB; AttachDbFilename = " + path + "; Integrated Security = True; Connect Timeout = 30";

P.S. it is working when a single instance is connected to it and it is preventing the second or third app to use it.

any help will be appreciated.

Applications connect to the database, not the other way round. SQL Server isn't Access. LocalDB is a local embedded database, powered by SQL Server Express. Just use Express itself if you want multiple clients to connect — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jun 12, 2017 at 9:16

samithagun · Accepted Answer · 2017-06-12 09:21:45Z

2

You need to host the database on a network server. Several clients can connect to a SQL Server. But several clients cannot simultaneously connect directly to an MDF file.

The file alone cannot handle the concurrency. You need to have an application for it. That's where SQL Server comes into play.

After hosting, you need to change your connection string as well. Then it should work.

connectionString="Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=True;MultipleActiveResultSets=True"

edited Jun 12, 2017 at 9:21

answered Jun 12, 2017 at 9:13

samithagun

70311 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to connect a single SQL server database to two different C# WPF applications over the network

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related