TLS 1.0 is manditory for SQL to work?

• chinna1214

  SSC Enthusiast

  Points: 198

  More actions

  July 25, 2018 at 11:45 pm

  #358862

  Hello All,

  Recently we had an issue with Integration services, when disabling TLS protocol at server level integration services failed to execute the packages. So we have enabled the TLS again and it worked fine.

  Now the questions is, Does TLS really require for SQL server server to communicate ??
  Which version of SQL version relies on which version of TLS??
  Is there a way that we can know if TLS is being used by SQL or not??
  TLS 1.0 supports which version of SQL server?
  TLS 1.2 supports which version of SQL server?/

  Please help.

  Thanks in advance.

• Eirikur Eiriksson

  SSC Guru

  Points: 182912

  More actions

  July 26, 2018 at 12:23 am

  #1999035

  harishamballa - Wednesday, July 25, 2018 11:45 PM

  Hello All,

  Recently we had an issue with Integration services, when disabling TLS protocol at server level integration services failed to execute the packages. So we have enabled the TLS again and it worked fine.

  Now the questions is, Does TLS really require for SQL server server to communicate ??
  Which version of SQL version relies on which version of TLS??
  Is there a way that we can know if TLS is being used by SQL or not??
  TLS 1.0 supports which version of SQL server?
  TLS 1.2 supports which version of SQL server?/

  Please help.

  Thanks in advance.

  I would be concerned if anything other than TLS 1.2 was being used as both SSL and earlier versions of TLS have known security vulnerabilities.
  😎

• chinna1214

  SSC Enthusiast

  Points: 198

  More actions

  July 26, 2018 at 12:33 am

  #1999036

  Eirikur Eiriksson - Thursday, July 26, 2018 12:23 AM

  harishamballa - Wednesday, July 25, 2018 11:45 PM

  Hello All,

  Recently we had an issue with Integration services, when disabling TLS protocol at server level integration services failed to execute the packages. So we have enabled the TLS again and it worked fine.

  Now the questions is, Does TLS really require for SQL server server to communicate ??
  Which version of SQL version relies on which version of TLS??
  Is there a way that we can know if TLS is being used by SQL or not??
  TLS 1.0 supports which version of SQL server?
  TLS 1.2 supports which version of SQL server?/

  Please help.

  Thanks in advance.

  I would be concerned if anything other than TLS 1.2 was being used as both SSL and earlier versions of TLS have known security vulnerabilities.
  😎

  Is TLS mandatory for SQL to run ?

• Eirikur Eiriksson

  SSC Guru

  Points: 182912

  More actions

  July 26, 2018 at 1:40 am

  #1999037

  harishamballa - Thursday, July 26, 2018 12:33 AM

  Eirikur Eiriksson - Thursday, July 26, 2018 12:23 AM

  harishamballa - Wednesday, July 25, 2018 11:45 PM

  Hello All,

  Recently we had an issue with Integration services, when disabling TLS protocol at server level integration services failed to execute the packages. So we have enabled the TLS again and it worked fine.

  Now the questions is, Does TLS really require for SQL server server to communicate ??
  Which version of SQL version relies on which version of TLS??
  Is there a way that we can know if TLS is being used by SQL or not??
  TLS 1.0 supports which version of SQL server?
  TLS 1.2 supports which version of SQL server?/

  Please help.

  Thanks in advance.

  I would be concerned if anything other than TLS 1.2 was being used as both SSL and earlier versions of TLS have known security vulnerabilities.
  😎

  Is TLS mandatory for SQL to run ?

  Only if ForceEncryption is set ON for the server.
  😎

• chinna1214

  SSC Enthusiast

  Points: 198

  More actions

  July 26, 2018 at 1:50 am

  #1999041

  Eirikur Eiriksson - Thursday, July 26, 2018 1:40 AM

  harishamballa - Thursday, July 26, 2018 12:33 AM

  Eirikur Eiriksson - Thursday, July 26, 2018 12:23 AM

  harishamballa - Wednesday, July 25, 2018 11:45 PM

  Hello All,

  Recently we had an issue with Integration services, when disabling TLS protocol at server level integration services failed to execute the packages. So we have enabled the TLS again and it worked fine.

  Now the questions is, Does TLS really require for SQL server server to communicate ??
  Which version of SQL version relies on which version of TLS??
  Is there a way that we can know if TLS is being used by SQL or not??
  TLS 1.0 supports which version of SQL server?
  TLS 1.2 supports which version of SQL server?/

  Please help.

  Thanks in advance.

  I would be concerned if anything other than TLS 1.2 was being used as both SSL and earlier versions of TLS have known security vulnerabilities.
  😎

  Is TLS mandatory for SQL to run ?

  Only if ForceEncryption is set ON for the server.
  😎

  Thnx for the reply.

  Which version of SQL server supports TLS 1.0 and which version of SQL supports TLS 1.2 ?

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  July 26, 2018 at 2:00 am

  #1999042

  chinna1214 - Thursday, July 26, 2018 1:50 AM

  Thnx for the reply.

  Which version of SQL server supports TLS 1.0 and which version of SQL supports TLS 1.2 ?

  TLS 1.2 Support for SQL Server

  Steve Hall
  Linkedin
  Blog Site