Installing SQLLocalDB 2019 issues

Question

Installing SQLLocalDB 2019 issues

Josef Szeliga 6

HI,

I've installed SQLLocalDB 2019 but cannot connect to the default database via Sequel Server Management Studio.

I have used the cmd line request "sqllocaldb info MSSQLLocalDB" to confirm that MSSQLLocalDB is running.

I am unable to configure the MSSQLLocalDB because i do not have a "SQL Configuration Manager" app installed.

According to the documentation "SQL Configuration Manager" should have installed when i installed Sequel Server Managment Studio v19.

I have run a repair and uninstall and re-install Sequel Server Managment Studio v19 a number of times, but it never installs "SQL Configuration Manager".

I have checked both C:\Windows\System32 for the SQLServerManager15.msc add in file. It does not exist on my PC.

How can I connect to my MSSQLLocalDB server instance via my SSMS without a configuration manager and if I can't where i find a configuration manager to download?

Erick

2 answers

Your answer

Answer 1

ZoeHui-MSFT 41,496

Hi @Josef Szeliga,

Could you please provide any error message when you are trying to connect the loaclDB with SSMS?

You may also check the error message via Windows Event Viewer.

This installed the LocalDB feature of Express which does not install config mgr and is managed at the command line.

It's meant to be a very easy/quick way to have a lightweight sql server and is not meant to be used except locally and has a special connection string, hence configuration manager is not necessary.

If you want more features you can install the full Express edition or SQL Developer edition which is good for dev/test (non-production) usage.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Josef Szeliga 6 Reputation points

2023-05-09T03:55:27.9966667+00:00

I was able to connect from SSMS somehow before i saw your reply. I"m not sure if i did anything different from the other attempts.

But when i tried to connect from Visual Studio 2022 using Server Explorer I started getting a similar error.

I've used the name as it appears in the SSMS . But have also tried (localdb) MSSQLlocaldb and MSSQLLocalDB by itself.

Visual studio is running as admin under my own account. That same account has sysadmin privileges on the MSSQLLocaldb server.
ZoeHui-MSFT 41,496 Reputation points

2023-05-09T06:43:39.2733333+00:00

Hi @Josef Szeliga,

Try to use .\name or (local)\SQLEXPRESS as the server name.

A same thread here, you may take a reference to.

https://stackoverflow.com/questions/6538511/sql-server-is-not-showing-in-visual-studio/32823665#32823665
Josef Szeliga 20 Reputation points

2023-05-09T10:56:12.49+00:00

Neither ".\MSSQLLocalDB" nor "(local)\SQLExpress" nor "(local)\MSSSQLLoclaDB" will connect. All claim they cannot find the SQL server. When i tried to start the SQL Server Browser Service it started and stopped immediately. The event log error states "The SQL configuration for SQL is inaccessible or invalid". I have no SQL Server Configuration Manager installed and i cannot find any download to add it. The strange thing is that the SQL Server Object Browser in Visual Studio 2022 is connect to the server and working.

My experience is with the Developer and production version of SQL Server. This is the first time I have tried a MSSQLLocalDB install. I've never had so much trouble trying to instal SQL server.

I've used the connection string for the SQL Server Object Explorer properties, and it connected.

So the name of the server "(localdb)\MSSQLLocalDB" but not "(local)\MSSSQLLoclaDB". So it should have been "(Localdb)" and not just "(local)". Seriously considering uninstalling MSSQLLocaldDB and just installing SQL Server Developer Edition 2019

Answer 2

Erland Sommarskog 121.9K MVP Volunteer Moderator

You don't use SSCM with LocalDB, because localDB runs in user space and not as a service.

To connect to your localdb from SSMS, specify (localdb)\MSSQLSERVER. You may have to start the instance first with the sqllocaldb command.

Josef Szeliga 6 Reputation points

2023-05-10T01:30:20.8033333+00:00

I gave up with the localDB server and tried to Install SQL 2019 developer edition. Before I installed it I uninstalled every SQL service i could find in my Windows 10 application list. However, when i tried to install the Developer addition it failed. It seems that "SQL Browser" still exists and did not uninstall. There doesn't seem to be a manual way to delete this service. And unless i delete it I cannot install the Developer edition of SQL Server 2019
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator

2023-05-10T07:30:54.93+00:00

It should be possible to install Developer Edition even with the Browser service present.

Since this is a different problem from the original, I would recommend that you ask a new Question about your problems of installing Developer Edition. In the folder C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Logs here is one folder per install attempt. In your Question, attach Summary.txt and detail.txt.
Josef Szeliga 6 Reputation points

2023-05-10T22:21:10.05+00:00

Thanks . Will do

Share via

Installing SQLLocalDB 2019 issues

2 answers

Your answer