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

quote:

---

> Hi,
> I'm trying to setup a connection between a remote SQL server 2000 and

---

Query

quote:

---

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

quote:

---

> 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...
> Query
listens[QUOTE]
>

---

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

quote:

---

> 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...
SQL[QUOTE]
to[QUOTE]
> listens
>

---

|||Thanks !
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uJhhgAe4DHA.3436@.tk2msftngp13.phx.gbl...

quote:

---

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

quote:

---

> --
> 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...
and[QUOTE]
> SQL
> to
>

---

|||Yes. You need to make a change in the registry on the SQL Server in order
to do this.
See the following kb for step by step example:
164667 INF: Replication Setup Over a Firewall
http://support.microsoft.com/?id=164667
The preferred method would be using SSL.
324777 Support WebCast: Microsoft SQL Server 2000: How to Configure SSL
http://support.microsoft.com/?id=324777
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.