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
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?
- 263
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 ...
- 73
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
...
- 123
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?
- 191
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 ...
- 9
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:\...
- 347
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 ...
- 503
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 ...
- 111
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.
...
- 503
-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 ...
- 31
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 ...
- 123
-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, ...
- 103
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 ...
- 45