Hello, He recently added a SQL Server DataMart within our domain. EG users need to connect to this data source.. The issue is we have several domains. Our client, EG users, sit in Domain A. But EG does not run the script on the client. It passes it to the SAS server which sits in Domain B . They need to connect to the DataMart, using Windows Authentication, to a SQL Server machine which sits back in Domain A. I was thinking this might be resolved by using s Domain_A/sassrv user as my spawner user and granting this user Trusted Delegation. Has anyone come across this type of infrastructure before.
... View more