AnsweredAssumed Answered

Is it possible to configure Windows Authentication for MS Reporting Services using PI OLEDB Enterprise without a linked server?

Question asked by Guilherme Ferreira Champion on Oct 5, 2017
Latest reply on Oct 6, 2017 by vkaufmann

Hello all!

 

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?

 

Regards

Outcomes