Hi All - new boy here and happy New Year to you...

I have a problem I could do with some pointers on. I have an SSIS package
to consume a Web Service provided by a 3rd party. This Web Service needs a
digital certificate installed to the Personal Store, I have installed this
fine and can confirm everything lives where it should.

I can create a HTTP Connection through SSIS fine and can select and use the
correct certificate and can test the connection successfully. Problem is
when trying to create the Web Service Task. I select the HTTP connection yet
when I test I get a "cannot create TLS/SSL" error which suggests it's not
using the certificate.

SSIS is using a "Network Service" account and I have used the WinHttpCertCfg
utility to give the service access to the certificate but still no joy. I
must have missed something stupid here.

SQL 2005 Standard Edition (sp1). .Net Framework 3.5 sp1

If you need any more information from myself - just ask. Any and all help
very much appreciated

--
Patrick Delaney

Didn't think it would help but I have upgraded to SQL 2005 sp3. I have also
run tests bypassing our Proxy server.

Unfortunately we're still getting this issue.

Thanks
Pat

just for the sake of building up history for other people. Looks like the
'Test Connection' isn't a true test of connection as I needed to supply the
HTTP connection manager a set of proxy credentials to get past this.

Still getting an error though - Object reference not set to an instance of
an object..

Anyone any ideas on this one?

Thanks
Pat