View source for Unable to remove a user session via Manage Server Connection

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.