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