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

Article translations Article translations
Article ID: 955626 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

You successfully upgrade Microsoft SQL Server 2000 Service Pack 4 (SP4) to Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2. 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.)

Note This issue also occurs in SQL Server 2012

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 or SQL Server 2008 R2.

In SQL Server 2012 or a later version, SQL DMO is one of the discontinued features and customers are advised to use SQL Server Management Objects (SMO). For more information, see the following SQL Server Books Online topic on TechNet:

http://technet.microsoft.com/en-us/library/ms144262(v=sql.110).aspx

Collapse this tableExpand this table
CategoryDiscontinued featureReplacement
ProgrammabilitySQL Server Distributed Management Objects (SQL-DMO)SQL Server Management Objects (SMO)

Resolution

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

Method 1: Upgrade maintenance plans to the SQL Server 2008 or SQL Server 2008 R2 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.

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.

References

For information about the Sqlmaint Utility, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/library/ms162827(SQL.100).aspx
For information about SQL Server 2008 Backward Compatibility, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/library/cc707787(SQL.100).aspx

For information about SQL Server 2012 Backward Compatibility, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/library/cc707787(SQL.100).aspx


Properties

Article ID: 955626 - Last Review: October 24, 2013 - Revision: 3.0
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
Keywords: 
sql2008relnotetools sql2008relnote kbtshoot kbupgrade kbupdateissue kbsetup kbexpertiseinter kbprb KB955626

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com