Client Server Connections: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
select sid, connectionid, analystname from swsessions; | select sid, connectionid, analystname from swsessions; | ||
Identify the session in question, note down the 'sid' number, then enter: | Identify the session in question, note down the 'sid' number, then enter: | ||
delete from swsessions where sid = ##; | delete from swsessions where sid = ##; | ||
*NOTE* where ## should be the sid number. | *NOTE* where ## should be the sid number. | ||
Furthermore, to stop this issue happening again, on the server please go into: | Furthermore, to stop this issue happening again, on the server please go into: | ||
Revision as of 10:03, 10 July 2015
If you are unable to remove client sessions from the Manage Server Connections utility please follow the instructions below:
From the Supportworks Server Go to Start > All Programs > Hornbill Core Services > Interactive SQL > and enter the below queries:
use sw_systemdb;
select sid, connectionid, analystname from swsessions;
Identify the session in question, note down the 'sid' number, then enter:
delete from swsessions where sid = ##;
- NOTE* where ## should be the sid number.
Furthermore, to stop this issue happening again, on the server please go into:
Start > All Programs > Supportworks Server > Supportworks Server Configuration > Communications tab >
Check the box which says "do not allow analysts to log in more than once" and select 'Close Previous Connection' > click on Apply and OK, followed by a restart of the services