Connection to the mdf problem after installation

Question

0.00/5 (No votes)

See more:

I have a problem with connecting to my local database file after installation this is my connection string

C#

private const string constr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\HuskyCenter.mdf;Integrated Security=True";

before I didn't have this problem and now I don't know what is happening when I install my app on my pc or another pc this what it will show below

https://prnt.sc/wef1e3[^]

What I have tried:

I have tired to change the connection string but it got worse so I didn't do anything else

Posted 1-Jan-21 13:47pm

Member 15035289

Updated 4-Jan-21 20:01pm

thatraja

v2

Add a Solution

Comments

PIEBALDconsult 1-Jan-21 19:52pm

Is the PC running in a domain? Is ;Integrated Security=True correct for it?

Member 15035289 1-Jan-21 19:55pm

I'm making an offline app, so in VS there is no problem connecting to the mdf file
but after installation, I have this problem, before I start finishing my project I tested it and it worked fine on my main pc and my other pc but now I cant connect to the mdf file on both

Dave Kreskowiak 1-Jan-21 22:12pm

Does the machine have SQL Server installed on it?

CHill60 4-Jan-21 12:04pm

Do you have somewhere

AppDomain.CurrentDomain.SetData("DataDirectory", "C:\...");

where the ... is the folder containing your .MDF?

1 solution

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)

thatraja · Answer 1 · 2021-01-04T20:00:00

Always include the error message instead of screenshot. Some people can't access those sites at workplace. Anyway this will fix the issue

Deployment of SQL Express LocalDB on IIS | Microsoft Docs[^]
Other fixes
asp.net mvc - The specified LocalDb instance does not exist - Stack Overflow[^]
c# - SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance - Stack Overflow[^]