Does SQL localdb 2012 works without installing SQL SERVER

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Hi All,

I am using SQL Server LocalDB, it is working in my system( I have Visual Studio 2015, SQL Server 2014 ).

But it is not working the production machine where there is no SQL server and Visual studio.

Does the SQL Local DB 2012 works by only installing SQLLocalDB 2012 or need to install any other support files ?

What I have tried:

Installed SQL LOCALDB 2012,

Connection string I used,
@"Data Source=(LocalDB)\v11.0;AttachDbFilename=" + Application.StartupPath + "\\DB\\DB.mdf;Integrated Security=True";

Db files are located wuth Name "DB" in the application folder

Posted 21-Sep-17 19:09pm

palraj001

Updated 21-Sep-17 19:19pm

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)

Mehdi Gholam · Answer 1 · 2017-09-21T19:19:00

Solution 1

Read this : Getting Started with SQL Server 2012 Express LocalDB[^]

Posted 21-Sep-17 19:19pm

Mehdi Gholam

Comments

palraj001 22-Sep-17 1:26am

Thanks for your reply. In client machine I have installed Local DB , I need my application has to work with the MDF files which is in my application folder. for this we need to install SQL Express ?

Mehdi Gholam 22-Sep-17 1:47am

No, the localdb install is sufficient.

palraj001 22-Sep-17 2:37am

Yes. But while access the SQL Connection I am getting following error in a new computer.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. ... Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error locating server/Instance Specified)

I have checked localDB instance , Its running state,

Mehdi Gholam 22-Sep-17 2:43am

LocalDB is meant to be used for local access (same machine), not network accessible from other machines.

palraj001 22-Sep-17 3:07am

I installed LocalDB in the Other machine too. I am connecting the DB located in the Same machine not in the network. is there any support file installed to use this SQLLOCALDB feature.

Mehdi Gholam 22-Sep-17 4:24am

check your connection string : https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/introduction/creating-a-connection-string

palraj001 23-Sep-17 0:54am

Hi,Thanks for your reply. Checked the connection strings. hope I am using the correct connection string. I am using this for windows application which is developed in VS2008. is there any limitation on VS2008 with SQL Local DB 2012? but In my development system its working fine.