Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Unable to connect to MS SQL Server

cbourner's profile image cbourner posted 2 years ago in Creating a connection Permalink

I use SSMS and would like to try HeidiSQL as an alternative. I am unable to connect to any of the databases I use regularly - and successfully - via SSMS from the same PC.

I am trying to use named pipes with windows authentication, but I have tried many other options.

I get:

"SQL Error (17): [DBNETLIB][ConnectionOpen (Connection().]SQL Server does not exist or access denied"

Any ideas?

ansgar's profile image ansgar posted 2 years ago Permalink

You need to activate one of the connection protocols in your MS SQL configuration. For example, I had to enable TCP/IP connections before I could connect via HeidiSQL.

Please login to leave a reply, or register at first.