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:
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