Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Configuring Access to SSOLite Stored Procedures for TIBCO iProcess Plug-ins

## Status

If you are... | This task is...
Installing a new iProcess Engine Version 11.9.0 | Possibly required
Upgrading from an iProcess Engine Version 11.0 or later | Possibly required

## Database

Oracle, SQL Server

## Description

SSOLite is a set of stored procedures, available in the iProcess Engine database, that provide applications with direct access to a limited subset of iProcess Engine functionality.

The following TIBCO iProcess Plug-ins require access to the SSOLite stored procedures:

| • | TIBCO iProcess Web Services Plug-in

| • | TIBCO iProcess Java Plug-in

| • | TIBCO iProcess Connector for ActiveMatrix BusinessWorks

Note | If you want to use any of these plug-ins with SQL Server, you do not need to assign the SQL Server `System Administrators` server role to the IPE DB Owner SQL Server login ID.

## Procedure

To assign the SQL Server `System Administrators` server role to the `IPE DB Owner` SQL Server login ID:

| 1. | Start SQL Server Management Studio.

Note | You must install SQL Tools to get the SQL Server Management Studio utility.

| 2. | Expand Security and click Logins.

| 3. | Right-click the IPE DB Owner SQL Server login ID, see Database Details, then select Properties from the pop-up menu.

| 4. | Click the Server Roles tab.

| 5. | Select System Administrators, then click the OK button.

## See Also

For more information about SSOLite stored procedures, see TIBCO iProcess Engine (SQL Server) Administrator’s Guide.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.