I have a SharePoint server which is using service account "spsharepoint".
For some reason this user has started giving 'Login failed for user DOMAIN\spsharepoint' when I checked SQL Server logs. Turns out it is trying to access 'master' database on which it doesn't have access so the error.
I gave read only access to this user on master database but error is still coming. What could be the issue and how do I fix this?