Questions tagged [sql-server-localdb]
SQL Server localdb is an edition of SQL Server Express without server installation. Application developers can use it to distribute a database with their applications without requiring the user to install a SQL Server engine
49
questions
40
votes
4
answers
16k
views
LocalDB v14 creates wrong path for mdf files
Recently, I upgraded LocalDB from version 13 to 14 using the SQL Server Express installer and this instruction. After the installation, I stopped the existing default instance (MSSQLLOCALDB) of ...
18
votes
1
answer
21k
views
Connect to LocalDB via SQLCMD in PowerShell
I'm trying to access the "localdb\MSSQLLocalDB" server on my computer through PowerShell with the SQLCMD utility. I'm using PowerShell v5, .NET v5.0, and the server name is (localdb)\MSSQLLocalDB when ...
17
votes
10
answers
81k
views
Cannot start SqlLocalDB instance with my Windows account
I'm the administrator and simply run the command:
sqllocaldb start v11.0
Result:
Start of LocalDB instance "v11.0" failed because of the following error:
Error occurred during LocalDB instance ...
16
votes
3
answers
35k
views
Where to download SQL Server 2019 Express LocalDB Installer MSI from
SQL Server 2019 is released but I there doesn't appear to be a LocalDB version available for download. Does anyone know if there will be a LocalDB release or if 2017 is the last version?
13
votes
1
answer
13k
views
Move folder of SQL Server LocalDB instances from the default location
I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping ...
10
votes
1
answer
37k
views
How do I connect to localDB from SQL Server 2014 Express
I downloaded both the LocalDB and Management Studio for MS SQL Server 2014 Express so that I can practice on my local machine. However, when I open Management Studio and try to browse to localDB to ...
10
votes
3
answers
4k
views
Should developers be allowed to use LocalDB vs a "development" instance?
Much like the vein of the question that was posted here previously around "Should developers be able to query production databases?" I wanted to get your thoughts on another particularly annoying ...
9
votes
1
answer
10k
views
Error starting localDb on Windows 11
I installed Windows 11 on a brand new NUC, then installed all updates. Installed Visual Studio 2022 CE and SSMS (v 18.10)
I attempted to start the localDB which is assume was installed as part of ...
8
votes
4
answers
1k
views
Does LocalDB support temporary tables?
Are SQL Server temporary tables (prefixed with #) supported in LocalDB instances?
7
votes
3
answers
4k
views
Can't connect to SQL Server 2017 Local DB shared instance
I cannot connect to a SQL Server 2017 (14.0.1000.169) Local DB shared instance.
I tried on a laptop that previously had some SQL Server Express and stuff that I all have uninstalled. And also on a ...
7
votes
1
answer
1k
views
What is the migration/deployment path from a LocalDB solution to Enterprise instance?
Given the extant definition for SQL Server 2012's LocalDB as
SqlLocalDB is a local, low-overhead database engine of SQL Server 2012
(and future versions) that allows developers to focus on ...
6
votes
2
answers
8k
views
Access SQL Server Express LocalDB from Local Area Network
I am developing a software which requires SQL Server. But for a 50MB application it is not a good idea to tell customers to install SQL Server. So I think it's better to use SQL Server Express LocalDB....
5
votes
2
answers
6k
views
DROP DATABASE statement cannot be used inside a user transaction
Not really sure if this question belongs here, but I hope someone could help me out.
I've made integration tests going all the way down to the database (using mssql localDB). I want each test to run ...
5
votes
2
answers
18k
views
Where is SQLCMD.EXE in SQL Server 2014 LocalDB or how to install it?
On a machine with SQL Server LocalDB 2014 installed I am looking for SQLCMD.EXE file but cannot find it anywhere. Is there a way how to install it separately?
Unfortunately I am not local admin of ...
4
votes
1
answer
1k
views
Is LocalDB installed independently of SQL Server?
I am a Developer. I thought LocalDB was installed as a component of Visual Studio, which could be used for development purposes. However, it appears to be installed independently of Visual Studio.
...