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

From: Uri Dimant (urid_at_iscar.co.il)
Date: 07/13/05 

Date: Wed, 13 Jul 2005 09:52:51 +0300

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...
> > 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
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: IIS, SQL 2000 & XPs Firewall
    ... Queries to the Data Engine must go to the port that SQL Server is listening ... More info: How to: Configure a Windows Firewall for Database Engine Access ...
    (microsoft.public.sqlserver.connect)
  • Re: Remote connection problems
    ... tab has Listen All as Yes, then the individual settings for IP1 and IP2 are ... like you are listening on dynamic ports and it is currently listening on ... different port. ... and pick a port number you like, and then restart SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Connecting to DB with Static IP over the internet
    ... port and dmz was forward to the incorect internal ip address:) ... and any other ms sql server related ports on the server. ... item on the connection string. ... is listening, I do netstat -a and it does list that it is being listened ...
    (microsoft.public.sqlserver.setup)
  • Re: ADP problems after SQL 2005 Upgrade
    ... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Server not listening on 1433
    ... sql server may be listening in a different port. ... >>> Server error log. ...
    (microsoft.public.sqlserver.setup)
Quantcast