Muliprotocol Encryption with Firewall ?

Hi,
I'm trying to setup a connection between a remote SQL server 2000 and Query
Analyser using an encrypted Multiprotocol connection but because the SQL
server is sitting behind a firewall I'm having trouble finding a way to
connect - is there any way to specify the port that the SQL server listens
on for this protocol rather than the default random assignment ?
Thanks,
Dave.Any reason you can't use SSL ? Just wondering why you are using
multiprotocol as it is really just included in SQL2000 for backwards
compatability.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm trying to setup a connection between a remote SQL server 2000 and
Query
> Analyser using an encrypted Multiprotocol connection but because the SQL
> server is sitting behind a firewall I'm having trouble finding a way to
> connect - is there any way to specify the port that the SQL server listens
> on for this protocol rather than the default random assignment ?
> Thanks,
> Dave.
>|||No - SSL sounds good - what port does that connect on though ?
Thanks,
Dave.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...
> Any reason you can't use SSL ? Just wondering why you are using
> multiprotocol as it is really just included in SQL2000 for backwards
> compatability.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I'm trying to setup a connection between a remote SQL server 2000 and
> Query
> > Analyser using an encrypted Multiprotocol connection but because the SQL
> > server is sitting behind a firewall I'm having trouble finding a way to
> > connect - is there any way to specify the port that the SQL server
listens
> > on for this protocol rather than the default random assignment ?
> >
> > Thanks,
> >
> > Dave.
> >
> >
>|||It works at the SuperSocket Net-Library level so no new ports are required
to be open. You can use TCP/IP, Named Pipes etc as it sits behind them all.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
news:ODHODCd4DHA.1428@.TK2MSFTNGP12.phx.gbl...
> No - SSL sounds good - what port does that connect on though ?
> Thanks,
> Dave.
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...
> > Any reason you can't use SSL ? Just wondering why you are using
> > multiprotocol as it is really just included in SQL2000 for backwards
> > compatability.
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> >
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> >
> > "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> > news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I'm trying to setup a connection between a remote SQL server 2000 and
> > Query
> > > Analyser using an encrypted Multiprotocol connection but because the
SQL
> > > server is sitting behind a firewall I'm having trouble finding a way
to
> > > connect - is there any way to specify the port that the SQL server
> listens
> > > on for this protocol rather than the default random assignment ?
> > >
> > > Thanks,
> > >
> > > Dave.
> > >
> > >
> >
> >
>|||Thanks !
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uJhhgAe4DHA.3436@.tk2msftngp13.phx.gbl...
> It works at the SuperSocket Net-Library level so no new ports are required
> to be open. You can use TCP/IP, Named Pipes etc as it sits behind them
all.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> news:ODHODCd4DHA.1428@.TK2MSFTNGP12.phx.gbl...
> > No - SSL sounds good - what port does that connect on though ?
> >
> > Thanks,
> >
> > Dave.
> >
> >
> > "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> > news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...
> > > Any reason you can't use SSL ? Just wondering why you are using
> > > multiprotocol as it is really just included in SQL2000 for backwards
> > > compatability.
> > >
> > > --
> > > HTH
> > >
> > > Jasper Smith (SQL Server MVP)
> > >
> > > I support PASS - the definitive, global
> > > community for SQL Server professionals -
> > > http://www.sqlpass.org
> > >
> > >
> > > "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> > > news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> > > > Hi,
> > > >
> > > > I'm trying to setup a connection between a remote SQL server 2000
and
> > > Query
> > > > Analyser using an encrypted Multiprotocol connection but because the
> SQL
> > > > server is sitting behind a firewall I'm having trouble finding a way
> to
> > > > connect - is there any way to specify the port that the SQL server
> > listens
> > > > on for this protocol rather than the default random assignment ?
> > > >
> > > > Thanks,
> > > >
> > > > Dave.
> > > >
> > > >
> > >
> > >
> >
> >
>