14-02-2018, 11:38 AM
Please don't ask in every post for a screenshot - I try to explain you how it works - make no sense to give you a screenshot with the same...
As I told you before - READ is in general enough to start the connection - what does the "users" see if they open the connection properties? Perhaps somebody selected in Properties anything else than "Use Inherited" (or where ever you specified your creds)? Just open the properties, goto Credentials and look which category is selected (orange). You should see there the credentials that are assigned (if user has permissions for these creds). If you wish that users can switch between these catgeories I gave you instructions above how to enable this!
If the users can see credentials in the "Assigned creds" of the Connection these credentials will work - believe me, there are so many customers that are using this configuration!
As I told you before - READ is in general enough to start the connection - what does the "users" see if they open the connection properties? Perhaps somebody selected in Properties anything else than "Use Inherited" (or where ever you specified your creds)? Just open the properties, goto Credentials and look which category is selected (orange). You should see there the credentials that are assigned (if user has permissions for these creds). If you wish that users can switch between these catgeories I gave you instructions above how to enable this!
If the users can see credentials in the "Assigned creds" of the Connection these credentials will work - believe me, there are so many customers that are using this configuration!
Regards/Gruss
Oliver
Oliver