How do I allow SQL connections through my Windows Firewall? Follow

Overview

Windows Firewall can block access to the GlasPac LX SQL server.  This can keep you from connecting additional Workstations to your main server.  These instructions are meant to help you allow access to the SQL server without disabling the Windows Firewall altogether.

Gathering Information

The first thing that needs to be done is to identify where the SQL services are running.

Open Control Panel > Administrative Tools > Services

Use the slider at the right of the screen to move down the list until you see SQL Server (GTS).

Right-click SQL Server (GTS) and click Properties

 

  • Under Path to executable, select the entire file path
  • Here is an example of what you should see:
    • "c:\Program Files\Microsoft SQL Server\MSSQL10_50.GTS\MSSQL\Binn\sqlservr.exe" -sGTS
  • Copy the entry by typing Ctrl-C
  • Open Notepad, and paste the file path to save it

Repeat the above process for the SQL Server Browser service

Create the Windows Firewall Inbound Rules

With the file path information, we can now create our Firewall Rules.

  • Open Control Panel > Administrative Tools > Windows Firewall with Advanced Security
  • Select Inbound Rules at the top left of the screen.
    • On the right side of the screen , click New Rule . . .
    • Select Program if it is not already selected, click Next

    • Copy and Paste the first entry you have saved in Notepad.  Remove the quotation marks (") from the beginning and end of the entry.  Also, remove the -sGTS from the end of the entry.  Click Next

    • Leave the Allow the Connection option selected, and click Next

    • Put a check in each of the profile options listed, and click Next

    • On the next screen, enter SQL Server (GTS), and then click Finish
  • Repeat the above process for the SQL Server Browser.

Once the Inbound Rules have been added, your Workstations should be able to connect to the SQL Server.

Have more questions? Submit a request

Comments

Powered by Zendesk