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
26
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
25
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
63
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
119
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
310
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
226
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
152
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
42
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
220
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 ...