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 includes the following files:
DLL that implements SQL-DMO objects
DMO resource file
SQL Enterprise Manager resource DLL loader
Database service layer
Database service layer resource DLL
SQL Server Unicode/ANSI translation layer
SQL 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
Start Microsoft Visual Studio .NET.
Create a new Setup project:
On the File menu, point to New, and then click Project.
The New Project dialog box appears.
Under Project Types, click Setup and Deployment Projects.
Under Templates, click Setup Project.
Add the following files to your Setup project:
The following table lists each file name and its default location:
Change value of the Register property of the Sqldmo.dll file to vsdrfCOMSelfReg:
In Solution Explorer, click sqldmo.dll.
In the Properties window, click vsdrfCOMSelfReg in the Register list.
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.
In Solution Explorer, click your Setup project
On the View menu, point to Editor, and then click File System.
On the Action menu, point to Add Special Folder, and then click System Folder.
In Solution Explorer, click sqlunirl.dll.
In the Properties window, click System Folder in the Folder list.
On the Build menu, click Build Project Name to build your Setup project.