Is there a way to 'kill' or terminate a user session?

Owned by Beth Blok (Unlicensed)
Last updated: May 01, 2024 by Julie Hanlon
1 min read

Users may end a terminal server session or turn off their computer without logging out of Jiwa.  This can leave the user logged in and consuming a Jiwa licence.

Step-by-step guide

SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

Run the following script to identify the session to be ended

SELECT sys.sysdatabases.name [database name], hostname, program_name, sysprocesses.spid
FROM sys.sysprocesses
JOIN sys.sysdatabases ON sys.sysdatabases.dbid = sys.sysprocesses.dbid
WHERE program_name like 'Jiwa Financials%'
ORDER BY [database name] desc

From the resulting list, identify the relevant session to end.

In this example session 66 is to be ended.  Run the following

KILL 66