SSIS Port

Jan 23, 2007

Hi:

Just wanted to find out what port does SSIS utilizes when communicated with a remote SQL Server. Is it 1434, 1433 or something? I have a SSIS Package on Server 1, which which does inserts on SQL DB on Server 2. I think between Server 1 and Server 2, some ports are being blocked because the 2 servers are separated by a firewall. When SSIS makes connection to Server 2 (SQL), what ports does it use? Also, any other tips would also help. Here is the error I am getting:

Cannot connect to 10.xx.xx.xx.

===================================

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

View 12 Replies

SQL 2012 :: SSIS Firewall Port

Aug 5, 2015

We have SSIS packages deployed and scheduled on SQL_Server_A. The packages have to access databases on SQL_Server_B, which is behind a firewall.

Question: would opening only SQL port between these two servers be enough or some other ports have to be open as well? (The packages only select and bring data back to Server_A or transfer data from Server_A to the databases and do inserts. Nothing else.)

View 1 Replies View Related

Can I Use SSIS To Port Directly From ODS To AS And Bypass Persisting In Intermediate DW?

Jul 20, 2007

At this link here:

http://www.microsoft.com/technet/prodtechnol/sql/2005/dwsqlsy.mspx

I read this snippet here:

Push data from the Integration Services pipeline or a custom application. The data can flow directly into an Analysis Services partition from the Integration Services package pipeline, without intermediate storage. This scenario can be used to reduce the latency (and storage cost) of analytical data.

What I think this means is that using SSIS I could bypass porting the data from ODS to DW, and instead use SSIS control flow/data flow components to direct the data straight to the Analysis Services Cube database storage partition.

I was hoping by posting this thread on this MSDN forum I could get details or links from those more knowledeable than I on this subject pointing me to how I may go about using SSIS to implement this approach. Perhaps package code examples or instructions about the components I could use to do this?

View 1 Replies View Related

Com + ....what Port Does It Use?

Apr 8, 2004

Hello,
I hope someone could help me out here.....

I have set up a new web server in my DMZ. This web server needs to "talk" to an application server located on my LAN. It communicates via a COM + Component.

I would like to keep the access that is open between the DMZ & LAN to minimal, obviously for security reasons. Does anyone know what port is used for COM + communication?

Thank you!

Spootnicks

View 2 Replies View Related

SQL Port

May 29, 2007

in SQL 2005, how do you find out what port number SQL is using and how can we change it Static port?

thanks,

View 1 Replies View Related

Port 1433 Is Already In Use...........

Jun 7, 2000

Ok,

The Scenario is as follows:

24/7 Production Call Centre server running NT4.0 and SQL 6.5 with all the latest service packs.

SQL mail fails(with dull regularity) and the SQL server services stop.

When the SQL server Services are restarted an error message appears stating that Port 1433 is in use after which nobody can connect via TCP/IP. Obviously the port believes the previous SQL session is still running, and won't release the port to the "New Application requesting it".

On a unix system you can force a port reset so you don't need to shutdown and restart the box. Can you do this from either SQL or NT?

Any solutions would be greatly appreciated the DBA's are 100 Miles from the Servers, so restarts are reliant on other people!

View 2 Replies View Related

Change PORT

Jan 31, 2003

Is there any way that I can avoid using 1433,1434 port on the clustered servers?

I have a active/passive (SQL1-active,SQL2-passive) cluster server and another active/passive cluster (SQL2-passive,SQL1-active).

(Its a Quassi active/active server)

I want to change all the sql server ports to other than 1433 and 1434.

Should I change in the registry
Localmachine-software-microsoft-mssqlserver-client-supersocketnetlib-tcp

or
Localmachine-software-microsoft-mssqlserver-mssqlserver-supersocketnetlib-tcpport

or
anywhere else?

Any suggestions are always welcome

View 7 Replies View Related

Port 1433

May 4, 2001

Does anyone have an idea on why when using IP with port 1433 that on the SQL 2000 Server a bind failure happens on port 1433 and are not able to get to the SQL using IP but you can use Named Pipes.

Would greatly appreciate any help.

Walter

View 3 Replies View Related

Deadlock With Port: 0

Apr 13, 2006

I've been diagnosing deadlocks for a last couple weeks at a client site and I understand the KEY: and TAB: locks issues. However, the client recently experienced a series of multi-branch deadlocks for which I can find no information. Attached is the deadlock text from the ERRORLOG. Any help would be much appreciated.

Nick

View 2 Replies View Related

Port 1433

Feb 2, 2004

Did a search on port 1433 but nothing came up in the search.
This question is more geared to DBAs more then SQL developers.

I have a SQL 2000 server on a win2k3 machine. For some reason it will not listen in on TCP port 1433.
Shared memory and Named Pipes do though.

I checked the Server Network Utility and I see TCP/IP listed right under Named Pipes and I see that the default port is 1433.

Any ideas how to get SQL to listen on that port?

View 14 Replies View Related

Port Numbers

Jun 2, 2008

Hi Gurus,

Iwant to know PORT number of B on A server.
Iam following the following process to get B PORT number.

1) Loging to server A.
2)Opened SQL Server Configuration Manager.
3)Opened SQL Server 2005 Network Configuration.
4)Opened TCPIP properties of Protocol for B.
5)On that opened IP Address TAB
6)Got PORT number from TCP Dynamic Ports

Am i going n right way.
If not please advice me the right way to get port numbers.

Thanks,
ServerTeam

View 8 Replies View Related

SQL Port Number

Aug 23, 2007

1. Is there a quick way to find out what port number SQL is listening to? I have 10 instances running on one server and I could find out by going to SQL log but it's bit time consuming.

2. quick way to change the port number?

thanks

View 1 Replies View Related

Non Standard Port

Oct 30, 2007

I'm trying to setup SQL Server 2005 Express to communicate through a non standard port. I can connect to SQLServer on a remote machine using port 1433 when it is set as such but when I change the server to another port and try and connect using SSMSE I can't get through. I'm specifying the ip address and a colon followed by port number to connect.

For example: 123.123.123.123:1234

Any ideas?

----------------------------------
Standing on the shoulders of giants

View 9 Replies View Related

Port Not Open; How-to?

Jan 7, 2008

Not sure how this particular topic should be labeled but I figured I would start here.

I have a third party Time and Attendance program that uses SQL 2000 and IIS on top of Win2003.
It also uses a client side program that sits on an XP box that pulls Time clocks entries than passes that info to the SQL server.
We recently needed to move to a different service, still utilizing the same Time and Attendance program but a different client utility that pulls the Time clocks. Both the client and Time and Attnedants program are developed by the same company.
All that being said the new clock utility cannot connect to the SQL service.
The difference between the 2 utilities is the first utility uses UDP, the second uses TCP and requires port 5405.
Basically the way I��m seeing things is that the server does not have port 5405 open this also confirmed by the company the wrote the program.
There is no firewall on this server. RRAS is installed but does not have any filters enables which I believe means it will receive and pass all protocols to all ports.
Using a port scan utility it shows port 5405 not to be open
How can I get port 5405 open?

View 5 Replies View Related

Tcp/ip Port Change

Nov 8, 2006

I installed a new instance and changed the default tcp/ip port and configured the applications. based on request i have changed the port to default 1433. now the problem is, the instance is not coming up. Then I restored the port now its working fine. But the application user wants 1433. could you please tell me why the instances is not comming up if the port is 1433? Thanks in advance

View 7 Replies View Related

Sql Port 1433

Apr 29, 2008

i am asked to change the default port 1433 to some other name by the audit team.
is it safe to change the port in cluster mode.

View 17 Replies View Related

Port Usage

Jan 19, 2007

The powers that be at my company have decided to redisign our network. The big change is that they are completely separating the two domains, whereas I guess right now one runs inside of the other.

What this means to me is that I need to get a document together which shows all the connections between different SQL servers, web pages and services that I've created over the last year.

My question is, what ports do all of these things use to communicate with SQL Server 2000? I believe the only connections right now are using ADO/ADO.NET, or straight SQL Linked Servers.

View 5 Replies View Related

Port Sql 2000 To Sql 2005

Apr 17, 2007

Need url on good kb or article on converting sql 2000 to sql 2005 (full version not express)
Thanks,
Michael Oard

View 4 Replies View Related

Need A Way To Port From Informix To Sql Server

Jan 5, 2001

Hi,

Could anyone tell me how the data can be ported from informix to sql server ?

Is there a way to run the informix query from sql server ?

Thanks,
Vijay.

View 1 Replies View Related

Port Number - 1433

Dec 15, 2000

Does anyone know how to change the default port number of 1433 to somethinig else?

Thanks!

View 1 Replies View Related

Changing The Default Port

Nov 5, 2002

Does anyone thing it is a wise thing to change the default port for SQL? Will this adversely affect the server? Thanks.

View 2 Replies View Related

Identifying PORT Number??

Mar 1, 2004

Hi,

Can anyone tell me how to find out on what port number a paticular sqlserver named instance is running...

thanks..

View 5 Replies View Related

Change Port From 1433

Apr 22, 2004

How many people have actually change their sql port from 1433 to something else

View 1 Replies View Related

Cannot Talk On 1433 Port

Apr 30, 2001

I have sql server that get the following error on error log.

SuperSocket Info: Bind failed on TCP port 1433.

This error forces client to use Named Pipe to connect to SQL Server.

Does anyone how to fix this error.

Thank You,
John

View 4 Replies View Related

Finding The SQL Server Port

Feb 17, 2005

Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.

Is there a way I can specify a port for the server to listen to?

View 2 Replies View Related

Finding The SQL Server Port

Feb 21, 2005

Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.

Everything is on my local machine, this is a development database.

Is there a way I can specify a port for the server to listen to?

View 7 Replies View Related

How To Port SQL Server Data?

Jan 27, 2004

Hello!

I have an SQL Server 2000 database at home PC that has several tables and plenty of data in it...also stored procedures.

I want to port all that data so that I can use it at another PC that has SQL Server installed in college.

How to do this?

Thanks in advance!

Lala the don

View 6 Replies View Related

Connect Through Port 1433

Apr 10, 2015

So, I have 2 laptops, both with standalone SQL Server 2012 Management Studio.

laptop 1 can connect to my remote server on xxx.xxx.xxx.xxx,1433
laptop 2 cannot connect through management studio - but can connect directly from the development website on this machine.

I get error 18456, cannot connect to server and login failed for 'user'

Firewall on or off has no effect.

View 8 Replies View Related

SQL Server Port.... (Named

Jul 12, 2006

I have access to the default instance of a SQL Server ..... I have access to the QA only .. by reading the registry through the QA I get to knw that there are additional 4 more instances on the Server ..... is is possible to get the port on which they are listening using the QA ....

I knw that we can go to the servers network utility & see it there in the TCP /IP ... but i dont have access to that , neither do i have access to the error logs that tell me , on which port is SQL Server listening to

Can someone help

View 1 Replies View Related

Port Security Question

Jul 23, 2005

Hey all.I'm running SQL server 2000, on W2K server. All the latest patches/etcfor both installed.I've a need to allow remote access to the DB. I have a strong passwordon the sa account, and have completed the various security checklistson the MS website, including running the baseline security program theyprovide.Due to the nature of the application, windows authentication is notpossible.Besides someone trying to hack in via a password guess, are there anyother things I need to worry about? Again, all the latest patches andwhat not are installed.ThanksMatt

View 3 Replies View Related

Connection TCP/IP Through The Port 1433

Nov 26, 2005

Witam!Mam problem z polaczeniem sie z baza danych po TCP/IP przez port domyslny1433, nie mozna sie telnetowac ani nic z nim zrobic, poprostu niezyje. Portjest zamkniety i nijak nie moge go zmusic do jakiejkolwiek komunikacji nawetpo localhoscie. Skaner port�w wykrywa go jako zamkniety. Czy wiecie moze jakten port otworzyc i zmusic go do komunikacji z baza danych? OS win2k3,MSSQL2000 Server.PozdrawiamHello!I have a problem with a TCP/IP connection to Data Base through the 1433port. I cannot telnet on this port even on localhost. My firewalls aredisabled but port scanner see the port as closed. Protocol TCP/IP on theMSSQL Server is enabled and it's not hidden, so I don't know what I shouldto do. My configurations: Win2k3 Server, MSSQL Server 2000Thx for answers.

View 1 Replies View Related

How Do I Start Sql Listener On A Port?

May 18, 2006

HiI am very new to SqlServer. I want to my java application, using JDBC,to connect to the SQLServer on port 1433 (Running on Windows NT). Howdo I configure it? I am using 2000 version of SQL Server.Thank you

View 1 Replies View Related

Security Problem With UDP Port

Dec 27, 2007

hi
at first i apologize u for bad english.

my sqlserver2000 works on Win2000 for many years in a wide network.
i have problem that it used 1434 UDP port to increase bandwidth traffic by sending many UDP packages to many IP which created randomly by SQLServer2000 when it find another SQLServer2000 after sending packages again new server start sending UDP Package to other.
then no one cant connect to Server.

i had a worm like this 2 years ago.
but this bug or worm could not be detected by any anti virus or any SP like SP4.

How can i solve this problem ?
Tanks

View 5 Replies View Related