How to start, stop and connect to your Microsoft SQL Server with HeidiSQL

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

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: