Hi,

I have an issues where the sql agent does not automatically when sql server
is moved (failover) from one node to the other. If I wait 5-10 seconds the
agent can be started manually.

Has anyone seen this before?

I also have a error message in the log saying:

[298] SQLServer Error: 18401, Login failed for user 'Contoso\sqlaccount'.
Reason: Server is in script upgrade mode. Only administrator can connect at
this time. [SQLSTATE 42000]
[000] Unable to connect to server 'sqlserver1\db1'; SQLServerAgent cannot
start
[298] SQLServer Error: 18401, Login failed for user 'Contoso\sqlaccount'.
Reason: Server is in script upgrade mode. Only administrator can connect at
this time. [SQLSTATE 42000]
[382] Logon to server 'sqlserver1\db1' failed (DisableAgentXPs)
[098] SQLServerAgent terminated (normally)

Thanks
Gunno

It sounds as if your SQLAgent resource isn't dependent on the SQL Server
service, causing it to try to start up too quickly.

In Cluster Administrator, rt-click on the Agent resource and under
properties\dependencies, be sure that the SQL Server resource is listed.

"Gunno" <Gunno (AT) discussions (DOT) microsoft.com> wrote

Perhaps, you had an unfinished upgrade/patch on the other node. Was it a
one-off occurrence?

Linchi

"Gunno" wrote: