-
Title
How to manually create the Spotlight on Messaging 7.5 Database on both clustered and non-clust -
Description
How to manually create the Spotlight on Messaging 7.5 Database on both clustered and non-clustered SQL 2000, SQL 2005 & SQL 2008 Servers
-
Resolution
The steps listed below allow SQL administrators to manually create the SOM database using scripts rather than running the SOM installer against SQL servers.
The Spotlight on Messaging 7.5 manual database creation scripts can be found with the installation files of the product in a subfolder called DatabaseScripts. These files can also be accessed by running the autorun utility of the installer and selecting Install | Spotlight on Messaging Manual Database Scripts. The database creation scripts are in a subfolder called InstallScripts
IMPORTANT NOTES:
- These steps are known to work successfully; however, they have not been officially tested by Quest Software Quality Control.
- If any of these instructions are changed, this solution becomes unsupported by Quest Support and Development. For customization of the Quest Spotlight on Messaging product, please contact our Professional Services Organization: http://www.quest.com/professional-services/.
The steps to manually create the SOM database can be found in the Spotlight on Messaging Deployment Guide
The same steps are detailed below:
To create the Spotlight on Messaging 7.5 database manually:
1. Open Microsoft SQL server Management Studio (or similar application to open SQL scripts) - see in Additional Information below how to obtain the scripts
2. Click File | Open | File
3. Open CreateDatabase.sql
4. Select Query | Execute
5. Repeat steps 3 and 4 to install the following SQL script files in the following order:
* UserFunctions.sql
* DatabaseSchema.sql
* ImportData.sql