Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
2answers
64 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 ...
7
votes
4answers
614 views

Does LocalDB support temporary tables?

Are SQL Server temporary tables (prefixed with #) supported in LocalDB instances?
2
votes
0answers
412 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:\...
27
votes
4answers
5k 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
0answers
359 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 ...
3
votes
1answer
669 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
1answer
731 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 ...
3
votes
1answer
886 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
1answer
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, ...
1
vote
2answers
44 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 ...
8
votes
3answers
2k 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
2answers
4k 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
2answers
642 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 ...
4
votes
2answers
4k views

Access SQL Server Express LocalDB from local area network

I am developing a software which requires sql server. But for 50 MB application it is not good idea to tell customers to install SQL Server. So I think it is better to use SQL Server Express LocalDB. ...
3
votes
2answers
528 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 ...
4
votes
1answer
2k 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
1answer
2k 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
5answers
2k 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 >...
8
votes
1answer
10k 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 ...
6
votes
1answer
28k 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
1answer
2k 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
0answers
40 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
0answers
490 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
2answers
13k 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 ...
0
votes
2answers
2k 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
0answers
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 ...
11
votes
1answer
9k views

How to 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
1answer
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 ...
11
votes
8answers
45k 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 ...