Nothing worked for this question
Cannot connect to SQL Database. Please contact SQL server team for further support
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,
4 answers
Sort by: Most helpful
-
-
Ali AlEnezi 1,061 Reputation points
2022-12-20T17:20:31.767+00:00 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!
-
AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
2022-12-21T02:41:07.733+00:00 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 -
Sunny Kr Gupta 0 Reputation points
2024-03-18T22:09:27.1+00:00 Hi All,
Go to the below setting in database (skazureserver/skdatabase) -> set server firewall
and allow the checkbookThanks!!