I have a similar case to the one on this thread.
The difference is I don't want to create a linked server. Instead, I just want to use the PI OLEDB Enterprise as a data source connecting directly to PI AF,
Everything works fine if I prompt for credentials or use a specific fixed user, but not if I try and use Windows Authentication.
SQL Server is running with virtual accounts.
SQL Server Reporting Services and PI OLEDB Enterprise Agent are both running with the same domain account.
SPNs have been set for both MSSQLSvc and HTTP services with server name and FQDN.
The account has been granted constrained delegation to PIServer and AFServer.
What else am I missing?