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[08001]: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [1326].
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?
Thanks!
need to have one connection to another machine
, so is the connection TO or FROM this other machine? If FROM this other machine did you create an inbound firewall rule on the SQL server? What do you meanit causes the connection to fail
? What specifically happens? What messages do you get when attempting to connect?