Sample Header Ad - 728x90

trying to connect to MSSQL server using named pipe in HeidiSQL

1 vote
2 answers
5603 views
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:** \ 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?
Asked by raphael75 (244 rep)
Aug 6, 2019, 07:45 PM
Last activity: Aug 7, 2019, 06:30 PM