All Questions
Tagged with sql-server-localdb sql-server
35
questions
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 ...
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
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
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?
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?
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:\...