Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-localdb]

SQL Server 2012 Express LocalDB is local database that is come along with the SQL Server 2012 installation, it can be used for developers to work out with SQL Server 2012.

38 questions
267
votes
14 answers

How to connect to LocalDB in Visual Studio Server Explorer?

I can't believe I couldn't find a working solution to this after an hour of searching. I'm following this article on Entity Framework 6.0 which gives a simple walk-through on Code First. I created the project and installed the latest EF Nuget…
orad
  • 15,272
  • 23
  • 77
  • 113
12
votes
1 answer

LocalDB does not starts correctly for IIS worker process

When I deployed MVC application on IIS then localDB databse is not starting correctly. Error message is as follows: Windows API call WaitForMultipleObjects returned error code: 575. Windows system error message is: {Application Error} The…
Gyanendu Shekhar
  • 121
  • 1
  • 5
10
votes
3 answers

How to add username and password in sqllocaldb

I am going to start work on new Desktop application. There is I want to use light weight and standalone database so that I am going use SQL LocalDB but I want to add authentication. There I need username and password before accessing database but…
Satnam singh
  • 205
  • 2
  • 3
  • 9
3
votes
1 answer

Replace SQL Compact with SQL LocalDB on client machines with Integrated Security = False

Microsoft has deprecated SQL Compact so I would like to replace this with SQL LocalDB on client machines. When using "Integrated Security = True" the replacement works fine on the client machines but once I set "Integrated Security = False" then I…
goroth
  • 2,510
  • 5
  • 35
  • 66
2
votes
0 answers

LocalDB Separate Install Connection String

Our tool uses SQL Server 2012 LocalDB to store data. This as installed by the MSI, not full express. Users recently moved to new machines using other applications that connect via SQL Server 2019. My understanding is that installing SQL Server…
user
  • 1,261
  • 2
  • 21
  • 43
2
votes
1 answer

ClickOnce installer fails to install SQLLocalDb2012 because sqlcmdnutils.msi has changed since originally published

ClickOnce previously had installed SqlLocalDB2012 with no issues but now I get this error when trying to install. No issues if just updating the app from a previous version but I get this error everytime on a fresh install. Not sure what has…
Braden Cross
  • 31
  • 3
2
votes
1 answer

Why can I not connect to SqlLocalDB?

I craete and start a SqlLocalDB-Instance with C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe c proconact -s when I run C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe info proconact I get Name: …
BennoDual
  • 5,865
  • 15
  • 67
  • 153
2
votes
0 answers

InstallShield Express - create and start LocalDb instance during install

I'm using InstallShield Express in a Visual Studio 2015 WPF solution that uses LocalDb. What is the best way to get the InstallShield installer to create and start a LocalDb instance? I was thinking a batch file or some way for it to execute the…
Josh Bula
  • 373
  • 4
  • 16
2
votes
2 answers

Is it possible to have a relation where the foreign key is also the primary key?

I have a table in a SQL database which should have a relation with one of two tables, but not both. My manager solved it by using the ID field of the table Competitor as both primary key and as foreign key for the two other tables. None of the…
kajac
  • 128
  • 1
  • 5
2
votes
1 answer

Can I reuse database file of localdb in Express editions

I am going to build a small application and like to use SQL Server LocalDB, but I'm confused about some points When I start my instance and shared it in main PC and connecting to my database, does anyone on my local network can see this…
Hasan Yusuf
  • 33
  • 3
1
vote
0 answers

Local System cannot connect to LocalDB 2012 on Windows 2012

Scenario: Installed LocalDB 2012 64bit on Win2012 Wix Installer installs a 64bit Window Service with its own DB The service cannot connect to the LocalDB The error in the app's log is: "A network-related or instance-specific error occurred while…
Doug Dawson
  • 1,254
  • 2
  • 21
  • 37
1
vote
1 answer

What's the difference between a parameter and a variable in SSIS 2012?

This is an interview question. "What is difference between Parameter and variable in SSIS 2012?" I am confused about what the actual difference is between them.
Gajanan
  • 45
  • 1
  • 6
1
vote
1 answer

Unable to connect to localdb on Visual Studio 2013 using angular-js

I'm following this tutorial : http://chsakell.com/2015/08/23/building-single-page-applications-using-web-api-and-angularjs-free-e-book/ And below is the connection string:
Richard77
  • 20,343
  • 46
  • 150
  • 252
1
vote
0 answers

Change SQL Server Express LocalDB Database Structure in Visual Studio Project

I have a VS2013 project (WPF, C#), that has a .mdf database file that I use for the application. I'm using SQL Server 2012 Express LocalDB. I'm using Entity Framework 6. I created the DB in the project by Add New Item -> Service-based Database. I…
7VNT
  • 41
  • 8
1
vote
1 answer

Cannot connect to SQL LocalDB on Build Server

My tests were locally working against Local DB using the (localdb)\v11.0 instance when a teammate mentioned we're all on version 12 now and some people on the team might not have v11. The build server was working fine. So I changed the connection…
Luke Puplett
  • 42,091
  • 47
  • 181
  • 266
1
2 3