How to distribute and how to install SQL-DMO for SQL Server 2000

This article was previously published under Q326613
This article has been archived. It is offered "as is" and will no longer be updated.
This step-by-step article describes how to distribute and how to install SQL Distributed Management Objects (SQL-DMO) for Microsoft SQL Server 2000 by using Microsoft Windows Installer technology.


SQL-DMO is a collection of objects that helps you to manage SQL Server programmatically. SQL-DMO is a dual interface, in-process Component Object Model (COM) server that is implemented as a DLL. When you create a SQL-DMO application, you can use any OLE Automation controller or any COM client development operating system that uses C or C++.


The SQL-DMO client requires one of the following operating systems:
  • Microsoft Windows 2000
  • Microsoft Windows NT version 4.0 (Service Pack 5 or later)
  • Microsoft Windows 98 or Microsoft Windows 95
Additionally, the SQL-DMO client requires Microsoft SQL Server ODBC Driver, version 3.80 or later that is included with SQL Server 2000.

For more information about system requirements for SQL-DMO, visit the following Microsoft Web site:

Note The distribution package for SQL-DMO that is created in this article deals with files that fall under Windows File Protection. For example, Sqlunirl.dll is one of these files. Therefore, the SQL-DMO package may not be deployed correctly on certain versions of the Windows operating system, such as Microsoft Windows XP, if the version of Sqlunirl.dll that is contained in the deployment package is newer than the version that is on the destination system.

SQL-DMO components

SQL-DMO includes the following files:
File NameDescription
Sqldmo.dllDLL that implements SQL-DMO objects
Sqldmo.rllDMO resource file
Sqlresld.dllSQL Enterprise Manager resource DLL loader
Sqlsvc.dllDatabase service layer
Sqlsvc.rllDatabase service layer resource DLL
Sqlunirl.dllSQL Server Unicode/ANSI translation layer
W95scm.dllSQL Service Control Manager abstraction layer

How to package SQL-DMO components

You can distribute SQL-DMO by including each file that is listed in the "SQL-DMO components" section in a distribution package.

Package SQL-DMO files individually

  1. Start Microsoft Visual Studio .NET.
  2. Create a new Setup project:
    1. On the File menu, point to New, and then click Project.

      The New Project dialog box appears.
    2. Under Project Types, click Setup and Deployment Projects.
    3. Under Templates, click Setup Project.
    4. Click OK.
  3. Add the following files to your Setup project:
    • Sqldmo.dll
    • Sqldmo.rll
    • Sqlresld.dll
    • Sqlsvc.dll
    • Sqlsvc.rll
    • Sqlunirl.dll
    • W95scm.dll
    The following table lists each file name and its default location:
    File NameLocation
    Installation drive:\Program Files\Microsoft SQL Server\80\Tools\Binn
    Installation drive:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
    Sqlunirl.dllInstallation drive:\WINNT\system32
  4. Change value of the Register property of the Sqldmo.dll file to vsdrfCOMSelfReg:
    1. In Solution Explorer, click sqldmo.dll.
    2. In the Properties window, click vsdrfCOMSelfReg in the Register list.
  5. Change the installation folder of the Sqlunirl.dll file to the system folder. For example, change the installation folder to the Installation drive:\Winnt\System32 folder or to the Installation drive:\Windows\System folder.
    1. In Solution Explorer, click your Setup project
    2. On the View menu, point to Editor, and then click File System.
    3. On the Action menu, point to Add Special Folder, and then click System Folder.
    4. In Solution Explorer, click sqlunirl.dll.
    5. In the Properties window, click System Folder in the Folder list.
  6. On the Build menu, click Build Project Name to build your Setup project.

Article ID: 326613 - Last Review: 12/07/2015 11:55:44 - Revision: 4.4

Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbdeployment kbsetup kbhowtomaster KB326613