Can't log off SIMS users

timzim · 11-11-2009, 04:30 PM

I was trying to apply the re-index patch to my SIMS server last night but it kept failing saying it couldn't get exclusive access to the database. I had a quick peep at who was logged in, using Solus, and it told me mobile_access - the username used by SIMS Mobile. Try as I might, I couldn't kick the user out: I shut down SIMS mobile on the server on which it's installed (not the SIMS server), restarted SQL, etc, but just couldn't get mobile_access to log off. Consequently I couldn't perform the reindex at all (and, more importantly, was late to bed

).

I've had similar problems in the past with users who've left themselves logged onto SIMS over the weekend (gaaah!) when I need to do updates. I've rebooted their PCs (remotely of course), changed their passwords & logged into and out of SIMS as them, rebooted the SIMS server, etc, etc, but have never been able to get them out.

So the question is: how do I kick any/all users out of SIMS? With the old DOS version you could log in as System Manager, disable logins, and then boot everyone off. But how do you do this with the SQL version (preferably without resorting to a hammer & blowtorch)? Did someone forget to add this function? Or have I missed something?

wagnerk · 11-11-2009, 04:52 PM

Are you running the full SQL product or the express version? Do you have all SQL tools installed? And are you supported by Capita or another company? (Not sure if the last question is relevant). I've written a short guide that may work for you, if you want it.

-ken

timzim · 11-11-2009, 04:57 PM

Full SQL (2005), with tools. Support is via LEA. Would be grateful for a copy of your guide, thanks.

Diello · 11-11-2009, 04:59 PM

In SQL Surface Area Configuration, select "Services & Connections". Navigate to the SIMS SQL Instance --> Database Engine --> Remote Connections on the left-hand pane. Switch to "Local connections only" on the right-hand pane. Then click on Service and Stop & then Start the service.

Do what you need to do with SIMS, then go the same route, but change it back to "Local and remote connections" then restart the instance service.

Means you have to be on the server (locally or via RDP) or course.

timzim · 12-11-2009, 10:30 AM

This worked perfectly, thanks.

Oddly, the System Info app in Solus told me that certain users were still logged onto SIMS. Pointless utility then...

ittech · 13-11-2009, 09:35 AM

Yeh the solus info screen is usually totally wrong, it tells me we still have several users logged in that I know for a fact are logged off.

Welcome, Register for free! or Login below:
User Name		Remember Me?
Password

11-11-2009, 04:30 PM	#1
timzim Join Date: Jun 2007 Location: London Posts: 339 Thanks: 25 Thanked 68 Times in 55 Posts Rep Power: 20	Can't log off SIMS users I was trying to apply the re-index patch to my SIMS server last night but it kept failing saying it couldn't get exclusive access to the database. I had a quick peep at who was logged in, using Solus, and it told me mobile_access - the username used by SIMS Mobile. Try as I might, I couldn't kick the user out: I shut down SIMS mobile on the server on which it's installed (not the SIMS server), restarted SQL, etc, but just couldn't get mobile_access to log off. Consequently I couldn't perform the reindex at all (and, more importantly, was late to bed ). I've had similar problems in the past with users who've left themselves logged onto SIMS over the weekend (gaaah!) when I need to do updates. I've rebooted their PCs (remotely of course), changed their passwords & logged into and out of SIMS as them, rebooted the SIMS server, etc, etc, but have never been able to get them out. So the question is: how do I kick any/all users out of SIMS? With the old DOS version you could log in as System Manager, disable logins, and then boot everyone off. But how do you do this with the SQL version (preferably without resorting to a hammer & blowtorch)? Did someone forget to add this function? Or have I missed something?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
New SIMS install not letting users log on	Number6	MIS Systems	40	31-07-2009 03:44 PM
New users can't log in to Outlook Web Access	WithoutMotive	Windows	5	07-09-2007 11:17 AM
Windows 2003 domain - automatically log out inactive users?	Halfmad	Windows	10	31-03-2007 05:40 PM
Limit users log on to laptop	Kyle	Windows	5	08-09-2006 08:14 AM
Only allow certain users to log on to a machine?	wesleyw	How do you do....it?	7	17-01-2006 12:38 AM

Thread Tools	Search Thread
Show Printable Version Email this Page	Search Thread: Advanced Search

		EduGeek.net Forums > Technical > MIS Systems
Can't log off SIMS users

11-11-2009, 04:52 PM	#2
wagnerk Join Date: Jun 2007 Location: Wellingborough, Northants Posts: 457 Thanks: 47 Thanked 75 Times in 65 Posts Rep Power: 19	Are you running the full SQL product or the express version? Do you have all SQL tools installed? And are you supported by Capita or another company? (Not sure if the last question is relevant). I've written a short guide that may work for you, if you want it. -ken

11-11-2009, 04:57 PM	#3
timzim Join Date: Jun 2007 Location: London Posts: 339 Thanks: 25 Thanked 68 Times in 55 Posts Rep Power: 20	Full SQL (2005), with tools. Support is via LEA. Would be grateful for a copy of your guide, thanks.

11-11-2009, 04:59 PM	#4
Diello Join Date: Jun 2005 Location: Kent, England Posts: 1,217 Thanks: 59 Thanked 179 Times in 109 Posts Rep Power: 54	In SQL Surface Area Configuration, select "Services & Connections". Navigate to the SIMS SQL Instance --> Database Engine --> Remote Connections on the left-hand pane. Switch to "Local connections only" on the right-hand pane. Then click on Service and Stop & then Start the service. Do what you need to do with SIMS, then go the same route, but change it back to "Local and remote connections" then restart the instance service. Means you have to be on the server (locally or via RDP) or course.

12-11-2009, 10:30 AM	#5
timzim Join Date: Jun 2007 Location: London Posts: 339 Thanks: 25 Thanked 68 Times in 55 Posts Rep Power: 20	This worked perfectly, thanks. Oddly, the System Info app in Solus told me that certain users were still logged onto SIMS. Pointless utility then...

13-11-2009, 09:35 AM	#6
ittech Join Date: Mar 2007 Location: Reading, UK Posts: 894 Thanks: 89 Thanked 37 Times in 31 Posts Rep Power: 14	Yeh the solus info screen is usually totally wrong, it tells me we still have several users logged in that I know for a fact are logged off.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)