Home > SSIS Best Practices > Configuring a Windows Firewall for Integration Services Access – TCP Port 135

Configuring a Windows Firewall for Integration Services Access – TCP Port 135

The Windows Firewall system helps prevent unauthorized access to computer resources over a network connection. To access Integration Services through this firewall (when your SSIS sits in one network, and the target SQL server sits in a different network), you have to configure the firewall to enable access.

In the company I am working with, we need to send a request to the data center to open up the firewall on a port number for a specific server identifiable by it’s IP address in the network.

It will be slow, but it should work.

 

 image

Here is an article on MSDN about Configuring a Windows Firewall for Integration Services Access.

Here is the actual access request to the data center:

image

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: