How to find the Datastage port to communicate SQL server

chitravallivenkat · Post by **chitravallivenkat** » Thu Jul 02, 2009 1:44 pm

Hi,

Could any one advice How to find the Datastage port used to communicate to SQL server?

thanks,
Venkat

DSguru2B · Post by **DSguru2B** » Thu Jul 02, 2009 2:00 pm

Not the datastage port but you need the sql server port. That info you can get from your SQLServer DBA.

datskosaraju · Post by **datskosaraju** » Thu Jul 02, 2009 2:08 pm

Correct me If wrong!! I guess the default port number for Sql server is 1433

chulett · Post by **chulett** » Thu Jul 02, 2009 2:17 pm

That sounds familiar... but one should still check to find out was it setup with as that default value is not guaranteed to have been used. Or just try it and then check if it doesn't work.

chitravallivenkat · Post by **chitravallivenkat** » Thu Jul 02, 2009 2:26 pm

Hi Guys,

From SQL server side, it is clear. We use the default which is 1433. I wanted to know the port in Datastage side.

Because there is a firewall between Datastage server and Database server.

thanks.

chulett · Post by **chulett** » Thu Jul 02, 2009 2:34 pm

There's no "port on the DataStage side" here, that is the one you need to have opened.

chitravallivenkat · Post by **chitravallivenkat** » Thu Jul 02, 2009 2:43 pm

thanks Chu... & other guys.

Regards,

DSXchange

How to find the Datastage port to communicate SQL server

How to find the Datastage port to communicate SQL server

Re: How to find the Datastage port to communicate SQL server