What are the release notes for VigilEnt Security Agent for SQL Server 1.0? (NETIQKB24907)

goal
What are the release notes for VigilEnt Security Agent for SQL Server 1.0?

fact
VigilEnt Security Agent for Microsoft SQL Server 1.0

fix

Updating Previous Builds

If you are currently running a pre-release of this software (any build dated before August 8, 2002), you must obtain and implement VigilEnt Security Agent for Microsoft SQL Server Pre-release Patch from Technical Support.

Notes about the installation

When you install VigilEnt Security Agent for Microsoft SQL Server (VSA for SQL Server), the following services are created:

• VigilEnt Security Manager DB Agent Service ? This service provides a communication interface between VigilEnt Security Agent for SQL.
• Server and VigilEnt Security Manager ? VigilEnt Security Manager
• Notification Agent Service ? This service lets you send alerts to selected personnel, or to the VigilEnt Security Manager console. This service is not created in the minimal install.
• The installation also creates a Microsoft SQL Server login named, sqlcqr_vsm_agent.

Special Requirements for the SQLCQR_VSM_AGENT user

To run reports on a Microsoft SQL Server, the sqlcqr_vsm_agent login must have one of the following:

• The system administrator role over the SQL Server where you want to run the report
• A user account on the database where you want to run the report

Note: The sqlcqr_vsm_agent login must have the System Administrator role to run the ?Users without a Password? Common report and the ?sa with Null Password? Check-up report.

To perform actions on a Microsoft SQL Server, the sqlcqr_vsm_agent user must have one of the following:

• The system administrator role over the SQL Server where you want to perform the action.
• The db_owner role on the database where you want to perform the action.

Non-Applicable Reports and Actions

Due to the design of Microsoft SQL Server, the following VigilEnt Security Manager Common reports are not compatible with VigilEnt Security Agent for SQL Server:

• Space Used by Owner
• Disabled Users
• Group List
• Group Membership Summary
• Groups User is a Member of Groups with No Users
• Powerful Groups
• User Last Access Date
• User Password Last Change Date
• Users in a Group
• Users not a Member of Any Group
• Users not Logged on Within X Days
• Users with Expired Passwords
• Users with Password = Username
• Users with Weak Passwords

Due to the design of Microsoft SQL Server, the following VigilEnt Security Manager Common actions are not compatible with VigilEnt Security Agent for SQL Server:

• Enable User
• Disable User
• Expire User Password
• Unexpire User Password

Note: The ?Change User Properties? action only lets you change a login?s password. You cannot change the status of this account with VigilEnt Security Agent for SQL Server.

Icon Display issue in VigilEnt Security Manager

Upon start-up of the VigilEnt Security Manager console, a SQL Server icon may erroneously display a database server as unavailable when in actuality it is. You can verify the status of your SQL Servers by executing a heartbeat check or by performing tasks on them.

Formerly known as NETIQKB24907