e.g. if the MS SQL Server is installed on a computer named CENTRALSERVER, you will 

change the line to 

SET server=CENTRALSERVER 

o

If the database administrator's name is other than  sa , change the line 

 SET 

u= 

e.g. if you created a special account named AVGUser, you will change the line to 

 SET 

u=AVGUser 

o

Save the modified file 

If needed, change the batch file mkAVGserver.bat: 

o

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

 SET 

server= 

o

If the database administrator's name is other than  sa , change the line 

 SET 

u= 

o

Save the modified file 

If needed, change the file AVGADMIN.rsp in this way: change the line Server=(Local) to 

Server= 

Launch the batch file mkAVGserver.bat. If everything is correct, the batch will run with no error 

report. The batch will prompt you for a password. Use the password to the account you created for 

AVG TCP Server access (in the example above, the account name is AVGUser). Enter this 

password when prompted. 

In case of an error the batch will end with an error message. Perform the suggested actions as 

mentioned in the error message. Then repeat step number 5. 

Set up the backup and control processes and other maintenance operations according to your 

policy. 

c)

Configuring the AVG TCP Server 

To configure the AVG TCP Server for ODBC it is necessary to create the ODBC data source, and to 

modify the connection string in AVG TCP Server. To create the data source so that the AVG TCP 

Server can access your MS SQL Server, follow these steps: 

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

Make sure there is an ODBC driver for MS SQL Server installed on computer with AVG TCP 

Server. 

Launch the mkAVGclient.bat batch file. 

Launch the odbcad32.exe program. Go to the System DSN tab, choose the AVGADMIN as a 

source and press the Configure button. Select the SQL Server authentication and enter username 

and password for the account created for AVG TCP Server (see step 2 in previous section). Do 

not select the integrated Windows authentication as the AVG TCP Server runs under the built in 

SYSTEM account that does not have access to network resources. 

Launch AVG TCP Server configuration within the AVG TCP Monitor by pressing the 

Configuration button 

Specify connection string in the form of  

ODBC;AVGAdmin 

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

84