Sql-server – Open firewall ports on MSSQL for SCOM

Its best to use SQL configuration manager to set the ports explicity and then open these in the firewall.

Make sure that UDP 1434 is open for the browser service.

As the error message tells you, the problem is not the firewall or the remote connections, but the login process.

Since you're connecting from PHP, try password authentication instead of Windows Authentication (note that by default, password authentication is disabled for Microsoft SQL Server). PHP with Windows Authentication may be a pain, at least it was a few years ago when I tried to make it work, wasted a few days and never achieved to make it work.

If you're already using password authentication, check that it is enabled in Microsoft SQL Server itself.

If this doesn't help:

• Check the Microsoft SQL Server logs. Sometimes, they contain interesting stuff when the authentication is not working for an obscure reason.

• Some advise to check whether Shared Memory, Named Pipes and TCP/IP are all enabled, so check this one too (in SQL Server Configuration Manager).

• Make sure to read the article by Pinal Dave.