Return
-
Title
Steps to Create Spotlight on Messaging Database Manually on SQL 2005 Server -
Description
This solution describes steps to create Spotlight on Messaging (SOM) 7.0 database manually on SQL 2005 Server. -
Resolution
Download the attached ManualDatabaseCreation.zip file and extract it to a folder. These scripts can be run manually in Query Analyzer opened from SQL Server Management Studio in the below order to create the SOE database. Run the attached SQL query files using SQL Query Analyzer in the following order:1. CreateDatabase.sql2. UserFunctions.sql3. DatabaseSchema.sql4. ImportData.sql
Create a SQL Account and provide the account Database Access to SpotlightManagementFramework with the following roles, Public and db_DataReader
1. Launch SQL Management Studio2. Expand Security3. Right Click Logins4. Click New Login5. In Login name enter SOMWeb6. Select SQL Server Authentication and provide a password7. Click User Mapping page from the left hand pane8. Check the SpotlightManagementFramework database and check the public and db_datareader role9. Click OKRun the install for Spotlight on Messaging, selecting all features, except the database (as it was manually installed already). The installer will ask for the database location, specify the SQL server name. -
Attachments