Microsoft KB Archive/326613

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

Article ID: 326613

Article Last Modified on 12/20/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q326613



IN THIS TASK

 * SUMMARY
 * SQL-DMO
 * Requirements
 * SQL-DMO components
 * How to package SQL-DMO components
 * Package SQL-DMO files individually



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

back to the top

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

back to the top

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:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con01_9xbn.asp

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.

back to the top

SQL-DMO components
SQL-DMO includes the following files:

back to the top

How to package SQL-DMO components
You can distribute SQL-DMO by including each file that is listed in the &quot;SQL-DMO components&quot; section in a distribution package.

back to the top

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. Click OK.</ol> </li> Add the following files to your Setup project: <ul> Sqldmo.dll</li> Sqldmo.rll</li> Sqlresld.dll</li> Sqlsvc.dll</li> Sqlsvc.rll</li> Sqlunirl.dll</li> W95scm.dll</li></ul>

The following table lists each file name and its default location: </li> Change value of the Register property of the Sqldmo.dll file to vsdrfCOMSelfReg: <ol style="list-style-type: lower-alpha;"> In Solution Explorer, click sqldmo.dll.</li> In the Properties window, click vsdrfCOMSelfReg in the Register list.</li></ol> </li> Change the installation folder of the Sqlunirl.dll file to the system folder. For example, change the installation folder to the :\Winnt\System32 folder or to the  :\Windows\System folder. <ol style="list-style-type: lower-alpha;"> In Solution Explorer, click your Setup project</li> On the View menu, point to Editor, and then click File System.</li> On the Action menu, point to Add Special Folder, and then click System Folder.</li> In Solution Explorer, click sqlunirl.dll.</li> <li>In the Properties window, click System Folder in the Folder list.</li></ol> </li> <li>On the Build menu, click Build  to build your Setup project.</li></ol>

back to the top

Keywords: kbhowtomaster kbsetup kbdeployment KB326613

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.