"[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error" message on ASP page

Question

"[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error" message on ASP page

Salih ESKİOĞLU 1

Hello I write a web page in classic ASP. But when I want to connecto to Azure database, I take error message "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error." After 3-4 times refresh, the page is work. My ASP pages on my hosting provider. And my ASP hoting is using SSL. where is the main problem? On my hosting or Azure settings?

Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2021-03-23T16:00:14.217+00:00

@Salih ESKİOĞLU Thank you for your question. We are checking this and also checking with our WebAPP team for guidance. We appreciate your patience in this regard.
Ryan Hill 30,281 Reputation points Microsoft Employee Moderator

2021-03-25T12:58:40.397+00:00

@Salih ESKİOĞLU ,

Can you provide additional details on the SQL Connection provider you’re using in your ASP application? Also, I want to confirm your database is an Azure SQL Database correct?

Regards,
Ryan
Salih ESKİOĞLU 1 Reputation point

2021-03-25T13:10:04.737+00:00

Hello @Ryan Hill

You can see my connection string below (I removed user namae and pass

Set cnn = CreateObject ("ADODB.Connection")
cnn.Open "Provider=SQLOLEDB;Server=testo-azure-sunucu.database.windows.net,1433;User ID=;Password=.;Initial Catalog=testosis_mini;"

So When I try to connect from on my hosting with SSL, the page give error about SSLsecurity error. So I was put my web pages on without SSL hosting and it is work.
Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2021-03-29T23:53:32.347+00:00

@Salih ESKİOĞLU Please let us know if you need any further help.

1 answer

Your answer

Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2021-03-23T16:00:14.217+00:00

@Salih ESKİOĞLU Thank you for your question. We are checking this and also checking with our WebAPP team for guidance. We appreciate your patience in this regard.
Ryan Hill 30,281 Reputation points Microsoft Employee Moderator

2021-03-25T12:58:40.397+00:00

@Salih ESKİOĞLU ,

Can you provide additional details on the SQL Connection provider you’re using in your ASP application? Also, I want to confirm your database is an Azure SQL Database correct?

Regards,
Ryan
Salih ESKİOĞLU 1 Reputation point

2021-03-25T13:10:04.737+00:00

Hello @Ryan Hill

You can see my connection string below (I removed user namae and pass

Set cnn = CreateObject ("ADODB.Connection")
cnn.Open "Provider=SQLOLEDB;Server=testo-azure-sunucu.database.windows.net,1433;User ID=;Password=.;Initial Catalog=testosis_mini;"

So When I try to connect from on my hosting with SSL, the page give error about SSLsecurity error. So I was put my web pages on without SSL hosting and it is work.
Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2021-03-29T23:53:32.347+00:00

@Salih ESKİOĞLU Please let us know if you need any further help.

Answer 1

Ryan Hill 30,281 Microsoft Employee Moderator

@Salih ESKİOĞLU ,

You didn't specify, but I'm assuming your ASP site is a local intranet site that's connecting to a hosted Azure SQL database. If so, make sure you are using the latest driver for provider. See https://www.sqlnethub.com/blog/dbnetlib-connectionopen-secdoclienthandshake-ssl-security-error-resolve/, it's a blog post that details where to find the latest drivers and how to enable the TLS version on your local machine.

Regards,
Ryan

Salih ESKİOĞLU 1 Reputation point

2021-03-30T06:26:49.11+00:00

Hello

I put my pages to other hosting provider servers. And It was work. I think that my hosting provider has got some settings problems. I contacted with my hosting provider. I hope, they will resolve this problem.

Thanks.
Ryan Hill 30,281 Reputation points Microsoft Employee Moderator

2021-03-30T13:42:49.247+00:00

Depending on the hosting provider you're using @Salih ESKİOĞLU , they may not have latest provider drivers I indicated up above. Also, since you indicated you did deploy your code to a provider, you will need to make sure your Azure database firewall settings are correctly configured to accept connections from that IP. Azure App Services does make this process seamless; see https://learn.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-dotnet-sqldatabase to learn more about it.

Regards,
Ryan

Share via

"[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error" message on ASP page

1 answer

Your answer