Local MSSQL Connection

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?

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

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

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.

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

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

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

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.