Share via

SSL error while connecting to Azure SQL Database

Prakash M, Bhanu 211 Reputation points
2022-06-16T15:52:31.05+00:00

Azure Application server using "OLEDB Provider"
Getting SSL error from the application wizard when connecting the Azure SQL Server Single DB.

Any recommended provider required for connectivity to Azure SQLDB from Application servers with client drivers?

Azure SQL Database

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Prakash M, Bhanu 211 Reputation points
    2022-06-17T15:50:19.78+00:00

    ---------------------------

    Microsoft Data Link Error

    ---------------------------

    [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.

    ---------------------------

    OK

    ---------------------------

    ---------------------------

    Microsoft Data Link

    ---------------------------

    Login failed. Catalog information cannot be retrieved.

    ---------------------------

    OK

    ---------------------------

    0 comments
  2. Prakash M, Bhanu 211 Reputation points
    2022-06-17T17:19:22.007+00:00

    I have two application servers. APVM1 and APVM2. And AZURE SQL Single DB server.

    APVM1 -> Test connection successful to server.database.windows.net with OLEDB provider
    APVM2 -> Test connection FAILED to server.database.windows.net with OLEDB provider --> So used OLEDB Driver and test got successful

    Can you please let us know how APVM1 is got successful with OLEDB Provider

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.