Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Client Certificates and Web Services in SSIS Expand / Collapse
Author
Message
Posted Thursday, June 12, 2008 9:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 7:53 AM
Points: 2, Visits: 43
I have run into an issue recently and was wondering if anyone else has experienced the same problem. I am writting an SSIS package that will need to pass and receive data from a web service and this particular web service requires a certificate to allow access to the methods. I am able to configure the HTTP connection to the correct address for the web service and the client certificate that I need and that connection tests fine. The problem is that when my package process goes to access the web service, I get an error indicating that the client certificate was not provided to the web service. Anyone got any ideas as to what I may be doing wrong here?
Post #516057
Posted Thursday, January 08, 2009 2:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 10, 2010 1:49 AM
Points: 155, Visits: 46
I'm getting this exact same issue - so if anyone can help both of us out that would be great.

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've also ran test bypassing the Proxy and again no joy.

I must have missed something stupid here, seems a simple thing but there we go. I've ordered "The Rational Guide to Extending SSIS 2005 with Script" on the back of Jamie Thompson recommendation as it has a section on consuming web services through script - may well have to go down this route.

SQL 2005 Standard Edition (sp3). .Net Framework 3.5 sp1
Post #632197
Posted Thursday, January 08, 2009 4:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 10, 2010 1:49 AM
Points: 155, Visits: 46
Hi (again!)

I managed to get past this! I had to configure the HTTP connection manager entry with credentials to get past the proxy. Sheldon, you may have already tried this but if not give that a whirl.

Unfortunately - a new error on execution.
"Object reference not set to an instance of an object.."

Anyone any ideas?

Thanks
Post #632232
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse