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 interna
l
> 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 throu
gh
> 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 prob
ably makes it tricky
with firewalls (I'm not network expert...). I'm fairly certain that I've rea
d 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.ph
x.gbl...
> Alexis wrote:
> Yes.
>
> Yes.
>
> DTS is a usual SQL Server Client application. All the security implication
s are based on this
> fact.
No comments:
Post a Comment