Unable to create automation bject 'SQLDMO.SQLServer'

[RebeccaKelly]

Hi there,

We keep receiving the MOM alert below, saying how a SQL Server 2000 script
failed to execute. There are 5 similar alerts referring to different scripts
but they all have the same error of "Unable to create automation bject
'SQLDMO.SQLServer'"

We are running MOM 2005 SP1 and SQL 2000 and this box is our global
management server. I have read on other discussion boards about backwards
compatibility but they were running SQL 2005.

Does anyone have any suggestions about how to investigate or resolve this
issue?

Many Thanks
Rebecca

*****************

Description:
The "Microsoft SQL Server" management pack failed to execute the SQL Server
2000 Service Availability script successfully. The following error event was
returned "Unable to create automation object 'SQLDMO.SQLServer'". The
following additional error details were returned "". Please refer to the
events associated with this alert to view the computers that have experienced
this problem. Name: A management pack script was unable to complete
successfully
Severity: Error
Resolution State: Level 3: Requires scheduled maintenance
Domain: EURO
Computer: xxxxxx
Time of First Event: 02/02/2008 11:20:24
Time of Last Event: 07/02/2008 11:50:25
Alert latency: 0 sec
Problem State: Investigate
Repeat Count: 1446
Age:
Source: SQL Server 2000 Service Availability
Alert Id: 595c5b79-2fea-441f-a7af-b26c62c690cd
Rule (enabled): Microsoft Operations Manager\Operations Manager 2005\Agents
on all MOM roles\A management pack script was unable to complete successfully

[Blake Mengotto]

What is your SQL server security set up for? Do built in admins have SA
access or is it locked down? If locked down, have you created a action
account that has been granted SA access or something close to that for your
DB's on this server? If not, and your action account is running as local
system and your SQL DBA's remove built in admins from the SA security group,
then most and possibly all of the SQL scripts from the SQL MP will fail.

Check the permissions and see if that is the issue.
--
Regards,
Blake
Email: mengotto<at>hotmail.com
Blog: http//discussitnow.spaces.live.com

Post by RebeccaKelly
Hi there,
We keep receiving the MOM alert below, saying how a SQL Server 2000 script
failed to execute. There are 5 similar alerts referring to different scripts
but they all have the same error of "Unable to create automation bject
'SQLDMO.SQLServer'"
We are running MOM 2005 SP1 and SQL 2000 and this box is our global
management server. I have read on other discussion boards about backwards
compatibility but they were running SQL 2005.
Does anyone have any suggestions about how to investigate or resolve this
issue?
Many Thanks
Rebecca
*****************
The "Microsoft SQL Server" management pack failed to execute the SQL Server
2000 Service Availability script successfully. The following error event was
returned "Unable to create automation object 'SQLDMO.SQLServer'". The
following additional error details were returned "". Please refer to the
events associated with this alert to view the computers that have experienced
this problem. Name: A management pack script was unable to complete
successfully
Severity: Error
Resolution State: Level 3: Requires scheduled maintenance
Domain: EURO
Computer: xxxxxx
Time of First Event: 02/02/2008 11:20:24
Time of Last Event: 07/02/2008 11:50:25
Alert latency: 0 sec
Problem State: Investigate
Repeat Count: 1446
Source: SQL Server 2000 Service Availability
Alert Id: 595c5b79-2fea-441f-a7af-b26c62c690cd
Rule (enabled): Microsoft Operations Manager\Operations Manager 2005\Agents
on all MOM roles\A management pack script was unable to complete successfully

[SilloSyben]

I had this same problem on a server with both SQL 2000 and SQL 2005.
According to PSS, this was a known problem and not going to be fixed.

Post by Blake Mengotto
What is your SQL server security set up for? Do built in admins have SA
access or is it locked down? If locked down, have you created a action
account that has been granted SA access or something close to that for your
DB's on this server? If not, and your action account is running as local
system and your SQL DBA's remove built in admins from the SA security group,
then most and possibly all of the SQL scripts from the SQL MP will fail.
Check the permissions and see if that is the issue.
--
Regards,
Blake
Email: mengotto<at>hotmail.com
Blog: http//discussitnow.spaces.live.com

Post by RebeccaKelly
Hi there,
We keep receiving the MOM alert below, saying how a SQL Server 2000 script
failed to execute. There are 5 similar alerts referring to different scripts
but they all have the same error of "Unable to create automation bject
'SQLDMO.SQLServer'"
We are running MOM 2005 SP1 and SQL 2000 and this box is our global
management server. I have read on other discussion boards about backwards
compatibility but they were running SQL 2005.
Does anyone have any suggestions about how to investigate or resolve this
issue?
Many Thanks
Rebecca
*****************
The "Microsoft SQL Server" management pack failed to execute the SQL Server
2000 Service Availability script successfully. The following error event was
returned "Unable to create automation object 'SQLDMO.SQLServer'". The
following additional error details were returned "". Please refer to the
events associated with this alert to view the computers that have experienced
this problem. Name: A management pack script was unable to complete
successfully
Severity: Error
Resolution State: Level 3: Requires scheduled maintenance
Domain: EURO
Computer: xxxxxx
Time of First Event: 02/02/2008 11:20:24
Time of Last Event: 07/02/2008 11:50:25
Alert latency: 0 sec
Problem State: Investigate
Repeat Count: 1446
Source: SQL Server 2000 Service Availability
Alert Id: 595c5b79-2fea-441f-a7af-b26c62c690cd
Rule (enabled): Microsoft Operations Manager\Operations Manager 2005\Agents
on all MOM roles\A management pack script was unable to complete successfully