Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
On Mon, 24 Oct 2005 09:32:07 +0400, Vinay Jhumun <ljhumun at sil.intnet.mu> wrote: >Hi, >Can anyone help me plz, >I hve installed CVSNT 2.5.02. 2088, >there is also, MSSQL 2000 server installed on the same PC. > >n i want to enable the Audit Feature, can anyone help me how to achieve >this plz, >n wat tables n how to create them, > >plz provide me any links where i can get some more info, > This is extremely simple: 1. Create a new database called for example CVSNT (Or you can use an existing database for that matter and just add the new tables to that database). Also create a new login to this server called CVSNT and set its password. Let it have db_owner access to the auditing database. 2. Open the sql script named create_tables_mssql.sql in QueryAnalyzer and execute it against the database. Your tables will now be created. Or you can use the osql execution of the script. The script is delivered as part of the CVSNT installation, look in a subdirectory below the CVSNT install path. 3. In AdministrativeTools/DataSources(ODBC) create a new system data source named CVSNT for the database where the tables are created. Set the access method to SQL authentication. 4. In CVSNT control panel go to the Plugins tab and select the line "Repository Auditing Extension". Then click configure. 5. Enter the data (check Plugin enabled, set Type=ODBC, Name=CVSNT, Prefix=<blank>, Username=CVSNT, Passwsord=<password>) 6. Then determine what to audit in the Logging checkboxes 7. Done! /Bo (Bo Berglund, developer in Sweden)