Re: Need to connect to SQL Server on other side of firewall, listening to a different port.
From: Mark J. McGinty (mmcginty_at_spamfromyou.com)
Date: 07/13/05
- Next message: Uri Dimant: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- Previous message: Pushkar: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- In reply to: Pushkar: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- Next in thread: Uri Dimant: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 12 Jul 2005 23:47:18 -0700
"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...
>> 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
>>>
>>>
>>
>>
>
>
- Next message: Uri Dimant: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- Previous message: Pushkar: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- In reply to: Pushkar: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- Next in thread: Uri Dimant: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
