Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SQL Server Firewall Settings - Part 1

  • 29 October 2013
  • Author: CraigLove
  • Number of views: 12634
  • 0 Comments

Sooner or later you will be faced with the need to open your server or workstation firewall to allow incoming connections.  This is always a pain for me since this is not a task I do regularly.  Finally after researching the issue several different times for each of the services in SQL Server, I wised up and put it all down in my OneNote reservoir.

This is the first of a series of blogs that provides guidance for setting firewall and server settings to allow connections to the various components of SQL Server- SQL Server, SQL Server Analysis Services, SQL Server Integration Services and SQL Server Browser.  This entry addresses opening the firewall to permit connections to the default SQL Server instance. 

Access the firewall control panel.  This can be accessed by running the program firewall.cpl from the start menu.

Launch Firewall Window

The Windows Firewall window will open.  Click on the Advanced Settings window.

Firewall Advanced Settings

 

In the next window, right-click on the Inbound Rules node and select New Rule...

Add New Inbound Rule

 

The Inbound Rule Wizard will appear. On the Rule Type screen, choose a port rule type and then click Next.

Firewall Step1

 

On the Protocol and Ports screen select TCP and "Specific load ports".  If no changes are made to the default installation of SQL Server, it will use port 1433.  Enter 1433 in the text box.

Firewall Step 2

 

On the Action screen select "Allow the connection".

Firewall Step 3

 

On the Profile page, select the appropriate items.  You may need to check your NIC card settings to determine the correct zone(s).

Firewall Step 4

 

On the final screen titled "Name", enter a descriptive name and description.  Click Finish.

Firewall Step 5

 

You should see the new rule in the list of Inbound rules.  This will allow connections to the default instance of SQL Server.

Firewall Complete

 

That's all you need to open the default instance of the SQL Server Engine

On the next post I will cover setting up named instances of the SQL Server Engine.

Craig

Print
Categories: Analysis Services
Tags:
Rate this article:
No rating

CraigLoveCraigLove

Other posts by CraigLove

Please login or register to post comments.