SSIS job is failing (NETIQKB73232)

  • 7773232
  • 03-Nov-2011
  • 30-Mar-2012

Environment

Security Manager 6.5.x

SQL server 2005

 

Situation

The SSIS job fails after about 5 minutes and does not process any tables.


This is the error in the SQL logs:

DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.; 08001
This is the error in the SSIS job history:

Resolution

Follow this procedure to stop the SSIS job from using certificates.

1. Go to start\run\regedit

2. Once in the registry go to HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib  or for 64 bit machines go to HKLM\SOFTWARE\WOW6432node\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib

3. On the right side of the screen right click\new\string value

4. Name the string value Certificate

5. Right click the newly created key\modify and give it a value of 0

Cause

This issue occurs due to a certificate that requires SSL communication. 

Additional Information

Formerly known as NETIQKB73232