Connecting to an MSSQL Server through HeidiSQL

Brian Chew
May 17 · 2 min read

Hello everyone, after trying for numerous hours to connect to my MSSQL Server installed via the Visual Studio Installer on my Windows VM with HeidiSQL. I just couldn’t help but post a quick and detailed guide on how you can do the same. I have credited the information that helped me below!

Step 1 : Look for your MSSQL Server’s name (If you’ve installed it with Visual Studio like me… (Open up > SQL Server Object Explorer)

In my case, the MSSQL’s server name is “MSSQLLocalDB”

Step 2: Start MSSQL Server

Command 1 : "C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" start MSSQLLocalDB
OUTPUT:
LocalDB instance "MSSQLLocalDB" started.

The above command helps you start your MSSQL Server and allows you to check information (like pipe information)

Step 3: Check for your pipe information with the following command

Command 2 : "C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" info MSSQLLocalDB
OUTPUT :
Name: MSSQLLocalDB
Version: 13.1.4001.0
Shared name:
Owner: DESKTOP-UT2AN59\Brian Chew
Auto-create: Yes
State: Running
Last start time: 11/27/2018 8:40:16 PM
Instance pipe name: np:\\.\pipe\LOCALDB#D42B8DEB\tsql\query

As you can see above, my instance pipe name is “np:\\.\pipe\LOCALDB#D42B8DEB\tsql\query

Step 4: You’re done, so stop the MSSQL Server and navigate to HeidiSQL and use the following settings! (remove np:)

To stop the server: use the following command! (PS: You won’t be able to connect to your server if it’s down… so just remember!)

Command 3: "C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" stop MSSQLLocalDB
OUTPUT:
LocalDB instance "MSSQLLocalDB" stopped.

You’re set! Now you’ve successfully connected to your MSSQL Server with HeidiSQL and can make full use of HeidiSQL for any MSSQL stuff! Credits: here

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade