Discussion:
SQL Server 2005 Service Availability
(too old to reply)
Guy Melanson
2007-04-26 19:42:01 UTC
Permalink
We have a SQL 2005 Server Enterprise cluster. MOM reports the following error.

---The SQL Server management pack script "SQL Server 2005 Service
Availability" is unable to successfully connect to the SQL Server instance
"MSSQLSERVER". The error message returned is ""

Anybody...
--
GM
Anders Bengtsson
2007-04-29 20:21:48 UTC
Permalink
Hi

Is this alert generated on the virtual node or on a physical node?
--
Regards
Anders Bengtsson [MCSE:Security, MCSA:Messaging] | http://www.contoso.se
Post by Guy Melanson
We have a SQL 2005 Server Enterprise cluster. MOM reports the following error.
---The SQL Server management pack script "SQL Server 2005 Service
Availability" is unable to successfully connect to the SQL Server instance
"MSSQLSERVER". The error message returned is ""
Anybody...
--
GM
Guy Melanson
2007-04-30 11:22:01 UTC
Permalink
It's generated on the virtual node.

Thanks for the reply.
--
GM
Post by Anders Bengtsson
Hi
Is this alert generated on the virtual node or on a physical node?
--
Regards
Anders Bengtsson [MCSE:Security, MCSA:Messaging] | http://www.contoso.se
Post by Guy Melanson
We have a SQL 2005 Server Enterprise cluster. MOM reports the following error.
---The SQL Server management pack script "SQL Server 2005 Service
Availability" is unable to successfully connect to the SQL Server instance
"MSSQLSERVER". The error message returned is ""
Anybody...
--
GM
Anders Bengtsson
2007-04-30 12:40:26 UTC
Permalink
Are you running local system as action account everywhere?
--
Regards
Anders Bengtsson [MCSE:Security, MCSA:Messaging] | http://www.contoso.se
Post by Guy Melanson
It's generated on the virtual node.
Thanks for the reply.
--
GM
Post by Anders Bengtsson
Hi
Is this alert generated on the virtual node or on a physical node?
--
Regards
Anders Bengtsson [MCSE:Security, MCSA:Messaging] | http://www.contoso.se
Post by Guy Melanson
We have a SQL 2005 Server Enterprise cluster. MOM reports the following error.
---The SQL Server management pack script "SQL Server 2005 Service
Availability" is unable to successfully connect to the SQL Server instance
"MSSQLSERVER". The error message returned is ""
Anybody...
--
GM
Guy Melanson
2007-04-30 13:02:03 UTC
Permalink
Yep, Local system account is set for the Agent Action account. I'm guessing
I need to change that to a domain account that has admin rights?
--
GM
Post by Anders Bengtsson
Are you running local system as action account everywhere?
--
Regards
Anders Bengtsson [MCSE:Security, MCSA:Messaging] | http://www.contoso.se
Post by Guy Melanson
It's generated on the virtual node.
Thanks for the reply.
--
GM
Post by Anders Bengtsson
Hi
Is this alert generated on the virtual node or on a physical node?
--
Regards
Anders Bengtsson [MCSE:Security, MCSA:Messaging] | http://www.contoso.se
Post by Guy Melanson
We have a SQL 2005 Server Enterprise cluster. MOM reports the following error.
---The SQL Server management pack script "SQL Server 2005 Service
Availability" is unable to successfully connect to the SQL Server instance
"MSSQLSERVER". The error message returned is ""
Anybody...
--
GM
Pat Brickson
2007-07-12 13:54:02 UTC
Permalink
Can you tell me whether or not this change helped you to eliminate the MOM
error message?

Thanks,
Pat
Post by Guy Melanson
Yep, Local system account is set for the Agent Action account. I'm guessing
I need to change that to a domain account that has admin rights?
--
GM
Post by Anders Bengtsson
Are you running local system as action account everywhere?
--
Regards
Anders Bengtsson [MCSE:Security, MCSA:Messaging] | http://www.contoso.se
Post by Guy Melanson
It's generated on the virtual node.
Thanks for the reply.
--
GM
Post by Anders Bengtsson
Hi
Is this alert generated on the virtual node or on a physical node?
--
Regards
Anders Bengtsson [MCSE:Security, MCSA:Messaging] | http://www.contoso.se
Post by Guy Melanson
We have a SQL 2005 Server Enterprise cluster. MOM reports the following
error.
---The SQL Server management pack script "SQL Server 2005 Service
Availability" is unable to successfully connect to the SQL Server instance
"MSSQLSERVER". The error message returned is ""
Anybody...
--
GM
Loading...