Login failed for user 'CONTOSO\walterwhite'
Published 18 January 2018
Problem:
Login failed for user ‘CONTOSO\walterwhite‘.
Solution:
The user running SQL Estate Manager and creating a snapshot must be sysadmin on the SQL Server in order to retrieve info from user and system databases. For more information, refer to User Permission Requirements.