0

I have both SQL Server and Windows on version 2016. I am trying to set the firewall to allow SQL Server Management Studio to connect from my PC to it. I have created an entry for port 1433 TCP local and another entry for the actual sqlsrv.exe application under Inbound Rules.

Am I missing something?

Rick
  • 437
  • 2
  • 8
  • 21
  • 1
    Have you configured SQL Server itself to allow remote connections? Allowing the traffic through your Firewall is only half the equation. – Ramhound Apr 30 '20 at 20:49
  • If I turn off the firewall, it works fine, so no problems on SQL Server side. – Rick Apr 30 '20 at 20:55
  • Since it's not clear if you have properly configured your server, I am unable to submit an answer, but [Configure the remote access Server Configuration Option](https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option?view=sql-server-2016) – Ramhound Apr 30 '20 at 21:00
  • You will need to allow all the ports listed [here](https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-2016) more than likely. – Ramhound Apr 30 '20 at 21:05

1 Answers1

0

You haven't mentioned whether you installed a default or a named instance. See Microsoft for further details on the difference.

What you have done should work for a default instance SERVERNAME, if instead you have installed a named instance SERVERNAME\INSTANCENAME then you would also need to allow the SQL Browser Service service. Lookup the path in Windows services for this and while in there ensure that it is set to Startup Type: Automatic and it is started. The default installation path is "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe"

If this doesn't work, ensure that TCP/IP is enabled for the SQL Server in the SQL Configuration Manager.

To summarise:

Default instance SERVERNAME:

Named instance SERVERNAME\INSTANCENAME:

pholcroft
  • 478
  • 4
  • 7