question

SalihESKOLU-8880 avatar image
0 Votes"
SalihESKOLU-8880 asked ryanchill commented

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

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?

azure-sql-databaseazure-webapps-ssl-certificates
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@SalihESKOLU-8880 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.

0 Votes 0 ·

@SalihESKOLU-8880,

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

0 Votes 0 ·

Hello @ryanchill

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.

0 Votes 0 ·

@SalihESKOLU-8880 Please let us know if you need any further help.

0 Votes 0 ·

1 Answer

ryanchill avatar image
0 Votes"
ryanchill answered ryanchill commented

@SalihESKOLU-8880,

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


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
ryanchill avatar image ryanchill SalihESKOLU-8880 ·

Depending on the hosting provider you're using @SalihESKOLU-8880, 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://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-dotnet-sqldatabase to learn more about it.

Regards,
Ryan

0 Votes 0 ·