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.

Local MSSQL Connection

BigBaz's profile image BigBaz posted 4 weeks ago in Creating a connection Permalink

Hi I have a local MSSQL server which I regularly access with Management Studio. When I try to connect with Heidi I get errors 'Locating Server/Instance Specified'. However, this instance is there as keyed in as MSSQL accesses it without any problem.

The USer name/pw are correct and even using Windows Authentication I get this error, so it's not getting that far. It's set for 'Microsoft SQL Server (named pipe)' as none of the other options are appropriate, and MSOLEDBSQL (as this is forced anyway).

Any thoughts what might be wrong?

ansgar's profile image ansgar posted 4 weeks ago Permalink

You could try to use SQLOLEDB library, which is working for me at least.

BigBaz's profile image BigBaz posted 4 weeks ago Permalink

When I try that I get warning msg: Security issue: Using SQLOLEDB ADO provider insecure TLS 1.0 ...'

BigBaz's profile image BigBaz posted 4 weeks ago Permalink

The error msg suggests downloading Microsoft OLE DB with a link.

I already have that driver installed, nevertheless I downloaded it and installed (well 'modify' was the option available), but it hit an error - error code 29528.

Oddly enough the database opened! Now I am confused. Closed the connection and opened it again and it works using SQLOLEDB. Closed Heidi and re-ran and whilst I still get that same warning it opens OK.

ansgar's profile image ansgar posted 4 weeks ago Permalink

The dialog is just a security warning, no show stopper:

Description

By the way, I have the same issue, and I could not yet find out why the MSOLEDBSQL is no longer working for me.

BigBaz's profile image BigBaz posted 4 weeks ago Permalink

OK, thanks. Is there any way to stop that warning, it comes up every time I open the connection. No problem, just annoying now.

ansgar's profile image ansgar posted 4 weeks ago Permalink

I'm afraid no, as this is security relevant. Instead, I will have to find out why the MSOLEDBSQL library does not work in some or many cases.

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




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.