Share via

Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.

Albert Kirpach 0 Reputation points
2024-05-04T23:34:12.1833333+00:00

Error codeSqlFailedToConnect

DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Cannot open server "uakirpachgmail.onmicrosoft.com" requested by the login. The login failed., SqlErrorNumber=40532,Class=20,State=1,

Activity ID05e17010-37dd-4684-a184-77af7f8aa330

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,864 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vinodh247-1375 11,311 Reputation points
    2024-05-05T06:05:39.1966667+00:00

    Hi ,

    Thanks for reaching out to Microsoft Q&A.

    Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. make sure the SQL Database firewall allows the integration runtime to access.

    if your linked service connection to the sql database fails as provided in the error, did you check if there are any firewall blocks to the IR?

    in your azure sql settings...

    • Click on “Firewalls and virtual networks” under the “Security” heading.
    • In the “Firewall and virtual networks” page, locate the section labeled “Allow Azure services and resources to access this server.”
    • Set this option to “ON”

    are you sure there are no login failures from password or access denial? do check that once.

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

    0 comments
  2. MikeyQiao-MSFT 575 Reputation points Microsoft Vendor
    2024-05-06T06:23:35.1266667+00:00

    Hi，Albert Kirpach

    Have you added @servername to the end of the username on login ？

    0 comments
  3. ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
    2024-05-14T03:57:33.04+00:00

    Hi Albert Kirpach,

    We have not heard back from you.

    Since the error mentions "Cannot open server 'uakirpachgmail.onmicrosoft.com' requested by the login." Verify that the login name specified in your connection string or configuration is correct and has the appropriate permissions.

    Make sure that the SQL Database firewall allows connections from the IP addresses or ranges associated with your integration runtime.

    Please let us know if this helped or not.

    Thanks.

    0 comments