Which ports are needed for NTLM (Windows Authentication) to connect to SQL Server?
- by Adam Bellaire
I've got SQL server running on a machine which is not in a domain, and which is not operating in mixed mode (it's running with "Windows Authentication").
I'm trying to connect to it from a Linux web server running freetds via TCP/IP, using NTLM to authenticate.
The firewall on the SQL server is very restrictive. 1433 is open to my web server,…