Stack Overflow
Stack Overflow

Questions tagged [sql-server-2014-localdb]

26 questions
20
votes
5 answers

Trying to attach mdf file to localDb throws error at least one file is required

TITLE: Microsoft SQL Server Management Studio Attach database failed for Server '(localdb)\mssqllocaldb'. (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION: At least one file is needed for Database Attach. (Microsoft.SqlServer.Smo) I am trying to…
Neeraj Sharma
  • 255
  • 1
  • 3
  • 11
5
votes
2 answers

How can I specify to use SQL Server LocalDb 2014 rather than SQL Server LocalDb 2016 in the connection string?

Our application uses SQL Server LocalDb 2014 as the database engine. The connection string we use is "Data Source=(localdb)\MSSQLLOCALDB;Initial Catalog=OurDatabase;MultipleActiveResultSets=True;Integrated…
Dabblernl
  • 15,831
  • 18
  • 96
  • 148
4
votes
1 answer

How to install SQL Server LocalDB with my application?

I have developed an application in vb.net 4.5 with VS2015 and I am using InstallShield Limited Edition to create the MSI installation file. Some of the final users don't have internet, so I need to include the SQLLocalDB.msi and install it…
GeorgeArrays
  • 125
  • 11
4
votes
3 answers

C# Sql LocalDB Application Slow Performance

I am completely new sql/database applications and am trying out a simple contact management applicaton using Visual Studio 2015 C#. I am using 'SQL Express LocalDB'. I have read on google that it is meant for development purpose, but microsoft also…
user5788383
3
votes
2 answers

SQL Server LocalDB instance fails to start (automatically)

I have a WPF application which is connecting to the SQL Server 2014 Express LocalDB (i.e. a local .mdf database file). The application uses the Entity Framework Core library version 7.0.0-rc1-final. This is the connection string that I am…
Oleg
  • 71
  • 1
  • 5
3
votes
1 answer

Change the default version of MSSqlLocalDB for Visual Studio 2015

I am working on a C# project with SQL Server. For development, we use LocalDB instance of SQL Server. If something is changed in the database, we check-in the .mdf/.ldf files into TFS. The connection is made using MSSqlLocalDB. The problem After…
Bimal
  • 350
  • 1
  • 7
  • 21
2
votes
0 answers

How to use a relative path when connecting to a (localdb) with SQLCMD?

ok, so we're using MS LocalDB as a database to power the regression tests on our app. we have a quite complicated schema and release profile so we use 'create db on attach' in C# code, then use SQLCMD to run our scripts to bring the db up to the…
matao
  • 636
  • 3
  • 14
  • 22
2
votes
1 answer

MVC - Context always uses the default connection string

I am looking to pick up MVC after previously working with web forms and I have been doing the movie tutorial over at asp.net but I am having an issue that is utterly confusing. I have 2 connection string in my web config: …
Craig
  • 19
  • 3
1
vote
1 answer

How do I enable? Full Text Search is installed in SQL Server 2014 Enterprise Edition but not enabled

How can I enable Full Text Search in SQL Server 2014. I've been searching the net for the last couple of hours, some posts about SQL Server 2012 said it's in the features during installation but I went there and I had no options to enabled it. I…
Sweendogg
  • 11
  • 1
  • 2
1
vote
0 answers

Integration Tests using localdb with Visual Studio Online Errors - 'contained database authentication' must be set to 1

I am using localdb for some Entity Framework repository integration unit tests. I have implemented a standard build configuration and after initial problems read that I should initialise and start the SQL Local DB. To that end I added the following…
NER1808
  • 1,829
  • 2
  • 33
  • 45
1
vote
0 answers

Does SQL Native Client come with SQL Server 2014 LocalDB?

Does the SQL Server Native Client come with SQL Server 2014 LocalDB? It is unclear due to https://msdn.microsoft.com/en-us/library/hh510202.aspx and https://msdn.microsoft.com/en-us/library/cc280510.aspx... Do we have install it separately and if…
NoWar
  • 36,338
  • 80
  • 323
  • 498
1
vote
2 answers

How to backup a SQL Server 2014 Express Localdb (.mdf) file programmatically

I have simple Windows application which uses SQL Server 2014 LocalDB (.mdf file). And I want that whenever users click exit button, my application automatically backup its localdb file (.mdf) to another folder in the same computer of users. I wrote…
Kay Lee
  • 922
  • 1
  • 12
  • 40
0
votes
0 answers

How can l group row data by date using window function?

In my code below the row data are not grouping into month by month name. I want to group row data of the same month. Date Revenue 2023-03-01 500 2023-03-29 300 2023-04-15 600 2023-05-11 300 2023-05-23 600 2023-05-31 500 SELECT …
User_K47
  • 49
  • 4
0
votes
0 answers

Is there a way to limit max memory utilization for SQL Express LocalDB 2014

I am using SQL Server Express LocalDB 2014. My application running with one dedicated instance. Like SQL Server though Management studio can we limit the max memory utilization of sql localDB? Or what is the threshold it can go max memory size?
user584018
  • 10,186
  • 15
  • 74
  • 160
0
votes
0 answers

Can't connect to SQLLocalDB sometimes when PC is offline

We are using SQLLocalDB to connect to a local database. No network access is required - C# Client application is on the same machine as SQLLocalDB. Sometimes I get the following error (only seems to happen on some…
Sugrue
  • 3,629
  • 5
  • 35
  • 53
1
2