Tuesday, October 14, 2014

Failed to add a Failover Cluster Node because “SQL Server Agent” account name empty

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”

image

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

image

$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

image

Once this is done,select role –>Add Resource –> More Resources –>

image

More Resources –> SQL Server Agent

image

Select “New SQL Server Agent” and --->properties –>Dependencies select resource as “SQL Server”

image

Now select properties tab and type  InstanceName = <Name of the SQL server Instance name> VirtualServerName =<Name of the SQLCluster>

image

Now the “New SQL Server agent”  will start

image

Make sure the registry on primary server is set to 1

image

After above steps when setup is run again , it was able to see SQL Server Agent users name.

image

Yeah I am also a SQL expert Smile

Source here

2 comments:

Anonymous said...

Thanks Vikash, this solution fixed my issue.

Bodo Kunrad said...

Thanks a lot, it solved my Problem with SQL 2017