TADOConnection question - In connecting to an MS SQL Server (2014, if it matters) that's got security locking it...

TADOConnection question - In connecting to an MS SQL Server (2014, if it matters) that's got security locking it down to specific machine ID and IP and preventing Windows Authentication, how do you tell it to do Server Authentication? It seems to work at run-time for inexplicable reasons, but I can't get it to connect at design-time. It gives this error:

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Well, yeah, because it's configured to accept SERVER Auth ONLY!

There's no way to enter Server Auth creds into the standard connection dialog that comes up. What's the workaround?

Comments