We have a new install of PI-Vision 2017 R2. It is configured to run with a AD service account and when you look at the Vision Admin page it says it is connecting to the Database with the Server account, however the SQL DBA is seeing the following error in his logs
Login failed for user 'domain\Servername$'. Reason: could not find a login matching ......
A SQL trace is indicating that the following process is causing the issue.
PI Visualization Web Service
Ideally we don't want to add the Machine login on the SQL Server to stop the error.
Any suggestions on how to fix this?