Unsolved
This post is more than 5 years old
1 Rookie
•
41 Posts
0
3951
August 28th, 2016 20:00
How to configure Networker for SQL AAGs?
Hi all,
I have SQL AlwaysOn Availability Groups:
- sql14-01.lab.vn, sql14-02.lab.vn, cluster.lab.vn (cluster failover), AG Listener, availability database (SQLDB-01)
And Networker server, AD
I want to backup SQL AAGs and I have installed:
- networker client, NWVSS for SQL on sql14-01.lab.vn, sql14-02.lab.vn.
But when I create client (cluster.lab.vn) in protection tab, It doesn't load database and I don't continue.
I don't know in SQL server, how I must install or run command to create client. Please help me! thanks!
gautamgp
226 Posts
0
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.
ElanC
53 Posts
0
October 31st, 2016 03:00
Need to understand the issue by looking at the
1. NSRSQLSV.RAW
2. NSRNMSQLRA.RAW
You may get the clue on the root cause. Happy troubleshooting!!
ElanC
53 Posts
0
November 15th, 2016 01:00
Any update. Did the reported issue got resolved?
Thanks,
Elango C
ElanC
53 Posts
0
November 29th, 2016 00:00
Hope things are fine at your end.
Let us know your feedback on your query.
Thanks,
Elango C
Lohithachar_ama
1 Message
0
July 6th, 2018 07:00
Hope you have installed Networker client, Networker xtended client and NMM correctly.