AnsweredAssumed Answered

PI Vision SQL Login Error

Question asked by craig.dim on Jul 18, 2019
Latest reply on Jul 21, 2019 by craig.dim

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?

 

Thank

Craig

Outcomes