registering SQL Server behind firewall

We just implemented a SQL Server, that is in a PDMZ
(public facing dmz). It is using a local account to run
the services as it it not on our corporate network. We
cannot register the server. Does anyone know what ports
need to be open, in order to register this SQL Server? In
talking with our network folks, I'm pretty sure 1433 /
1434 are open. Any ideas...Thanks.
Tom.INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/?id=287932
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tom Mongold" <tom.mongold@.stdreg.com> wrote in message
news:024a01c35606$4072e550$a401280a@.phx.gbl...
We just implemented a SQL Server, that is in a PDMZ
(public facing dmz). It is using a local account to run
the services as it it not on our corporate network. We
cannot register the server. Does anyone know what ports
need to be open, in order to register this SQL Server? In
talking with our network folks, I'm pretty sure 1433 /
1434 are open. Any ideas...Thanks.
Tom.

Register SQL Server BCP.exe utility

Dear All,

I am facing problem related bulk copy program utility. I have both SQL Server 2000 and SQL server 2005 installed on my PC. The current registered BCP.exe is of version 8.0. When i give command BCP.exe with database of SQL Server 2005 on command prompt it actually check the database in SQL Server 2000. The problem resolved if i the complete directry path is selected i-e C:\Program Files\Microsoft SQL Server\90\Tools\Binn. But i want to enter command on every selected directry on command prompt.

Regards

Haseeb Ahmad

I'm not certain what you're asking here - but if you want the 2005 version of BCP to be the default, change your PATH variable in the operating system to have the binary directories for SQL Server 2005 to be above the ones for SQL Server 2000. You can also create a batch file in the operating system to use instead of calling BCP.EXE that has the full path in it if you don't want to change the PATH variable.|||

Thanks a lot for your help. After changing the path in enviornment variable, the problem has been resolved.

Once again thank you for your cooperation.

Haseeb Ahmad