Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Does anyone know how to make the second SQL instance Agent working on the same MSCS SQL Server 2008 R2 cluster?

In the clustered SQL Server service instance2 i have assigned the same service account to start all of the other service in for instance1

Log Name:      Application
Source:        SQLAgent$LYNC
Date:          26/08/2011 12:40:46 PM
Event ID:      103
Task Category: Service Control
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SQLNode1-VM.DOMAIN.com
Description:
SQLServerAgent could not be started (reason: Unable to connect to server 'SQLNode1-VM\Instance1'; SQLServerAgent cannot start).

I always get the above error, therefore I cannot proceed in adding the secondary node for my second DB instance.

share|improve this question
1  
Can't this be done using Configuration Manager? –  Zee Tee Aug 28 '11 at 5:25
    
Unfortunately no, I'm stuck in this problem when I tried to add he secondary Node to the cluster group. –  Albert Widjaja Aug 29 '11 at 4:09
1  
did you mean we can not start Sql server agent with Win7 and SQL Server 2008 ?? –  Keith Phạm Sep 21 '12 at 7:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.