I understand that elastic jobs are not supported when using private end points using azure sql db,are elastic database querries supported

Pamidimukkala, Ramakrishna 25 Reputation points
2023-01-27T22:03:15.32+00:00

gettting the following error when trying to use elastic database query in azure sqldatabase

trying to connect to a azure sql database using private end point from another azure sqldatabase

getting the error

failed (error -2146893022, state 0): A connection was successfully established with the server, but then an error occurred during the login pro cess. (provider: SSL Provider, error: 0 - The target principal name is incorrect.)

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 34,056 Reputation points MVP
    2023-01-28T03:07:11.76+00:00

    Private links are currently not supported with elastic query for those databases that are targets of external data sources.

    Source: Elastic queries preview limitations.

    You may want to consider then use SQL Data Sync to sync data between the 2 databases. Please read here if SQL Data Sync can help you as a workaround.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Oury Ba-MSFT 19,581 Reputation points Microsoft Employee
    2023-01-30T19:36:02.22+00:00

    Pamidimukkala, Ramakrishna Thank you for reaching out.

    In addition to @Alberto Morillo answer. Elastic jobs do not support private endpoints in the current public preview. Our team are actively working on enabling private link support for elastic jobs soon. Exact dates are TBD at this point. Elastic queries do not support private endpoints at his point and plans for elastic query feature are still TBD. Azure SQL Managed Instance supports cross-database queries natively.

    Regards,

    Oury


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.