sqllocaldb | SQL LocalDB Wrapper is a .NET library providing interop | SQL Database library

I have a sample .NET Core 2.1 application which is using IIS Express and a LocalDB, but whenever I run the WebAPI application I get the below error:

System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot get a local application data path. Most probably a user profile is not loaded. If LocalDB is executed under IIS, make sure that profile loading is enabled for the current user.

My connection string is:

We've got an application based on microservices. The deployed application will be running on a full version of Microsoft SQL Server. For UnitTesting i wanted to use a clean localdb instance of SQL-Express, to ensure a constant output of my tests. For managing the database schemes we are using flyway scripts.

Now the big question:
Is it possible to use flyway on a localdb instance?

(I didn't find anything on it around the internet.)

Any help is welcome!

Edit: Solution found! See post below

Edits:
Here is what I get, by trying to connect to my localdb instance

Creating a new Blazor WebAssembly App with Microsoft Visual Studio 2019 Version 16.9.4 with these specifications: Target Framework .NET 5.0, Authentication Type Individual Accounts and ASP.NET Core Hosted:

With no modifications I have simply started the project with IIS Express, ran migrations and added a user to the database.

This works without a problem so then I created a publish profile to folder.

I then set up a new site in IIS, version 10.0.19041.1, and set the Application Pool to use my Windows Identity that I have confirmed works with SSMS and that works via IIS Express.

Running it the first time I got this error in Windows logs:

System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Extensions.DependencyInjection.IdentityServerBuilderConfigurationExtensions.<>c.b__10_2(IServiceProvider sp)

I fixed this by adding a Key to IdentityServer in appsettings.json exactly like appsettings.Development.json does it:

I want to deploy mdf file with version 904 (sqllocaldb2019) on processor x86 but I cant find sqllocaldb 2019 foe x86, what should I do

I installed the LocalDB component (only) from SQL Server 2019 Express on a Windows 10 machine that had NO Sql Server installation of any kind. I installed SSMS next.

The AUTOMATIC instance MSSQLLOCALDB works as advertised. I can use SSMS to access it, add a database, perform queries, everything is fine.

I want to make this instance shared.

So I typed (from Powershell) sqllocaldb share MSSQLLOCALDB SharedDb

The shared instance is properly created.

PS C:\WINDOWS\system32> sqllocaldb i
.\SharedDb

MSSQLLocalDB

But I cannot access the shared instance from SSMS

Things I have tried

• Stopped and started the automatic instance
• used the servername as (localdb)\.\SharedDb as documented.
• tried it from sqlcmd where it works for the automatic instance, but fails for the shared instance.
• rebooted the machine

Fails with: Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Named Pipes Provider: Could not open a connection to SQL Server [2]. . Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired. Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

Any suggestions on how to share a LocalDB instance would be appreciated. Thanks.

I'm learning SQL so I don't know yet all the subtlety of the language,

I wrote the following stored procedure (simplified here):

I have an ASP.NET MVC application and I cannot connect to the local SQL Server database that is hosted on my machine.

I get the following error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance. See the Windows Application event log for error details. )

I have recently installed SQL Server Express on top of the original SQL Server install; since this has happened, the application can now never get connected to the database. My app is running on the local IIS and under Administrator when I debug through Visual Studio.

Things I have tried:

• I have tried deleting the local databases in the Microsoft folders and re-creating them
• I have tried running the "sqllocaldb start" command and it has started
• I have tried stopping the SQL services and restarting them
• I have tried running the application pool under a user with access to the DB
• I have tested the connection into the application by creating a datamodel, which it can do
• I have tried applying the Everyone group with full control to the instances folder
• I have tried giving public access to the database table
• I have tried deleting and re-creating the database

I am getting the following errors in Computer Management under SQLLocalDB15.0:

The specified resource language ID cannot be found in the image file.

Cannot get a local application data path. Most probably a user profile is not loaded. If LocalDB is executed under IIS, make sure that profile loading is enabled for the current user.

My Connection string is as follows:

I have a Wix Bootstrapper application which launches the SqlLocalDB 2019 MSI installer. It works great and everything is installed properly.

In the MsiPackage I'm passing ARPSYSTEMCOMPONET=0 to ensure that the "Microsoft Sql Server 2019 LocalDB" entry appears in Add/Remove Programs on Windows 10.

I get the error

Msg 5123, Level 16, State 1, Line 1
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file

after launching a localDb server and trying to run a create database query off it. I am very new to SQL Server and need to do a tutorial for an internship I am starting.

I created a localdb instance in my onedrive directory. At least I think I did because that's the directory I navigated to when I ran the