Bulkcopy requires explicit TrustServerCetificate=yes with Encrypt=No #459

Activity

1. Saurabh Singh (saurabh500)

   changed the title [-]Bulkcopy requires explicit TrustServerCetificate=True with Encrypt=No[/-] [+]Bulkcopy requires explicit TrustServerCetificate=yes with Encrypt=No[/+] on Feb 28, 2026
2. github-actions commented on Feb 28, 2026

   

   github-actionsBot

   on Feb 28, 2026 – with GitHub Actions

   More actions

   Hi Saurabh Singh (@saurabh500), thank you for opening this issue!

   Our team will review it shortly. We aim to triage all new issues within 24-48 hours and get back to you.

   If you have additional information to share, please feel free to update the issue.

   Thank you for your patience!
3. github-actions

   added

   triage neededFor new issues, not triaged yet.For new issues, not triaged yet.

   on Feb 28, 2026
4. Saurabh Singh (saurabh500)

   self-assigned this

   on Mar 3, 2026
5. DanielAdeniji commented on Mar 9, 2026

   

   Daniel Adeniji (DanielAdeniji)

   on Mar 9, 2026

   More actions

   Saurabh Singh (@saurabh500),

   Fam, this has nothing to do with bulk-copy.

   # Why are you running Microsoft SQL Server on port 1434
   
   # by default, Microsoft SQL Server runs on port 1433
   
   #conn = mssql_python.connect("Server=192.168.105.105,1434;Database=aw;Uid=aa;Pwd=[mypwd];Encrypt=No;")
   
   conn = mssql_python.connect("Server=192.168.105.105,1433;Database=aw;Uid=aa;Pwd=[mypwd];Encrypt=No;")
   
   cur = conn.cursor()
   
   cur.execute('create table #x (i int);')
   
   cur.execute('insert into ##x (i) values (-1); ')
   
   cur.execute('drop table #x;')

   As an aside, why are you passing along port 1434?

   By default, SQL Server runs on port 1433.

   Unfortunately, the error that I received is:-

   
   [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.
   
   

   Relief came in specifying "encrypt=no".

   No need for TrustServerCertificate=yes.

   You may want to review the following, as well:-

   1. SQL Server Version

   2. SQL Server SSL Configuration ( is SSL set to be required )

   2a) if SSL is required, specifying "encrypt=no" will not skip the requirement for SSL.

   Thanks for reporting the issue.

   I am not sure how to re-create it .

   In as much as "cur.execute('create table #x (i int);')" works, you should not fail at "cur.bulkcopy('#x', ((r,) for r in range(100)))".

   Failing at bulkcopy will mean the bulkcopy code is attempting a new database connection.

   I will suggest you try

   cursor.execute("select @ServerName")

   in place of the bulkcopy.

   Nice question.

   And, thank you kindly.
6. Saurabh Singh (saurabh500)

   closed this as completedin #475on Mar 12, 2026
7. Gaurav Sharma (bewithgaurav)

   added

   area: bulk-copyIssues in cursor.bulkcopy()Issues in cursor.bulkcopy()

   on Jun 4, 2026