Views:

Applies to Product - Power Apps

What’s happening?
Power Platform Administrators are unable to manage orphaned SQL Server connections, particularly when the original owner has left the organization. This results in challenges when attempting to update permissions or delete these connections.
 

Reason:
When SQL Server connections are created by users who later leave the organization, the connections become ownerless. As a result, other administrators lack the necessary permissions to manage or remove them through the Power Platform interface.
 

Resolution:
Administrators can resolve this using the following approaches:
1. Delete Orphaned Connections via PowerShell
    Use PowerShell to identify and delete SQL Server connections that are no longer needed. This bypasses the permission restrictions present in the Power Platform UI.

  • Refer to the https://learn.microsoft.com/powershell/powerapps/powerapps-powershell for cmdlets like Remove-AdminPowerAppConnection.
2. Recreate and Share the Connection
    If the connection must be retained:
  • Create a new SQL Server connection using an active account with appropriate permissions.
  • Share the new connection with the necessary users or apps.