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.sql
2. UserFunctions.sql
3. DatabaseSchema.sql
4. 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 Studio
2. Expand Security
3. Right Click Logins
4. Click New Login
5. In Login name enter SOMWeb
6. Select SQL Server Authentication and provide a password
7. Click User Mapping page from the left hand pane
8. Check the SpotlightManagementFramework database and check the public and db_datareader role
9. Click OK
Run 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.
