Problem with SQL server in other computer

Question

0.00/5 (No votes)

See more:

Hello,

i have created a windows application in c# with sql database. i create a set up file, which is installed with no problems in my computer, but in other computer shows this messenge.

Unhandled exception has occumed in your application. lf you click Continue, the application will ignore this emor and attempt to continue. lf you click Quit, the application will close immediately A network-elated or instance-specific emor occumed while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is comect and that SQL Server is configured to allow remote connection provider: SQL Network Interfaces, emor: 52 nable to locate a Local Database Runtime installation. Verify that SQL Server Express is property installed and that the Local Database Runtime feature is enabled.)

What i have to do?? how can i fix it??

my connection string is this:

<add name="QFD_login.Properties.Settings.UsersDatabaseConnectionString" connectionstring="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\UsersDatabase.mdf;Integrated Security=True" providername="System.Data.SqlClient">

What I have tried:

i have tried to change v11.0 to v12.0 but when i did, i couldnt open the app either to my pc..

Posted 27-Nov-16 10:14am

Member 12856910

Updated 21-Dec-16 22:22pm

v2

Add a Solution

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)

Member 10062432 · Answer 1 · 2016-12-21T22:22:00

Solution 1

make sure you have SQL server runtime of same version as ur DB path describes and same goes for SQL database files, on the PC u wanna run your application(version conflict can also cause this).

if you have, then search "services.msc" in windows startup. and run it as administrator. locate your SQL Server service restart/start it.

Posted 21-Dec-16 22:22pm

Member 10062432

Comments

Muhammd Aamir 31-Dec-16 1:08am

i think you should need to change the connection string according to your other computer