December 20, 2017 by Anuraj
Sql Server LocalDb SSMS
This post is about connecting and managing SQL Server LocalDB instances with Sql Server Management Studio. While working on an ASP.NET Core web application, I was using LocalDB, but when I tried to connect to it and modifying the data, but I couldn’t find it. Later after exploring little I found one way of doing it.
- First execute following command from powershell window.
It will return something like this.
If you notice the State is stopped and Instance Pipe name is empty. You need to start the instance first, you can either do it with
start commandline parameter with argument instance name. Or you can run your ASP.NET Core application. Once it is running, the command will display output like this.
You need to copy the Instance Pipe name and paste it in SSMS Connect to server dialog, like this.
Also you need to change the authentication mode to Windows. Click connect, you will be able to connect to LocalDB using SSMS. You can execute command, modify records etc with SSMS.
Please note, the connection string will be changing every time. So before connecting to the DB you need to run the command to get the connection string.
Happy Programming :)
Copyright © 2024 Anuraj. Blog content licensed under the Creative Commons CC BY 2.5 | Unless otherwise stated or granted, code samples licensed under the MIT license. This is a personal blog. The opinions expressed here represent my own and not those of my employer. Powered by Jekyll. Hosted with ❤ by GitHub