If you choose to create the Results database object manually in SSMS instead of using Results Database Utility to create the db object (not recommended), use the following steps:
Run SSMS.
Right-click on Databases in the tree.
Select New Database from the context menu.
Enter a Database name (e.g., Results).
Click OK.
Go to the Options page.
In the Recovery Model dropdown, select 'Simple'.
In the Other Options section, scroll down to Miscellaneous.
Set 'Allow Snapshot Isolation' to 'True'.
Set 'Is Read Committed Snapshot On' to 'True'.
Click OK.
Modify the SQL Authentication User.
Select User Mapping.
Check the boxes next to your CM4D Site database, CM4D database(s) and Results database.
For each of the databases, set the Database role membership to 'public' and 'db_owner'.
Click OK.
Once the database is created, run Results Database Utility to build the tables and procedures. See here for more information.
Can we improve this topic?