trying to setup winauth connection to MSSQL server, between vpn’s connections, no trust between domains, it will not let me override the domain name on the connection properties, it defaults to the domain of the machine where toad is loaded.
When it comes to Windows Authentication, we’re not doing anything with user credentials. It’s all handled transparently by Windows. You cannot tweak WinAuth settings. Are you able to connect in this same scenario using SQL Server Management Studio? In this scenario I am assuming you will need to use SQL Server authentication.