We have a MSSQL Server that has localhost connections, but need to have one connection to another machine. The other machine needs to login to MSSQL server.
We added an Inbound Windows Firewall rule for Port 1433 and only that machine's IP, but it causes the connection to fail. The message from a PHP script states: SQLSTATE: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server .
As soon as I allow all IPs again the connection, queries, and PHP script works as expected.
What am I missing to make sure that only that IP and localhost can access MSSQL?