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 






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

chicago web hosting - illinois hosting services

 

Our partners: PHP: Hypertext Preprocessor Best Web Hosting Java Web Hosting Inexpensive Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Jsp Hosting Cheap Hosting

Visionwebhosting.net Business web hosting division of Web Design Plus. All rights reserved