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 ...
- 728
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: ...
- 101
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 ...
CommunityBot
- 1
0
votes
0
answers
69
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 ...
- 97
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 ...
- 203
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 ...
- 121
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 ...
- 1
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
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 ...
- 2,372
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 ...
- 45
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....
- 103
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 ...
- 1
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 ...
- 87k