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

Question

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

Answer 1

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.

Answer 2

Hi，Albert Kirpach

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

Answer 3

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.