ApexSQL Knowledgebase: ApexSQL Log update to the latest public version

LINKS

General

ApexSQL Audit
ApexSQL Clean
ApexSQL Data Diff
ApexSQL Debug
ApexSQL Diff
ApexSQL Diff API
ApexSQL Doc
ApexSQL Edit
ApexSQL Enforce
ApexSQL Log
ApexSQL Log API
ApexSQL Recover
ApexSQL Refactor
ApexSQL Script
ApexSQL Source Ctl
ApexSQL SSIS Compare

Knowledgebase Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly.

FAQs

Quick answers to common questions.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools.

Online Documentation

All of our help files for download or convenient viewing online.

Videos

Watch product demos, training videos, or tutorials of our products' main features.

ApexSQL Knowledgebase

Tips and How-to Articles for ApexSQL Tools

ApexSQL Log update to the latest public version

DESCRIPTION
ApexSQL Log auto-updater updates the client side of the application only. So server-side components and Connection Monitor from the previous version of ApexSQL Log still reside on the SQL Server and are running. This part of the application needs to be updated manually.

Server-side components update could be performed in the two ways:
1. Through the Connection Monitor Manager dialog: the Connection Monitor is fully configurable from the application GUI (Tools | Connection Monitor Manager) starting from the ApexSQL Log 2008.05. Application offers server-side components update, otherwise Connection Monitor management will not be available.

Connection Monitor Manager dialog consists of the two tabs: Connection Status and Data Capture that enable to manage Connection Monitor Log On options as well as a possibility to enable/disable the monitor and to choose a database for storing captured data.

Connection Status tab contains information about selected server, log on type, connection monitoring state and status.

Data Capture tab contains settings for:
1. Database where user wants to store login information
2. Captured information maintenance

Custom database to store login information could be selected here with the automatic or manual maintenance of the captured information.

2. Application automatically offers server-side components update at first auditing: since old server-side components are not compatible with the latest client, without this update auditing will not start.

However even after the server-side components are updated the Connection Monitor keeps saving data into msdb.APEXSQL_LOG_LOGIN table. This behavior can be changed through the Data Capture tab of the Connection Monitor Manager dialog (click here for more details ).

Note: After the application is auto-updated you need to manually run vcredist_x86.exe which is updated and placed into ApexSQL Log installation folder (e.g. C:\Program Files\ApexSQL\ApexSQLLog2008) on the machine where SQL Server is installed. This installer requires for correct work of server-side components.

AUTHOR
Dmitriy Dyubchenko

LAST REVIEW DATE
12 January 2010

Labels: ApexSQL Log

posted by Dmitriy Dyubchenko on Tuesday, January 12, 2010

0 Comments: