...
...
...
- Define the login name (e.g., IndeedCMSQL).
...
- In the Object Explorer, right-click on the Databases tab.
- Select New Database... .
- Specify the Database Name: for example, IndeedCM and click OK.
2. Use a local SQL account or Windows domain account (for example, servicecm) and define the permissions for the created database. This account shall be used to perform reading data from the database and writing data to it. Connection of the account to the database is carried out with Indeed CM Setup Wizard.
- Define Logins for the
...
...
...
Figure 7 – Microsoft SQL: permissions for working with database.
- and public.
- Click OK.
3. Select the created database (IndeedCM) in the Object Explorer
...
...
...
...
...
...
- Before executing the script, uncomment: --USE [<database name>] --GO and specify the name of the database for which the script is applied (IndeedCM): --USE [IndeedCM] --GO. Or select the required database in the drop-down menu.
- Click Execute.
- Similarly, run the Storage_Indices.sql script.
4. If Indeed CM Agent is used, set permissions on the CMAgentSessionType, UpdateAgentSession and UpdateAgentSessions objects of the created database (IndeedCM) for the service account (for example, servicecm):
- Open the Properties of the CMAgentSessionType object located path Programmability > Types > User-Defined Table Types.
- Go to the Permissions tab, to search for a service account, click Search... .
- Issue Permissions for the selected account: to Control this object.
- Similarly, set Execute permissions for UpdateAgentSession and UpdateAgentSessions objects located path Programmability > Stored Procedures
3. Click Execute and refresh the contents in Object Explorer after script execution is complete.
Expected result is that IndeedCM database contains the following tables in the Tables section:
...