Can I use the multiple client one SQL mdf file at windows application

Question

0.00/5 (No votes)

See more:

I have the Windows Application also sql mdf file in project bin folder and i have the two user at control panel site i try to connect from one user that time switch user and connect with another user but same time only one user can use the windows application but try to connect another user same time it will be generate error like requested login is failed

What I have tried:

I put sql mdf file at bind folder i try to connect with two clients
i also Set in Sql Like security NT AUTHORITY NETWORK SYSTEM

Posted 4-Aug-17 20:54pm

Msufiyan Ansari

Updated 5-Aug-17 21:51pm

Add a Solution

4 solutions

Solution 2

Maybe this SQL Server tutorial will be of help to you: MS SQL Server Tutorial[^]
And this C# example: How to connect SQL Database to your C# program, beginner's tutorial[^]

Posted 5-Aug-17 9:54am

RickZeeland

Solution 4

Dear All
Now Error is Resolved I Change the Connection As Sql Server Base and Also Add the Client User in the Sql Server User then Also Apply Permission For Client User then Now it is working
Many Many Thanks All You
Thanks OriginalGriff At first time You Already Told the Solution it is Correct

Posted 5-Aug-17 21:51pm

Msufiyan Ansari

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2017-08-04T21:03:00

Solution 1

If you want multiuser access to the same database, then it is a very, very good idea to use SQL Server to manage the file and a very, very bad idea to access the .MDF file directly. You can do it using OleDb and releasing the database connection as soon as possible, but even then it generally gives horrible problems and I've never seen a good example - I have seen some horrible kludges and lash-ups though!

So connect the DB to SQL permanently, let SQL Server manage it completely, and change your app to use SqlCnnection, SqlCommand, and so forth.

Posted 4-Aug-17 21:03pm

OriginalGriff

Comments

Msufiyan Ansari 5-Aug-17 3:09am

Thanks Sir But What is the Solution is there

OriginalGriff 5-Aug-17 3:42am

Read what I said...

Msufiyan Ansari 6-Aug-17 3:52am

Dear All
Now Error is Resolved I Change the Connection As Sql Server Base and Also Add the Client User in the Sql Server User then Also Apply Permission For Client User then Now it is working
Many Many Thanks All You
Thanks OriginalGriff At first time You Already Told the Solution it is Correct

OriginalGriff 6-Aug-17 4:00am

You're welcome!

Dave Kreskowiak · Accepted Answer · 2017-08-05T10:37:00

Solution 3

To answer your question, you can NOT use the same MDF file in multiple instances of SQL Server Express or LocalDb at the same time. Only one instance can attach the file at a time.

Use a full SQL Server if you want more than one client to connect to the database at a time.

Posted 5-Aug-17 10:37am

Dave Kreskowiak

Comments

Msufiyan Ansari 6-Aug-17 3:52am

Dear All
Now Error is Resolved I Change the Connection As Sql Server Base and Also Add the Client User in the Sql Server User then Also Apply Permission For Client User then Now it is working
Many Many Thanks All You
Thanks OriginalGriff At first time You Already Told the Solution it is Correct