SQL-server and MTS

[André]

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

André

[Clunietp]

You might have to setup MTS to use User Impersonation -- I have found it easier to create a user/password in SQL Server and use that in your connection string within your MTS component. Also, MTS *CANNOT* use connection pooling if you do not use the same username/password, so that's another benefit of doing it like I described.

HTH

Tom