Calling a COM object on a different server

[Badgers]

Help,

I have realised you can call COM objects from DTS scripts
within SQL server, my problem is that how do you call a
COM object on a different server ?

The code :

dim oCalc
Set oCalc = CreateObject("Projectid.ClassId","ServerName&quot

When ever I put the server name the script falls over,
could it be permissions of some kind ?

 

[SemperFiDownUnda]

I assume you have the proxy stub installed locally?

 

[Badgers]

Proxy stub ?

Well ur, the component is installed in MTS. I've found an instance of the object is created, but when the function call is required it returns Permission denied.

I have looked at the security of MTS and allowed just about every man and dog access to the component, but I still get the same error ?

Any ideas would be a great help.

 

[SemperFiDownUnda]

Is the Component running under a domain account?
Is the account on the client end a domain account?