This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 38%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
I have SQL 2016 server and OS windows server 2016 and if I enabled TLS1.2 on dB server then I am not able to connect to dB seever from application server .I was received SSL related error.What are thing I need to update in my application server and database server
I guess you need to enable TLS 1.2 on the application server as well. What OS is the application server running? What platform is it running on? IIS or something else?
I have enabled TLS 1.2 on app server also.OS 2016.Web service running on IIS
And the exact error message is? Maybe there is something you need to enable for IIS as well? (I'm an SQL Server person, and don't know that much about IIS.)
The reason I'm asking these questions is that the more accurate information you share, the easier it will be for people to help you.
[DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error this error comming
And what clientAPI are you using? What does not your connection string look like?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi Jbowy,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Asp.net and currently using sqloledb
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
most likely your sqlserver does not have a trusted certificate. so you need to add
trustServerCertificate=true
to the connection string
Maybe, but that is not dependent on TLS levels. Rather that depends on whether you have Encrypt option, and whether you are running the very latest drivers.
Hi Jbowy,
[DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error this error comming
This is due to the SQLOLEDB provider not supporting TLS 1.2. If TLS 1.0 and TLS 1.1 are not present or enabled on the server it will break the provider's function, causing an error to appear.
Please refer to this thread: https://knowledge.broadcom.com/external/article/225667/connector-solution-user-rule-import-is-f.html
Please download Microsoft® OLE DB Driver 18 for SQL Server® to your server which features backwards compatibility with SQLOLEDB and can be used as a replacement. Then change the connection string provider from SQLOLEDB to MSOLEDBSQL and recycle the site's application pool.
For more detailed screenshots, you can go to the link above to check it out.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
You mean to web server i need to install new driver to support MSOLEDBSQL
Asp.net and currently using sqloledb
That's a very old provider (20+ years). It ships with the OS, but you should use MSOLEDBSQL19, which is the most recent provider. This may give you new problems, since MSOLEDBSQL19 defaults to requiring encryption by a trusted server certificate.
In order to use MSOLEDB provider name .I need to install latest OLE DB provider on web swever.correct?
One more thing is that. Why it does not come with Windows server OS
Yes, you need to install it on the web server.
The reason it does not come with the OS is that the drivers are updated out of band with the OS. They did include the drivers once with the MDAC in the early naughties, but I think that they regret that they ever did.
Thanks for the information.It will help me in my work.