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
-1
votes
1
answer
27
views
How to find out what is adding a login trigger to my MSSQLLocalDB?
I keep having trouble with logging into (localdb)\MSSQLLocalDB. It gives the error:
Logon failed for login 'Domain\user' due to trigger execution.
Changed database context to 'master'.
Changed ...
0
votes
1
answer
28
views
Parallel access to LocalDb is not possible
I has a desktop program which uses MS sql LocalDb 2022. I realized when this program is running then SSMS 20.1 can not access the corresponding db.
use DbName
causes
"Operating system error 32: ...
0
votes
0
answers
68
views
Installing/Repairing SQL Server installation fails
I am installing a local instance of SQL Server.
During setup the database engine fails. What others steps can make sure the installation succeeds?
What I've tried:
Installing two times.
Repairing ...
0
votes
0
answers
120
views
SQLLocalDB audit to application/security log
Has anyone encountered an error that Sql Server LocalDb cannot start an audit aimed at the application log (or security log)?
it seems like problem only for the localdb instance.
sys....
2
votes
0
answers
315
views
What to do when can't find Microsoft SQL Server error explanation
Following this doc View or Change the Default Locations for Data and Log Files for SQL Server 2016. I am attempting a simple change of location for data/log/backup files in MSSM.
Connect in Object ...
0
votes
0
answers
228
views
Connection String requires AttachDbFilename property
I'm trying to use SQL Server LocalDb to store the database by connection string. During first connection to the database I have an error about connecting to the database. In SSMS it is opening. To fix ...
0
votes
0
answers
158
views
Windows server localdb issue
I'm trying to deploy a database to a Windows Server machine.
The database is a SQL Server LocalDB. When I deploy it to a Windows machine, everything works correctly. When I try to deploy the same ...
0
votes
0
answers
155
views
LocalDB build and Memory Optimized table types
We have a DevOps pipeline for our DB Build/Release process and we're using VS SQL Database projects. We have one DB which makes extensive use of memory optimized table variables. Used for transfering ...
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 ...
0
votes
1
answer
47
views
Detect what version of SQL Server Express engine is available before connection?
I would like to detect what version of SQL Server Express engine is available so that I can connect either to the (localdb)\v.11 (SQL Server 2012 per https://learn.microsoft.com/en-us/previous-...
0
votes
0
answers
2k
views
Local Postgres Server on Mac Pw Auth Fail
Disclaimer: I am new to MacOs. Haven't found any useful related question.
After successfully installing postgresql 13.2 via homebrew on MacOs 11.2.1 (BigSur) i run into the following problem:
Use ...
0
votes
2
answers
4k
views
Can no longer connect to localdb after updating from Sql Server 2016 to 2019
I need to restore a backup for an assignment, but SMSS said I was running v13 while the backup was made in v15. So I downloaded and installed SQL Server Express 2019 and uninstalled the older version.
...
0
votes
1
answer
1k
views
STRING_AGG Not Recognized on V15.0.2 of SQL Server LocalDB
I recently coded a stored procedure on SQL Server 2019 (14.0.3192.2) in AWS that utilized the function STRING_AGG with no issues. When I moved the code to my local test db it complained about that ...
2
votes
0
answers
221
views
Is there a way to prevent SQL Server resetting itself back to read-write mode?
I'm working on a desktop app which is installed along with a database, and then connects to the database using SQL Server LocalDB when a user runs the app. The workflow is:
When the app starts, it ...
1
vote
1
answer
2k
views
How to troubleshoot "Encryption not supported on the client OLE DB provider "SQLNCLI11" for linked server" error
We are using LocalDb for integration/unit testing of a .NET Core application. I have been using this solution for months and recently started getting sporadic errors. It seems to happen the first time ...
2
votes
1
answer
2k
views
SQL Server: localhost vs MSSQLLocalDB
I have two different local versions of SQL Server on my machine:
(localdb)\MSSQLLocalDB
localhost
I think one of them might have been installed alongside Visual Studio, but I am not sure. Is there a ...
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?
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 ...
0
votes
1
answer
1k
views
Install SQL Server 2017 over 2016 Local DB and 2012 native client
I have downloaded Microsoft SQL Sever 2017 and would like to install it. But just to be sure I checked installed applications and I found that there is:
Microsoft SQL Server 2012 native client
...
0
votes
2
answers
957
views
How to connect an MSSQL database engine to a local network
I need to let my public IP connect to a database that is located within the same local network.
Ex: MY public IP is: 190.222.222.222 The local IP of that PC is: 1.1.1.4 And this server already has an ...
8
votes
4
answers
1k
views
Does LocalDB support temporary tables?
Are SQL Server temporary tables (prefixed with #) supported in LocalDB instances?
0
votes
1
answer
5k
views
Installation of SQL Server Express LocalDB 2017 [closed]
I want to install Microsoft SQL Server LocalDB 2017 on my system. I downloaded SQL Server Express Setup (about 5.1 MB). Then I opened it and chose 'Download Media' option and then chose LocalDB. Then ...
3
votes
0
answers
2k
views
Cannot install SqlLocalDB 2016 on Windows 7 : FormatMessageW failed. Error code returned: 15101
I downloaded SqlLocalDB.msi (Microsoft SQL Server 2016 LocalDB) using SQLServer2016-SSEI-Expr.exe (version 13.1804.4031.1).
I installed it and whatever I try to do I get the following error:
C:\...
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 ...
1
vote
0
answers
1k
views
SqlLocalDB 2014 can not find SqlUserInstance.dll
Everytime I run the command: SqlLocalDB i get this error: SqlUserInstance.dll not found! Windows error code: 126.
I searched but I could not find anything on what to do. I repaired the ...
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.
...
-3
votes
1
answer
1k
views
Creating MDF tables using Visual Studio 2015
I'm using Visual Studio 2015. In Explore Server, I create a new DB.mdf file.
When I right click on "Tables" I don't have the option to create a new table.
Do I need to install something in order to ...
2
votes
1
answer
3k
views
Unable to Connect LocalDB Server in Navicat Premium
I've installed LocalDb server on my PC.
I am trying to create a connection to the LocalDB server in Navicat Premium.
I am unable to get the correct Host Name/IP Address for the LocalDB server.
I ...
-1
votes
1
answer
1k
views
Can't connect to LocalDB from Visual Studio 2015
When I try to connect to the database, to which I was previously able to connect, I get the following error:
I tried to solve this by looking up other stackoverflow questions and online resources, ...
2
votes
2
answers
70
views
Syntax check for creating logins in different SQL versions
We are trying to write a script to do the following task:
Create a new login and grant datareader to the master database on all SQL Server 2012 and 2014.
The script we have did what we want but for ...
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 ...
1
vote
2
answers
12k
views
How to programmatically find out where LocalDb is installed
I'm writing a plugin for Cake Build tool where I need to start a LocalDB instance. But this code will be executed on different machines and LocalDB can be installed in different folders depending on ...
0
votes
2
answers
10k
views
SQL Query to select all under certain age using only date of birth [closed]
How can I select all that are under 20 and female from a SQL database?
The table has a datetime for the dob and strings for name, surname, and sex. That is the whole table.
I am having trouble ...
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....
3
votes
2
answers
2k
views
Table with only a single constant value?
I use C# entity framework code first.
My knowledge regarding databases is almost nothing. I don't know if it's common or good practice so I wanted to ask you guys how I should do it.
Say I have a ...
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 ...
0
votes
1
answer
3k
views
Error importing SQL Azure Bacpac to SQL Server 2014 LocalDb
Downloaded a v12 SQL Azure bacpac, and trying to import it into a SQL Server 2014 LocalDB... I get:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Could not load schema ...
2
votes
5
answers
4k
views
Finding server and instance name
I want to know how to find the server and instance name on my computer to connect to the server.
I am using the SQLCMD utility, and I am currently able to connect to the server with the line
>...
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 ...
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 ...
3
votes
1
answer
4k
views
Portable client tool to connect to SQL Server Express LocalDB and execute a query
I am running out of ideas on this little problem:
I need to execute a query on a LocalDB database directly on user's computer. I do not want to install anything there and there is only .NET (4.5.2) ...
1
vote
0
answers
63
views
Simple Unpivot - erroneous Column Conflict [duplicate]
Did I stumble across a reserved word here or something?
For, the following statement:
SELECT [Type]
FROM (SELECT 'Receive' AS [Rec], 'Transfer' AS [Trx]) [data]
UNPIVOT
(
[Orders] FOR [Type] IN ...
2
votes
0
answers
859
views
SSDT sqlpackage.exe CreateNewDatabase Parameter Not Respected
Originally asked this on SO but that question seems to be populated only by tumbleweed so wondered if this might be a better forum for it.
I have a VS2103 solution which includes a database project ...
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 ...
1
vote
2
answers
3k
views
Change server name for SQLLocalDB instance
Is there any way to change the instance name of LocalDB of SQL Server 2012 from (LocalDB)\xxxx to just xxxx?
I need it for an application that needs SQL Server DB instance name to be MSSQLDEFAULT.
2
votes
0
answers
2k
views
Should xp_logevent and RAISERROR ... WITH LOG work on LocalDB?
I need to run a script to configure a LocalDB (v11.0.3000) instance and database (from a .NET 4.5 program) and I want to record results at various stages. Someone suggested xp_logevent but it doesn't ...
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 ...
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 ...
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 ...