I came across interesting issue on two occasion when I tried adding second node to the SQL 2012 cluster node. After it detecting the second server detail, account name for “SQL Server Agent” is blank. After we typed password this still fail with error message “There are validation error on this page”
We tried rebooting boxes but that didn’t help. Finally to fix this we need to create
1. SQL Server agent 2. Add the same agent as fail over cluster resources.
You can do this steps on any of the fail over cluster node. Use following PS editor to run the command
$ClusterName = "YourClusterName"
$FciClusterGroupName = "SQL Server (MSSQLSERVER)" # may need to modify to reflect your environment
Add-ClusterResourceType -Name "SQL Server Agent" -Dll "sqagtres.dll"
Output of command will be like this
Once this is done,select role –>Add Resource –> More Resources –>
More Resources –> SQL Server Agent
Select “New SQL Server Agent” and --->properties –>Dependencies select resource as “SQL Server”
Now select properties tab and type InstanceName = <Name of the SQL server Instance name> VirtualServerName =<Name of the SQLCluster>
Now the “New SQL Server agent” will start
Make sure the registry on primary server is set to 1
After above steps when setup is run again , it was able to see SQL Server Agent users name.
Yeah I am also a SQL expert
Source here
2 comments:
Thanks Vikash, this solution fixed my issue.
Thanks a lot, it solved my Problem with SQL 2017
Post a Comment