SQL-DMO uses the Microsoft® SQL Server™ ODBC driver to connect to and communicate with SQL Server installations. Stored procedures supporting SQL-DMO are installed on each server running SQL Server.
SQL-DMO clients require a system running:
Or
SQL-DMO clients require SQL Server ODBC Driver, version 3.70 or later, which ships with SQL Server version 7.0. The client network library must be properly configured.
SQL-DMO locates servers running SQL Server by using the SQL Server installation name. 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 supporting SQL-DMO are created as part of SQL Server 7.0 server installation. The Transact-SQL script Sqldmo.sql is shipped with SQL Server 7.0 and can be used to reinstall the required stored procedures if necessary.
Hardware and Software Requirements for Installing SQL Server | Overview of Installing SQL Server |
Configuring Client Network Connections |