System Requirements for SQL-DMO
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
SQL Distributed Management Objects (SQL-DMO) uses the Microsoft SQL Server ODBC driver to connect to and communicate with instances of SQL Server. Stored procedures supporting SQL-DMO are installed on each instance of SQL Server.
SQL-DMO clients requires SQL Server 2005 client workstation installation. See Installation Options for information about the operating system requirements.
SQL-DMO clients require SQL Server ODBC Driver, version 3.80 or later, which is installed with SQL Server 2000 and later. The client network library must be properly configured.
SQL-DMO locates instances of SQL Server using the name of the instance. SQL-DMO does not use ODBC data source definitions for connection, and you need not use the ODBC Administrator to create data source definitions for servers administered by SQL-DMO applications.
Stored procedures that support SQL-DMO are created as part of an instance of Microsoft SQL Server 2005. The Transact-SQL script Sqldmo.sql is shipped with Microsoft SQL Server 2005 and can be used to reinstall the required stored procedures if necessary.
See Also
Other Resources
Hardware and Software Requirements for Installing SQL Server 2005
Client Network Configuration