SSL provider:Packaet size too large for SSL Encrypt/decrypt operations [50]

Question

We have recently migrated sqlserver 2005 to 2012.

our .net exe call the below argument to import files from text 

C:\Users\Bachumy\Database Migration\GMCSI.MARS.6\bin\Debug>"bcp" "MR_ARG_GM_CSI.Process.tmpGlobalWtySSS" IN "\\\\mau001appimg01\IMG_GM\T_drive\CSI\PH1\Names\SSSUSfromGlobalSATURNCSIT.2012_11_08.04_12_37.txt" -f "G:\40101_GMCSI\GM CSI\BASE\MARS\Application\temp\DataimportValidate_99.fmt" -SFENSQLMRD20 -1 32764 -m 10 -CRAW -e "G:\40101_GMCSI\GM CSI\BASE\MARS\Application\temp\DataimportValidate_99_20122829112805.cmd.err" -T

and thorws the below exception

starting copy...

Sql state =08S01, native eroor =50

Eroor= [Microsoft][SQL Native Clinent] SSL provider:Packaet size too large for SSL Encrypt/decrypt operations [50].

This issue occurs if the file limit exceeds 13 KB .

Help required on this.Tanking you in advance

Answer 1

Hi Bachu,

SQLState: 08S01 indicates that the communication link between the driver and the data source to which the driver was attempting to connect failed before the function completed processing.

For the error: Packaet size too large for SSL Encrypt/decrypt operations, we can reconfigure the file size using following code:

sp_configure 'packet', size

go

reconfigure with override

Reference:

http://msdn.microsoft.com/en-us/library/aa337544.aspx

---

Iric Wen
TechNet Community Support

Answer 2

Hi Iric,

Thanks for your reply...

i have resolved this issues by changing the packet size from 32764  to 16383.

Regards,

Malli

---

Malli