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

Venkateswarlu Y 6 Reputation points
2022-12-20T17:10:54.27+00:00

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,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Jeevan Srikanth Nalla 5 Reputation points
    2024-06-21T23:15:03.6666667+00:00

    Nothing worked for this question

    1 person found this answer helpful.
    0 comments No comments

  2. 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!

    0 comments No comments

  3. AniyaTang-MSFT 12,421 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

    0 comments No comments

  4. 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 checkbook

    Screenshot 2024-03-19 at 3.34.25 AM

    Thanks!!

    0 comments No comments