none
GetSQL2005DBSpace.js problem in SQL MP

    Question

  •  

    Greetings,

    I realize that this forum is for SCE, but I have had absolutly no luck in the Operations Manager newsgroups, and was hoping that someone here could point me in the right direction.

     

    I do not see any performance information on the free space for databases or transaction logs I think mainly because the GetSQL2005DBSpace.js script isn't running for whatever reason.

     

    On the SQL server I see the following event every 15 min:

    *****

    Code Snippet

    Event Type: Error
    Event Source: Health Service Script
    Event Category: None
    Event ID: 4000
    Date:  4/3/2008
    Time:  8:53:08 AM
    User:  N/A
    Computer: PADMIS08
    Description:
    GetSQL2005DBSpace.js : 0

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

     

    I'm running SCOM 2007 w/SP1 and have the latest SQL MP (6.0.6278.8).  The test SQL system that I'm monitoring is running SQL 2005, and is running as a domain account.  The directories that the SQL databases are located in have the permissions restricted to Administrators, the SQL domain account, and System, all of these have at least modify access.

     

    I also see the following event when the Health service starts:

    Code Snippet

    Event Type: Warning
    Event Source: Health Service Modules
    Event Category: None
    Event ID: 21406
    Date:  4/3/2008
    Time:  8:53:09 AM
    User:  N/A
    Computer: PADMIS08
    Description:
    The process started at 8:53:05 AM failed to create System.PropertyBagData. Errors found in output:

    C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 6\1030\GetSQL2005DBSpace.js(67, 12) Microsoft JScript runtime error: 'Databases' is null or not an object


     
    Command executed: "C:\WINDOWS\system32\cscript.exe" /nologo "GetSQL2005DBSpace.js" PADMIS08
    Working Directory: C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 6\1030\

    One or more workflows were affected by this. 

    Workflow name: many
    Instance name: many
    Instance ID: many
    Management group: Test

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

     

    I have been able to successfully run this script under several different credentials.

     

    Any help you could offer would be greatly appreciated.  Thanks

    Thursday, April 03, 2008 4:18 PM

Answers

  • Hi,

     

    I would like to suggest that run the command: regsvr32 sqldmo.dll on the server. Also, if there dell MP exists, please remove it as a test. 

     

    Hope it helps.


    Monday, April 07, 2008 5:14 AM

All replies

  • Hi,

     

    I would like to suggest that run the command: regsvr32 sqldmo.dll on the server. Also, if there dell MP exists, please remove it as a test. 

     

    Hope it helps.


    Monday, April 07, 2008 5:14 AM
  • That did it, Thanks a ton for your help!

    Monday, April 07, 2008 7:57 PM
  • Welcome

     

    I am happy to know it works.

     

    Have a nice day.

    Tuesday, April 08, 2008 1:55 AM
  • Hi Guo-Zhen Wang,

     

    I am having the same problem and I also tried to run the command regsvr32 sqldmo.dll on my RMS , I am getting the following error for RegSvr32 :

     

    LoadLibrary("sqldmo.dll") failed -The specified module cound not be found.

     

    Please help me to resolve the issue.

     

    I am having problem with SCOM 2007 to Monitor SQL 2005 DB.In the Computer list under SQL Server in Monitoring Pane , there is nothing mentioned under SQL DB 2005 Engine.

     

    Please help me to resolve this issue.

     

    Regards,

    Arindam Hazra

     

    Wednesday, June 25, 2008 11:27 AM
  • I am getting the same alert after running the comming regsrv sqldmo.dll

    LoadLibrary("sqldmo.dll") failed -The specified module cound not be found.

     

    In my case i only have Analysis service installed on the systea..

    Event ID 21045

     

    Log Name:      Operations Manager
    Source:        Health Service Modules
    Date:          3/31/2011 8:35:35 PM
    Event ID:      21405

    Friday, April 01, 2011 5:46 AM
  • I am getting the same alert after running the comming regsrv sqldmo.dll

    LoadLibrary("sqldmo.dll") failed -The specified module cound not be found.

     

    In my case i only have Analysis service installed on the systea..

    Event ID 21045

     

    Log Name:      Operations Manager
    Source:        Health Service Modules
    Date:          3/31/2011 8:35:35 PM
    Event ID:      21405

    Change your path to "program files(x86)\Microsoft SQL Server\80\Tools\Binn"

    Then run the regsvr32 command

    Wednesday, April 27, 2011 5:31 PM