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.

Using HeidiSQL with SQLexpress

joel's profile image joel posted 3 years ago in Creating a connection Permalink

Hello- I am running the 64-bit version of MS SQL Express (10.50.4000) on a Dell laptop under Windows 7 Home Premium. I have attached the result of my attempt to connect with HeidiSQL version 9.4.0.5145.

Is the basic problem that I simply will not be able to connect with HeidiSQL while using SQLexpress? I tried using MS SQL named pipes and TCP/IP and the error message is the same.

Thanks.

1 attachment(s):
  • heidiconnect
ansgar's profile image ansgar posted 3 years ago Permalink

I had to activate one of the protocols in SQL Server Express before I was able to connect through HeidiSQL. E.g. TCP/IP had to be turned on, in the "SQL Server Configuration Manager", on the tab "Network configuration.

joel's profile image joel posted 3 years ago Permalink

Thanks for a very prompt reply, Ansgar. It would seem to make sense that TCP/IP has to be enabled in SQL Server Config Manager so I quickly did so. However, the results were the same: No connection as Heidi is unable to find or connect to SQL Express. This is actually SQL Server 2008 that I currently have installed. I am hoping there can be another tweak that will allow me to connect. Should it really matter if I am using 127.0.0.1 or the actual hostname in the Host/IP field? Thanks very much for your assistance.

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.
ansgar's profile image ansgar posted 3 years ago Permalink

I think you should try "[Computername][SQLServerInstanceName]" as host name with SQL Server over TCP/IP. E.g. "Ansgar-PC\SQLExpress" did it for me if I recall right.

joel's profile image joel posted 3 years ago Permalink

Wow, Ansgar, absolutely! That was exactly what was needed. Thanks so much for staying with me on this problem. In a way, knowing to enter the Hostname\SQLServerInstanceName is not entirely intuitive but if that is what Heidi needs, I will go with it. Thanks again, looking forward to using Heidi to see how it compares to Management Studio.

DavidMorris's profile image DavidMorris posted 3 years ago Permalink

I understand this question gets some information about local db; in any case, this outcome came up when I was glancing around and this answer would have helped me. In windows, look enter SQL server configuration manager. Open that, yet ensure you are not opening SQL server ace information services configuration manager, that is not right. For me, the first occasion when I needed to look underneath it in the outcomes under applications Assignment Writing Help | Assignment-Empire.

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