Solved

SQL 2005 Integration Services - Transfer SQL Server Objects Task - What Port Number does it connect on?

Posted on 2006-11-07
1
269 Views
Last Modified: 2012-08-14
Hi Experts,

I am using SQL 2005 Integrations Services and am copying data from my SQL 2005 database to a SQL 2000 database using the Transfer SQL Server Objects Task.

However, the server I am connecting to has a firewall that blocks almost all of the ports.

In order to make this work I need to find out what port is being used.

Any Thoughts?

0
Comment
Question by:kennethscff
1 Comment
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 17889022
did you check port 1433
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL date incremented 11 31
Slow Connectivity over ODBC 8 38
SQL Server Designer 19 44
SQL SERVER 2008 R2 Could not obtain information about Windows NT group/user 5 36
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

823 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question