I've been tasked with resolving the following error that's appearing in our SQL Logs every few minutes.
Login failed for user 'domain\workflowxxx-svc. Reason: 'Failed to open explicitly specified database 'DB_Name'.[Client: IP address of WFE Server] Error: 18456 Severity 14, State 38.
I've googled the error but the solutions all seem to need me to interrogate the DB using SQL or make it a member of the Farm Administrators Group.
This is a SharePoint SQL Server and I'm pretty sure doing that is not encouraged and can leave you unsupported if you try.
Adding it to the Farm Administrators group seems like Overkill to me.
I've checked the Account has permissions to the SQL Server and I think it does but I'm no SQL permissions expert.
Is there a way I can determine what is causing this without having to run SQL Queries against the DB ?