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?
Best Answer
Try following:
Enable Named pipes visa configuration manager
Restart particular SQL Service
Have a look at SQL log (recent entries after restart), it must state the named pipe is ready without any error (as showed screenshot below)
If SQL error log looks good, try again with named pipe, make sure the
hostname
match with named pipe (configured in step:1)If still no luck, you may proceed with TCP/IP protocol, just make sure you are able to do
telnet localhost 1433
to be sure the TCP/IP is enable and ready for connections. If any issue, you can follow Step 1 and 2 for enabling TCP/IP, and add aNew Rule
at Windows Firewall to accept incoming connections on SQL Port# (default: 1433).Additional steps for custom port configuration