a server i look after is coming up with following error only with domain users, i can run reports okay as domain admin…
this server has always had some sort of issue with sql permissions, now it seems i am unable to access sql views as domain users. The permissions in sql server look okay to me? can any one help?
I also found this error in SQL Server
Date 6/17/2020 3:10:48 AM
Log SQL Server (Current - 6/17/2020 3:10:00 AM)
Login failed for user ‘NT AUTHORITY\SYSTEM’. Reason: Failed to open the explicitly specified database. [CLIENT: ]