Okay, I am finally posting this here because every other Q&A I've found is talking about using impersonation on a SQL Agent Job and I don't need that (yet). I simply just trying to execute SQL queries in an SSMS window using impersonation to view data on a linked server.
I've gone through the following link extensively:
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms188304(v=sql.105)?redirectedfrom=MSDN
And this blog post explains the conundrum perfectly, but it's like 12 years old... so surely SOMEONE has gotten this to work, right?
Anyways, here's a rundown of my config:
Local Server: (LocalSQLUser & LocalDomainUser)
DB Trustworthy ON
SPNs created
Delegation Enabled
Linked Server connection created (Mapped LocalSQLUser to RemoteDomainUser, With all connections using current login's security context)
Remote Server: (RemoteDomainUser)
DB Trustworthy ON (RemoteDBOwner granted AUTHORIZE)
SPNs created
Delegation Enabled
Permissions granted to a specific view for RemoteDomainUser
Currently getting anonymous login error message when trying to run SELECT on view after successfully running EXECUTE AS [RemoteDomainUser].