cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FredericForest
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
a-ovbord
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

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