Error when you try to run the Sqlmaint Utility after you upgrade to SQL Server 2008 or a later version
This article helps you resolve the problem that occurs when you run the Sqlmaint Utility after you upgrade from SQL Server 2000 SP4 to SQL Server 2008 or a later version.
Original product version: SQL Server
Original KB number: 955626
You successfully upgrade Microsoft SQL Server 2000 Service Pack 4 (SP4) to SQL Server 2008 or 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.)
This issue also occurs in SQL Server 2012
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 Discontinued Database Engine Functionality in SQL Server 2012.
|SQL Server Distributed Management Objects (SQL-DMO)
|SQL Server Management Objects (SMO)
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:
- Start SQL Server Management Studio, and then connect to the affected instance of SQL Server.
- In Object Explorer, expand Management, expand Legacy, and then expand Database Maintenance Plans.
- 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.
- 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.
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:
Locate the following installation source folder for SQL Server 2008:
The drive placeholder is the drive letter of the DVD drive.
Double-click the SQLServer2005_BC.ms i file to run the SQL Server Backward Compatibility Setup Wizard, and then click Next.
Click Modify, and then click Next.
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.
- SQL Server 2008 Developer
- SQL Server 2008 Enterprise
- SQL Server 2008 Express
- SQL Server 2008 Express with Advanced Services
- SQL Server 2008 Standard
- SQL Server 2008 Web
- SQL Server 2008 Workgroup
- SQL Server 2008 R2 Datacenter
- SQL Server 2008 R2 Developer
- SQL Server 2008 R2 Enterprise
- SQL Server 2008 R2 Express
- SQL Server 2008 R2 Express with Advanced Services
- SQL Server 2008 R2 Standard
- SQL Server 2008 R2 Standard Edition for Small Business
- SQL Server 2008 R2 Web
- SQL Server 2008 R2 Workgroup