P E A R L   E C H 0   U S E R   G U I D E  

Integration with Microsoft SQL Server  

Pearl Echo stores monitored Internet activity in its native Microsoft xBase 

database format.  For installations with high volume monitoring loads and 

large storage requirements, Pearl Echo can be configured to store monitored 

Internet activity to a Microsoft SQL Server (version 2000 or later).  The Pearl 

Echo Server Software can be loaded on the same server that is running 

Microsoft SQL Server or any other machine that resides in a trusted Domain.  

Data stored on Microsoft SQL Server can be viewed and reported upon from 

the Pearl Echo Command Console.  To configure your Microsoft SQL Server: 

1. Create a SQL Server user called echouser with the password 

echopassword. 

2.  Copy the Pearl Echo database (echodb00000) files located in the Utilities 

directory of the product CD to your SQL Server. 

3.  Remove the files' Read Only attribute. 

4.  Attach to the Pearl Echo database by right clicking on Databases and 

selecting All Tasks >Attach Database in the SQL Server Enterprise 

Manager 

5.  Verify that echouser has full privileges to the Pearl Echo database. 

6.  Create a network share named cache0000000000 and apply read and 

write permissions to the domain computer on which the Pearl Echo Server 

software resides.  This share will be the location where Pearl Echo will 

store content from e mail, news, chat, & IM. 

To configure the Pearl Echo Server to store monitored Internet activity to the 

Echo database on Microsoft SQL Server, select Data Source Selection from 

the Pearl Echo Options menu.  When prompted, specify the name of the 

Microsoft SQL server and the database (echodb00000) and table 

(echotab00000) where Pearl Echo should log activity. 

18