Share via

SSMS cannot connect to PaaS SQLServer

Keogh, Steve 0 Reputation points
2024-03-07T15:33:32.13+00:00

Hello All

SQL Server Management Studio SSMS 19.3.4.0

Cannot connect to xxxxxxxx.database.windows.net

Azure PowerShell authentication failed due to an unknown error. See the troubleshooting guide for more information. https://aka.ms/azsdk/net/identity/powershellcredential/troubleshoot. The system cannot find the path specified. (Azure.Identity)

All feedback welcome

Thanks

Steve

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator
    2024-03-07T17:14:44.3666667+00:00

    @Keogh, Steve I just tired with Entra id and I don't see any issues connecting, I hope you have followed the steps from the below document and selected the correct Authentication.

    Have you created Service principal and register it to the app?

    User's image

    https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity?view=azuresql

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.