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

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

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++.

Requirements

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:

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:
   Collapse this tableExpand this table

   File Name	Location
   Sqldmo.dll Sqlresld.dll Sqlsvc.dll W95scm.dll	Installation drive:\Program Files\Microsoft SQL Server\80\Tools\Binn
   Sqlsvc.rll Sqldmo.rll	Installation drive:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
   Sqlunirl.dll	Installation 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.