ZENworks® ESM 3.5 Administrator’s Manual 234
Microsoft SQL Enterprise Manager
SQL Server Enterprise Manager is the primary administrative tool for Microsoft® SQL Server™
2000 and provides a Microsoft Management Console (MMC)-compliant user interface that allows
users to:
• Define groups of servers running SQL Server.
• Register individual servers in a group.
• Configure all SQL Server options for each registered server.
• Create and administer all SQL Server databases, objects, logins, users, and permis-
sions in each registered server.
• Define and execute all SQL Server administrative tasks on each registered server.
• Design and test SQL statements, batches, and scripts interactively by invoking SQL
Query Analyzer.
• Invoke the various wizards defined for SQL Server.
MMC is a tool that presents a common interface for managing different server applications in a
Microsoft Windows® network. Server applications provide a component called an MMC snap-in
that presents MMC users with a user interface for managing the server application. SQL Server
Enterprise Manager is the Microsoft SQL Server 2000 MMC snap-in.
To launch SQL Server Enterprise Manager, select the Enterprise Manager icon in the Microsoft
SQL Server program group. On computers running Windows 2000, you can also launch SQL
Server Enterprise Manager from Computer Management in Control Panel. MMC snap-ins
launched from Computer Management do not have the ability to open child windows enabled by
default. You may have to enable this option to use all the SQL Server Enterprise Manager
features.
When examining Novell installations, the tables of interest, per database, are as follows:
Distribution Service
CONFIGURATION: Contains the settings used for the Distribution Service and Event Packager
Agent Windows Service.
The settings, in storage order are:
3. Distribution Server Role (future)
4. Setup ID
5. Minimum SSL Key Length
6. DIME Timeout
7. Schedule Interval for Event Packager (minutes)
8. Minimum Client Packages to add to Reporting Package
9. Maximum Client Packages to add to Reporting Package
10. Distribution Service Counter Category
11. Event Packager Service Counter Category
