I'm trying to connect to a MSSQL server in our office from my local desktop using HeidiSQL. I am able to connect to this server with both SQL Server Management Studio and ODBC with no problems. The connection uses integrated Windows authentication. I installed the MS OLE DB SQL 18.2.2.0 x64 driver. My settings in HeidiSQL are:
network type: Microsoft SQL Server (named pipe)
library: MSOLEDBSQL
hostname: <server>\<instance>
use windows authentication is checked
every time I try to connect I get:
SQL Error (0): SQL Server Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF] Login timeout expired
It doesn't tell me what protocol is being used, and I don't see any options to change it. Does "protocol" in this case refer to the library?
Is there some way to change the protocol in Heidi?