Novell ZENworks Endpoint Security Management 3.5 Manuale Utente

Pagina di 245
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