Power Platform Community Forum Thread Details

Hi All,

I am having an issue with SQL Connections when I deploy from Dev to UAT. I have set up connections in both Dev and Test environments using Authentication Type: Service Principal (Microsoft Entra ID Application) and the Data in Dev is showing as expected.

When I come to deploy the Exported Zip Package to the Test Environment I get the usual review and adjust all connections and at this point I switch the Connector to the UAT Connection that I previously set up. I then go ahead import the Solution and open the Application. The application contains 5 stored procedures and one of them pulls data on start, I am not seeing any data in the application.

I then open the application in Edit mode in the test environment (I should not really do this) and check the connections to troubleshoot. Upon removing and reconnecting a Stored procedure I can see that the SQL Server Name and SQL Database Name are pointing to the Dev Server and Database.

Once I add the Server Name and Database for Test and publish the Application works in UAT but with an unmanaged layer. The problem is I do not get the opportunity to update the Test Sql Server Name and Database when I am deploying.

Can anyone help with this one is this a limitation of connecting with Service principals?

I have attached images for reference.

Thanks
Jamie