How can I set up SSL for a data source connection in WF? This is for a SQL Server I need to update.
Is it that way by default? I do not see any options for enabling it
It's not something that Workflow would handle, it's up to the driver. John is right about the direct connection one. If you are using a Windows ODBC data source, the option is in their user interface. See Microsoft's SQL documentation on how to set it up.
I haven't tested this, but I have used some setups that worked better with connection strings and I would imagine you would be able to add this using the "Expert (Connection Strings)" section of a server setup, just pop in something like
Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;
Trusted_Connection=yes;Encrypt=yes;
http://www.connectionstrings.com/sql-server/
This is assuming you already have the certificates already setup and running.
Can anyone else comment? I would love to hear from a LF employee