cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kudo Kingpin
Kudo Kingpin

Updating new SQL connector

So I started using the new SQL Connector with delegated identy. Great! 

Somehow, I don't need to define a target server or database. Strange... Anyhow.

I'm moving my app from a dev environment to a test one and I need to change the connector to point to a test SQL Backend... and... the interface doesn't seem to allow that (whaaa?).

 

Am I missing something?

2 REPLIES 2
Microsoft
Microsoft

Hi @FredericForest,

 

Is this the connector you're trying to use?

image.png

Thank you,

Ovidiu Bordea

Yes, but with the identification type as Azure AD Integrated. You loose the ability to specify a target server and database (which is kinda weird to me but hey). Therefore, as I moved the app from my dev to test environnement, my connected tables still point to the test database and there doesn't seem to be a way to modify that. The only way I found was by deleting all the connections and re-adding them with the proper DB. I was wondering if I just missed something or if the functionality is just not developped yet.

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (54,609)