Article ID: 955626 - Last Review: March 19, 2009 - Revision: 2.1

Error message when you try to run the Sqlmaint Utility after you upgrade to SQL Server 2008: "The SQLDMO 'Application' object failed to initialize"

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

On This Page

Expand all | Collapse all

SYMPTOMS

You successfully upgrade Microsoft SQL Server 2000 Service Pack 4 (SP4) to Microsoft SQL Server 2008. However, when you try to run the Sqlmaint Utility (Sqlmaint.exe), you receive the following error message:
The SQLDMO 'Application' object failed to initialize (specific error: One of the library files needed to run this application cannot be found.)
Back to the top

CAUSE

This problem may occur if the SQL Server Distributed Management Objects (SQL-DMO) version that is installed cannot connect to an instance of SQL Server 2008.
Back to the top

RESOLUTION

To resolve this problem, use one of the following methods.
Back to the top

Method 1: Upgrade maintenance plans to the SQL Server 2008 format (recommended)

This method migrates maintenance plans to the SQL Server 2008 format. If all older maintenance plans are upgraded, Method 2 is not required.

To use SQL Server Management Studio to upgrade maintenance plans, follow these steps:
  1. Start SQL Server Management Studio, and then connect to the affected instance of SQL Server.
  2. In Object Explorer, expand Management, expand Legacy, and then expand Database Maintenance Plans.
  3. Right-click each maintenance plan that you want to migrate, and then click Migrate. This step creates a new, non-legacy maintenance plan in the SQL Server 2008 format.
  4. Right-click the Database Maintenance Plans folder, and then click Refresh to update the maintenance plans in the Management folder.
Back to the top

Method 2: Install the latest SQL-DMO from the SQL Server Backward Compatibility Setup

This method installs the latest version of SQL-DMO to enable the older maintenance plan format to continue working in SQL Server 2008.

Note If you no longer have any maintenance plans in the older format, this method is not required.

To run the SQL Server Backward Compatibility Setup Wizard, follow these steps:
  1. Locate the following installation source folder for SQL Server 2008:
    drive:\Servers\Setup
    Note The drive placeholder is the drive letter of the DVD drive.
  2. Double-click the SQLServer2005_BC.msi file to run the SQL Server Backward Compatibility Setup Wizard, and then click Next.
  3. Click Modify, and then click Next.
  4. Make sure that the SQL Distributed management Objects (SQL-DMO) feature is set to install on the local hard disk drive, and then click Next.
  5. Click Install.
Back to the top

REFERENCES

For information about the Sqlmaint Utility, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/library/ms162827(SQL.100).aspx (http://technet.microsoft.com/en-us/library/ms162827(SQL.100).aspx)
For information about SQL Server Backward Compatibility, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/library/cc707787(SQL.100).aspx (http://technet.microsoft.com/en-us/library/cc707787(SQL.100).aspx)
Back to the top
APPLIES TO
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
Back to the top
Keywords: 
sql2008relnotetools sql2008relnote kbtshoot kbupgrade kbupdateissue kbsetup kbexpertiseinter kbprb KB955626
Back to the top