I'm seeing thousands of rows in our error log about failed logins:
Error: 18456, Severity: 14, State: 38.
Login failed for user 'Ourcompany\myaccount'.
Reason: Failed to open the explicitly specified database 'mydatabase'. [CLIENT: 10.nn.nn.nn]
Some of our users do not have access to all databases on the server. When I switch off Intellisense in SSMS -> Tools -> Options -> Text editor -> Transact-SQL -> IntelliSense, the spamming stops.
Is this a bug in SSMS?
Are there ways around it (apart from granting access to all databases)?