How do I let my users decide between either using a trusted connection to a server or providing their own credentials? Either way I need to execute scripts under that context.
I realize I could use condition for the entire sql connection, and setup options that satisfy either condition, but I'd rather not have to duplicate trees if possible. If you have two sql scripts that point to the same resource, is it only included once in the installer? It's a multi-megabyte file and I'd like to prevent unnecessary bloat. If setting up the dual connections is the only route, will setting the condition at the server level prevent the script from running?
Thanks.
Suggested Articles
Re: Giving a choice for trusted database connections
Hi,
In order to achieve what you want you can create a "Custom connection" and follow the steps described in the How do I set the authorization type of an SQL connection tutorial.
Let us know if this helped.
Best regards,
Eusebiu
In order to achieve what you want you can create a "Custom connection" and follow the steps described in the How do I set the authorization type of an SQL connection tutorial.
Let us know if this helped.
Best regards,
Eusebiu