Connection failed: connection not configured for this service
Pretty new to Power Apps but have been enjoying building my first small business app, however I could do with some help if anyone is able to assist.
The app connects to a single in premise SQL server database, reading from a couple of stored procedures and writing to one table (connection via SQL Server Authentication and installed Power Apps Gateway). There are no flows involved.
My tested App is in a dev environment (non default env) within a solution and has been tested on a tablet (android) already and functionality-wise is ready to be used in the business. I need to finalise the deployment side of things but have been struggling to find clear guides on what I need to do.
I've created a production environment, and the app will connect with different databases in dev and production instances. I have 5 per plan licenses already allocated to the prod environment.
I've been struggling with the process for a few days re exporting from dev and importing into prod environment as managed solution and getting the connection references etc working. I've done a lot of googling and used chat GPT but haven't got to a working process yet.
I've got to the point time-wise where I decided, as an interim measure to buy me time to work out the proper ALM process, to import the app into the prod and push live as an unmanaged solution. Once in the prod env then manually removed all the dev database connections from the app and replaced with connections to the prod database.
All works now under my login (premium Power Apps license) in prod environment on desktop, but for the user acct I've shared the app with (tablet based) it's asking to Allow the SQL Server connection each time opening it, and when open it's showing 'CONNECTION DETAILS failed: connection not configured for this service.' when trying to read from a SQL stored procedure, so simply not connecting.
I figure this is the most critical thing for me to resolve currently - I've tried below, but most posts for this error seem to relate to flows which I'm not using:
- In power platform admin center, granted app users security roles of 'App Opener' & 'Basic User' (diagnostic shows as "User Status: Enabled").
- Clearing storage and cache of Power Apps app on tablet, re-signing in - numerous times.
I'm almost definitely missing something here so any pointers on what to check/change would be massively appreciated.