SCSQL discover resources fails with The user does not have required permissions
Applies to
- SnapCenter Server (SC)
-
SnapCenter Plug-in for Microsoft SQL Server (SCSQL)
Issue
SCSQL discover resources or backup fails with the following errors in
<installation_path>\Program Files\NetApp\SnapCenter\SnapCenter Plug-in for Microsoft SQL Server\log\SmSql_<id>.log
:ConnectionFailureException: Logon failure: the user has not been granted the requested logon type at this computer
ErrorCode (10010), ErrorMessage (The user '<UserName>' does not have required permission to connect to the SQL instance '<SQL_Instance>'
SnapCenter UI Resources panel displays discovered SQL instances with red padlock icon