Configure SQL Security logins
On the GV STRATUS Core server, SQL Security logins must be configured for the internal system/domain account.
- Open SQL as Administrator to log on.
- Open SQL Server Management Studio and browse to Security | Logins.
- Right-click on the Logins and add a new Login.
-
On the General tab:
- In the Login name field, enter the internal system/domain account. For a domain GVDOMAIN, enter GVDOMAIN\GVAdmin.
-
In the Default database field, select MediaFrame.
Note: GV STRATUS software must be installed to make the MediaFrame database available.
-
On the User Mapping tab:
- Check the MediaFrame database, then select it and check the db_owner checkbox in the bottom portion of the dialog.
- Check the MediaFlow database, then select it and check the db_owner checkbox in the bottom portion of the dialog.
- Check the WfPersistence database, then select it and check the db_owner checkbox in the bottom portion of the dialog.
- Check the RulesEngine database, then select it and check the db_owner checkbox in the bottom portion of the dialog.
- Click OK to save settings and close.
