Ads

09 April 2011

Not able to add SQL 2008 secone node , SQL server agent account is grayed out

Resolution 1 :-
============

Add the SQl Server Agent to the existing resources. From Right pane of Server manager >> Add resource>>Server>> Select Sql Server Agent

Bring it online

This will work out

Resolution 2:-
==============
If its failing with credential issues, try to install from command line. This is for Default installation, named give name in instance name.

Choose CMD run as Administrator

setup.exe /ACTION=AddNode /INSTANCENAME="MSSQLSERVER" /SQLSVCACCOUNT="DOMAIN\ACCOUNT" /SQLSVCPASSWORD="*******" /AGTSVCACCOUNT="DOMAIN\ACCOUNT" /AGTSVCPASSWORD="*******


This will resolve .

No comments:

Post a Comment