Instance Specific error in SQL LocalDB

Question

1.00/5 (1 vote)

See more:

I have a project that contains SQL localDB(v11.0).When I run on m PC it runs perfectly, but when I run it on other pc I get this error. I am Using Visual Studio 2013

--------------------------------------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance. See the Windows Application event log for error details.
--------------------------------------------------------------

My connection String in App.config file is
-----------------------------------------------------
connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\EMSDB.mdf;Integrated Security=True"
------------------------------------------------------------------------------

Posted 17-Feb-15 4:15am

A94

Updated 17-Feb-15 5:20am

v2

Add a Solution

Comments

John C Rayan 17-Feb-15 10:57am

Can you share more information with us like some code and the configuration details

A94 17-Feb-15 11:18am

Ok I improve my question

Richard Deeming 17-Feb-15 11:32am

Is LocalDB installed on the other PC? If not, download SqlLocalDB.msi from Microsoft[^] and install it.

A94 17-Feb-15 11:36am

But when deploying the application the database will also get installed (ie "EMSDB.mdf") and other related files that is required to run it. So, is SqlLocalDB required on other PC ?

Richard Deeming 17-Feb-15 11:53am

Yes, you have to install LocalDB on the computer, either using the standalone MSI file, or as part of SQL Express.
SQL Server 2012 Express LocalDB[^

3 solutions

Solution 2

You need to update your connection string to match whatever is installed on that server or change it to point back to your computer that does have SQL installed on it.

Posted 17-Feb-15 5:35am

ZurdoDev

Comments

A94 17-Feb-15 11:50am

Ok. but how to change the connection string that matches that version of SQL server. Also it is a standalone desktop application (ie my project)

ZurdoDev 17-Feb-15 11:53am

Is SQL installed on the PC that is getting the error?

A94 18-Feb-15 5:13am

no.

ZurdoDev 18-Feb-15 7:27am

Then the connection string needs to point to the server where SQL is installed. Or you have to install SQL on the machine.

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 · 2015-02-17T05:34:00

"LocalDB" means "on this computer" - so if you have moved your code to a different PC, then you need to change the connection string to refer to the computer with the production SQL server instance installed on it.

This should not be the computer you develop software on - never, ever test code against production databases, unless you really like looking for new jobs quickly - and you shouldn't automatically install SQL server on every PC with your software.

Richard Deeming · Accepted Answer · 2015-02-17T05:56:00

You need to install LocalDB on the computer which will be using it; you can't simply copy the files to the computer and run the application.

SQL Server 2012 Express LocalDB[^]

The primary method of installing LocalDB is by using the SqlLocalDB.msi program. LocalDB is an option when installing any SKU of SQL Server 2012 Express. Select LocalDB on the Feature Selection page during installation of SQL Server Express. There can be only one installation of the LocalDB binary files for each major SQL Server Database Engine version. Multiple Database Engine processes can be started and will all use the same binaries. An instance of the SQL Server Database Engine started as the LocalDB has the same limitations as SQL Server Express

Download the SQLLocalDB.msi file from the SQL Express download page[^] and install it on the target computer.

Instance Specific error in SQL LocalDB

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0