Check if the 'System' user on the cluster nodes have 'sysadmin' role assigned to them in SQL or you enter the credentials of the account which has 'sysadmin' role in SQL. Below are the details from the Guide.
By default, the system account which is the service account of the nsrexecd service
does not have the sysadmin role for the SQL server. When configuring the client resource,
you must set the username and password of a Windows account with the system
administrator role on the SQL server and administrator role on the client in the Remote
gautamgp
226 Posts
2955
0
Posted August 31st, 2016 08:00
Check if the 'System' user on the cluster nodes have 'sysadmin' role assigned to them in SQL or you enter the credentials of the account which has 'sysadmin' role in SQL. Below are the details from the Guide.
By default, the system account which is the service account of the nsrexecd service
does not have the sysadmin role for the SQL server. When configuring the client resource,
you must set the username and password of a Windows account with the system
administrator role on the SQL server and administrator role on the client in the Remote
username and Password fields in NMC.