I am using SDL Web 8.5 in an AWS instance and, as part of some event system code, am trying to connect to a non-Tridion DB on the same DB server.
The connection string is: Integrated Security=true;Server=EC2AMAZ-B3R11EB;Database=Tridion_cm_poc1_Supplemental_Data
The WindowsIdentity User: NT AUTHORITY\NETWORK SERVICE
The server name is: EC2AMAZ-B3R11EB
The WindowsIdentity User: NT AUTHORITY\NETWORK SERVICE
The Environment User Domain Name: WORKGROUP
The Environment Machine Name: EC2AMAZ-B3R11EB
And yet the error that I'm getting, in the CMS, is:
Initialization of the extension
'C:\PublishingHistoryLog\EventSystem.PublishHistoryLogger.dll' failed.
Cannot open database "Tridion_cm_poc1_Supplemental_Data" requested by the login.
The login failed. Login failed for user 'WORKGROUP\EC2AMAZ-B3R11EB$'.
There is no WORKGROUP\EC2AMAZ-B3R11EB user.
What am I missing with this? Why is the current user being returned, from SQL Server, as a user that doesn't exist?