Windows user cannot run the "swsvrmgr STATUS -v" command

Windows user cannot run the "swsvrmgr STATUS -v" command

book

Article ID: KB0081538

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (SQL) 11.6.0

Description

A Windows user is a member of the “Staffware Administrators” group.
However the user is not able to run the iProcess swsvrmgr utility.
 
The command "swsvrmgr status -v" generates the error:
swsvrmgr: Process Startup failed. Error -1010: Failed to access Process Config table
 

Issue/Introduction

A Windows user is a member of the “Staffware Administrators” group However the user is not able to run the iProcess swsvrmgr utility. The command "swsvrmgr status -v" generates the error: swsvrmgr: Process Startup failed. Error -1010: Failed to access Process Config table

Environment

TIBCO iProcess Engine (SQL) 11.6.0 Microsoft Windows Server 2012 R2 Microsoft SQL Server 2012 Windows authenticated database users

Resolution

The error means that the iProcess utility can connect to the SQL Server instance but could not access the iProcess database.
 
iProcess is using Windows authenticated database users.
The process running the swsvrmgr command will connect to the iProcess database as the Windows user.
 
To run the iProcess utility a windows user must be:
 
1. A Windows authenticated login in the SQL server instance  
 
2. A user in the iProcess database (minimum read access)
 
 
In order to use the iProcess database one of the following must be configured:

1. In SQL Server configure the users default database to the iProcess database
or
2. In the ODBC data source used by iProcess - enable the “Change the default database to” option and select the iProcess database