Is it possible to use Windows Authentication for users who are logged into their computer on one domain (ABC) on a particular AD system, for services that are on a second domain (XYZ) on a second AD system?
A user logs into their desktop as
ABC\dev1. They then VPN to a remote system where they have the account
XYZ\remotedev1. They need to access a SQL server on the
XYZ domain through SQL Server Management Studio as
XYZ\remotedev1. When launching SSMS it attempts to use Windows authentication for
ABC\dev1 which of course fails. Is there a way for the user to use their
XYZ\remotedev1 account for access to services on the