Difference between revisions of "Client Server Connections"
Jump to navigation
Jump to search
(Created page with "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 P...") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
If you are unable to remove client sessions from the Manage Server Connections utility please follow the instructions below: | 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; | use sw_systemdb; | ||
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. | ||
Latest 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