SSIS job is failing (NETIQKB73232)

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


Security Manager 6.5.x

SQL server 2005



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:


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


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

Additional Information

Formerly known as NETIQKB73232