DTC and firewalls

We have a requirement to utilize MS-DTC from internet facing to an internal
system running SQL Server 2000. Can the DTC be stand alone on a dedicated
server in the external environment and then contact the SQL database through
a specific port? Is this technically possible? Any security implications?Alexis wrote:
> We have a requirement to utilize MS-DTC from internet facing to an internal
> system running SQL Server 2000. Can the DTC be stand alone on a dedicated
> server in the external environment and then contact the SQL database through
> a specific port?
Yes.
> Is this technically possible?
Yes.
> Any security implications?
DTS is a usual SQL Server Client application. All the security
implications are based on this fact.|||Yura, perhaps you misread DTC as DTS. DTC, AFAIK, speaks only RPC which probably makes it tricky
with firewalls (I'm not network expert...). I'm fairly certain that I've read a KB about this,
should be relatively easy to find.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Yura Shalak" <yuras@.nospam.nospam> wrote in message news:up%23UoeohHHA.1456@.TK2MSFTNGP04.phx.gbl...
> Alexis wrote:
>> We have a requirement to utilize MS-DTC from internet facing to an internal system running SQL
>> Server 2000. Can the DTC be stand alone on a dedicated server in the external environment and
>> then contact the SQL database through a specific port?
> Yes.
>> Is this technically possible?
> Yes.
>> Any security implications?
> DTS is a usual SQL Server Client application. All the security implications are based on this
> fact.