I'm having a problem connecting to my SQL server.

while debugging from the VB IDE, I have no problems getting access to the Database.
But once my component is compiled as a com and later installed in an MTS package, I no longer can get a connection!!!

I have tried to give tha package an identity, and on my connection string I write Trusted_connection=yes
but in vain,

please do advise

thanxx in advance