It is very strange. There are login errors for Login ABC123 in the Application Log and also Alerts in SCOM for the same login failing to connect to the DW. I SQL Server, login ABC123 has sysadmin privileges as a login and as a user it has db_datareader, d