Hey @SASKiwi ,
This looks very familiar. I've attached links to the two SAS notes that I use when setting up SQL Server connections.
https://support.sas.com/kb/42/605.html
https://support.sas.com/kb/48/348.html As you can see from 42605: Important note: This type of authentication does not support supplying a user ID in the form of Domain\Userid from the connection in SAS. Authentication of the user ID is done through the use of Kerberos in the operating system. No user ID or password are required on the connection string in SAS.
That seems to be what we're seeing here with your situation. Even though you have the AuthDomain defined correctly, the actual authentication is being done via Kerberos. The user/password, or in this case, the AuthDomain, is not actually passed to the database.
I hope these notes help. I refer to them often when setting up MS Sql Server connections. We have some that use database id's and require AuthDomains, and some that use Kerberos.
Hope this is helpful.
... View more