Cannot connect to SQL Database. Please contact SQL server team for further support

Question

Hi,

I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database: 'sqldb-gt- XXX', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Can not connect to the database in its current state., SqlErrorNumber=40925,Class=20,State=1, Activity ID: f1c7c42c-e06d-49e8-b4fc-af851c05aa7e.

Thanks,

Answer 1

Hello @Venkateswarlu Y ,

I sorry for the issue you are experiencing when trying to connect to an Azure SQL Database using a private endpoint and Azure Integration Runtime (IR). There could be several reasons for this error, and it would be helpful to gather more information to help troubleshoot the issue.

Here are a few things you can check:

• Verify that the linked service configuration is correct. Make sure that the correct server name, database name, and user credentials are being used.
• Check the firewall settings on the Azure SQL Database to make sure that the Azure Integration Runtime is allowed to access the database. You can do this by going to the "Firewalls and virtual networks" section in the Azure SQL Database blade in the Azure portal.
• Make sure that the Azure Integration Runtime is able to communicate with the Azure SQL Database over the private endpoint. You can check this by using a tool like ping or traceroute to test connectivity between the two resources.
• If you are using Azure Active Directory (AD) authentication, make sure that the user account you are using has the necessary permissions to access the Azure SQL Database.
• Check the logs for the Azure Integration Runtime to see if there are any additional error messages or details that can help to identify the cause of the issue.

Good luck!

Answer 2

Hi @Venkateswarlu Y
I found this link for you, please check if your connection steps are correct: tutorial-private-endpoint-sql-portal.
Best regards,
Aniya

Answer 3

Hi All,

Go to the below setting in database (skazureserver/skdatabase) -> set server firewall
and allow the checkbook

Thanks!!

Answer 4

I got the same error with user managed identity, but I tried creating a user and given a role in azure sql database and tried connection again and it worked.