Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [tls-1.2]

Transport Layer Security (TLS) is a protocol that provides privacy and data integrity between two communicating applications.

Microsoft SQL Server now supports TLS 1.2 protocol. TLS stands for Transport Layer Security. It is a certificate used for data encryption over network.

TLS is an advance version of SSL.

More info can be found on https://blogs.msdn.microsoft.com/sqlserverfaq/2012/04/04/can-tls-certificate-be-used-for-sql-server-encryption-on-the-wire/

44 questions
24
votes
4 answers

Enable TLS 1.2 for SQL Server 2016 database mail

I have been puzzled by this issue for almost 1 week. Hopefully someone in our community has experienced the same issue and already found a solution. So here is my problem: As per our company policy, we want database mail to be able to send emails…
jyao
  • 3,083
  • 1
  • 14
  • 27
8
votes
1 answer

What are the "GDR" vs "QFE" hotfixes for SQL Server 2008 R2 SP3?

I'd always assumed that higher patch numbers were necessarily later releases, but now I'm not so sure. Looking at the SQL Server Build List for SQL Server 2008 R2 SP3, there are two possible ways to apply security update MS15-058, one labeled "GDR",…
BradC
  • 10,073
  • 9
  • 51
  • 89
5
votes
1 answer

Why does TLS1.2 break connections to SQL Server?

I have a Client who moved to TLS 1.2, which broke an app that connects to SQL Server 2017 and it got dumped on my lap. Being a Linux person all I can say is when they went back to TLS 1.1 it worked and here is the only error message I can glean in…
Marinaio
  • 207
  • 3
  • 14
5
votes
1 answer

TLS 1.2 breaks SQL Server linked servers

As part of a recent security blitz we set up TLS 1.2 on all of our servers. Last night I flipped the "Force Encryption" flag on all of our SQL Servers and since then I've had a weird issue with linked servers. I have two servers; Server A running…
Gavin Harris
  • 135
  • 1
  • 7
4
votes
1 answer

Some basic questions about SQL and TLS 1.0 and 1.2

(I don't believe this is a duplicate of any other TLS-related question, like the authoritative question about SQL Compatibility with TLS or its many duplicates, or questions about specific TLS-related issues you might encounter with SQL CLRs or…
BradC
  • 10,073
  • 9
  • 51
  • 89
4
votes
2 answers

SSRS using external images through tls 1.2 leaves src(unknown)

One of our SSRS reports loads images from external sources and one of these sources has been locked down to tls 1.2 (which is fair and we're expecting more of our clients to be doing this in the future) The tls 1.2 update has been applied to the…
Ste Bov
  • 2,101
  • 1
  • 14
  • 19
3
votes
0 answers

Configure SQL server to force encryption programmatically

I'd like to enable the ForceEncryption flag for SQL server programmatically. I tried: Set-ItemProperty ` -Path "Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib" ` -Name ForceEncryption ` …
Ceilingfish
  • 131
  • 2
3
votes
1 answer

Limit TLS and Cipher Suites on SQL Server 2016-2019

I'm wanting to configure some SQL 2016+ servers to use only TLS 1.2+ and a subset of Cipher suite options (no ciphers considered weak or compromized). I'm having trouble tracking down how to configure these options. Where would I find the…
Tracker1
  • 201
  • 2
  • 8
3
votes
1 answer

Where is MSOLEDBSQL provider driver? "The 'MSOLEDBSQL' provider is not registered on the local machine."

This has been going on. At first MS said they will not support TLS1.2 for OLEDB then they said, they will. You can read about it here, where they said, the support comes in March 2018 Now it looks like package has arrived. I installed it. Then I ran…
T.S.
  • 216
  • 1
  • 3
  • 11
3
votes
1 answer

Application Server is not able to connect to SQL Server database when TLS 1.2 or 1.1 is enabled

In our environment, SQL Server 2012 Servers whenever TLS 1.2 or TLS 1.1 is enabled Application Server is not able to connect to the database.The same issue is observed only on MS SQL Server 2012 related Servers. Error Message: Connection failed: …
Sin
  • 31
  • 1
  • 1
  • 3
3
votes
1 answer

Linked Server Setup Error - SSL Provider: The client and server cannot communicate, because

I am trying to setup a linked server and ending up with the following error. Error: SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm. Environment: Linked server is being created on Microsoft…
Santhoshkumar KB
  • 581
  • 2
  • 9
  • 22
2
votes
2 answers

Can one TLS certificate be used for multiple instances of SQL Server?

Windows 2022, SQL Server 2022, FCI cluster with 2 physical nodes. 5 instances of SQL Server running on the FCI cluster. I need to have TLS certification running on all 5 instances of SQL Server. Can a single TLS certificate (installed on the…
SQL_Hacker
  • 531
  • 4
  • 15
2
votes
1 answer

Is there a way for mongodb clients to connect to mongodb server (SSL/TLS enabled) without client certificates?

I am trying to setup a MongoDB with SSL/TLS enabled. I'm just wondering is there a way for clients to connect to my mongodb server without having a client certificate that would not compromise the security? (not considering…
JRA
  • 137
  • 3
  • 17
2
votes
0 answers

Configuration of TCP/IP with SSL and TLS for Oracle

I am trying to configure the connections to my Oracle database with tcp / ip using ssl I have been guided by the procedure of the site https://oracle-base.com/articles/misc/configure-tcpip-with-ssl-and-tls-for-database-connections site in which I…
Arnaldo Raxach
  • 145
  • 7
  • 18
2
votes
1 answer

Enable TLS 1.2 and disable SSL 3 on SQL Server 2008

I know similar questions have been asked. What I'm asking for are concrete instructions on what to do, or not do, for my particular installation. I have some questions that I can't find the answer to, and I need some answers before I can install…
Jam
  • 155
  • 1
  • 2
  • 6
1
2 3