MS SQL Server security - Need to connect to SQL Server on other side of firewall, listening to a different port.

Author

Need to connect to SQL Server on other side of firewall, listening to a different port.

Pushkar

2005-07-13, 3:23 am

Hi,

I want to communicate to SQL Server through my client. Server is listening
via port 16433 instead of defualt 1433.

And this particular server is on the other side of the firewall and it is in
a workgroup. Client Server is in a domain.

I have tried specifying ServerName,PortNo. but it does not work.

Any one know some other way to communicate to this server. Please help.

Thanks

Pushkar

Uri Dimant

2005-07-13, 3:23 am

Can you show us a connection string?

"Pushkar" <tiwaripushkar@yahoo.co.in> wrote in message
news:OS%23hNh2hFHA.3288@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I want to communicate to SQL Server through my client. Server is listening
> via port 16433 instead of defualt 1433.
>
> And this particular server is on the other side of the firewall and it is
in
> a workgroup. Client Server is in a domain.
>
> I have tried specifying ServerName,PortNo. but it does not work.
>
> Any one know some other way to communicate to this server. Please help.
>
> Thanks
>
> Pushkar
>
>

Pushkar

2005-07-13, 3:23 am

Hi,

I am trying to connect through enterprise browser. And while registering for
the server I am giving server name as

"MyServer,16433"

where 16433 is port on which SQL Server is listening.

Thanks
Pushkar
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:%233IYy92hFHA.2484@TK2MSFTNGP15.phx.gbl...
> Can you show us a connection string?
>
> "Pushkar" <tiwaripushkar@yahoo.co.in> wrote in message
> news:OS%23hNh2hFHA.3288@TK2MSFTNGP09.phx.gbl...
> in
>
>

Mark J. McGinty

2005-07-13, 3:23 am

"Pushkar" <tiwaripushkar@yahoo.co.in> wrote in message
news:u2to5K3hFHA.1412@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I am trying to connect through enterprise browser. And while registering
> for the server I am giving server name as
>
> "MyServer,16433"
>
> where 16433 is port on which SQL Server is listening.

Does the name MyServer resolve on your system? Names must be resolved to IP
addresses (or MAC addresses) using some mechanism, NetBIOS broadcasts, DNS,
WINS -- something. Try pinging it. If you have no reason to believe the
name will resolve, you have no expectation of connectivity with SQL Server.

If you have no mechanism for resolving the name, use the IP address of the
SQL box in place of the name.

Also, are you on the inside of the firewall, or the outside? If you are on
the outside, that port must have been opened by the admin of the firewall.
If you are on the inside, the firewall is *most*likely* not a significant
factor (though that is not exclusively true, a capable firewall can be
configured to block traffic in either direction, it just isn't usually done
that way.)

-Mark

> Thanks
> Pushkar
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:%233IYy92hFHA.2484@TK2MSFTNGP15.phx.gbl...
>
>

Uri Dimant

2005-07-13, 3:23 am

Pushkar
Go to the Client Network Utility and create an alias to SQL Server that is
listening 16433 port
Make sure that TCPIP is at begining of the list.

"Pushkar" <tiwaripushkar@yahoo.co.in> wrote in message
news:u2to5K3hFHA.1412@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I am trying to connect through enterprise browser. And while registering
for
> the server I am giving server name as
>
> "MyServer,16433"
>
> where 16433 is port on which SQL Server is listening.
>
> Thanks
> Pushkar
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:%233IYy92hFHA.2484@TK2MSFTNGP15.phx.gbl...
is[color=darkred]
>
>

Pushkar

2005-07-18, 7:23 am

Hi,

Thanks it works by creating alias.

Thanks
Pushkar
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OfLT1d3hFHA.1148@TK2MSFTNGP12.phx.gbl...
> Pushkar
> Go to the Client Network Utility and create an alias to SQL Server that is
> listening 16433 port
> Make sure that TCPIP is at begining of the list.
>
>
>
> "Pushkar" <tiwaripushkar@yahoo.co.in> wrote in message
> news:u2to5K3hFHA.1412@TK2MSFTNGP09.phx.gbl...
> for
> is
>
>

Sponsored Links