b)

Firebird SQL Server   requires an extra licence; this database is recommended for maximum of 150 

client stations 

c)

MS SQL Server   requires an extra licence; the number of connected client stations is limited by the 

server's hardware equipment only 

d)

MSDE 2000 Server   is the free version of MS SQL server and you need no extra licence to use it; up 

to 1000 client stations can be connected to this server 

7.11 AVG DataCenter on Microsoft SQL Server 7.0/2000/2003 

a)

Using the Microsoft SQL Server as a AVG DataCenter 

This mode is intended for an environment with Microsoft SQL Server running (versions currently 

supported are 7.0, 2000 and 2003, including the Desktop Engine). The most recommended 

configuration is to use the AVG TCP Server that connects to the Microsoft SQL Server via ODBC while 

clients use standard HTTP communication with the AVG TCP Server. This way, only the computer 

with AVG TCP Server needs ODBC drivers. 

It is also possible that clients connect directly to the SQL Server using ODBC. In this case, all clients 

must have ODBC drivers properly installed and configured (the MDAC components have to be 

installed). Such a configuration poses many potential configuration problems; therefore we strongly 

recommend using the first option (only AVG TCP Server connects to the SQL server via ODBC). 

To set up the AVG DataCenter within a MS SQL Server, it is necessary to create all the necessary 

tables and configure ODBC access. All necessary scripts and configuration files are created during the 

AVGADMIN installation when the option Scripts for MSSQL is selected. The scripts are located in 

the directory DataCenter\MS SQL Scripts. These files are saved as ZIP archive AVGMSSQL.ZIP. 

Unpack the files to your working directory. Then follow the instructions in the following sections to set 

up the AVG DataCenter within your Microsoft SQL Server database and configure your AVG TCP 

Server to use this AVG DataCenter. 

b)

AVG DataCenter creation 

AVG DataCenter is created within the Microsoft SQL Server database. The following steps have to be 

performed on a computer with access to the MS SQL Server. This can either be the computer with MS 

SQL Server itself, or any other computer with ODBC access to the server. You will also need 

administrative rights to the server to create the AVG DataCenter, or at least rights to create new 

databases and tables within the MS SQL Server storage. 

Standard AVG DataCenter installation on MS SQL Server supposes creation of a database named 

AVG. If you want to use another name, you have to edit the files AVGmssql.sql, mkAVGserver.bat and 

AVGADMIN.rsp. 

It is also recommended that you create a special account for AVG TCP Server connection to AVG 

DataCenter. This account should have access only to the AVG DataCenter tables. Installation scripts 

and response files have to be modified with the actual database and account name: 

Unpack installation files from the AVGMSSQL.ZIP archive into your working directory.  

Set up the account (using the SQL manager or another suitable application) for AVG TCP Server 

access to the database. Set the account's rights for writing and reading the AVG database tables. 

E.g. the account name may be AVGUser 

If needed, change the batch file mkAVGserver.bat: 

o

If the database will be created on another machine, change the line 

SET server= 

Copyright (c) 1992 2005 GRISOFT, s.r.o. All rights reserved. 

83