Welcome, Register for free! or Login below:
EduGeek.net RSS Feeds Register FAQ Members Social Groups User Map Calendar Search Today's Posts Mark Forums Read

MIS Systems Do you use SIMs or similar? Try and ease your woes here.

Go Back   EduGeek.net Forums > Technical > MIS Systems
Reply
 
LinkBack Thread Tools Search Thread
Sponsored Links
Old 11-11-2009, 04:30 PM   #1
 
timzim's Avatar
 
Join Date: Jun 2007
Location: London
Posts: 339
uk
Thanks: 25
Thanked 68 Times in 55 Posts
Rep Power: 20 timzim is just really nice timzim is just really nice timzim is just really nice timzim is just really nice timzim is just really nice
Default 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?
  Reply With Quote
Old 11-11-2009, 04:52 PM   #2
 
wagnerk's Avatar
 
Join Date: Jun 2007
Location: Wellingborough, Northants
Posts: 457
germany de bavaria
Thanks: 47
Thanked 75 Times in 65 Posts
Rep Power: 19 wagnerk is just really nice wagnerk is just really nice wagnerk is just really nice wagnerk is just really nice
Default

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
  Reply With Quote
Old 11-11-2009, 04:57 PM   #3
 
timzim's Avatar
 
Join Date: Jun 2007
Location: London
Posts: 339
uk
Thanks: 25
Thanked 68 Times in 55 Posts
Rep Power: 20 timzim is just really nice timzim is just really nice timzim is just really nice timzim is just really nice timzim is just really nice
Default

Full SQL (2005), with tools. Support is via LEA. Would be grateful for a copy of your guide, thanks.
  Reply With Quote
Old 11-11-2009, 04:59 PM   #4
 
Diello's Avatar
 
Join Date: Jun 2005
Location: Kent, England
Posts: 1,217
england uk kent
Thanks: 59
Thanked 179 Times in 109 Posts
Rep Power: 54 Diello has much to be proud of Diello has much to be proud of Diello has much to be proud of Diello has much to be proud of Diello has much to be proud of Diello has much to be proud of Diello has much to be proud of Diello has much to be proud of Diello has much to be proud of
Default

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.
  Reply With Quote
Thanks to Diello from:
timzim (11-11-2009)
Old 12-11-2009, 10:30 AM   #5
 
timzim's Avatar
 
Join Date: Jun 2007
Location: London
Posts: 339
uk
Thanks: 25
Thanked 68 Times in 55 Posts
Rep Power: 20 timzim is just really nice timzim is just really nice timzim is just really nice timzim is just really nice timzim is just really nice
Default

This worked perfectly, thanks.

Oddly, the System Info app in Solus told me that certain users were still logged onto SIMS. Pointless utility then...
  Reply With Quote
Old 13-11-2009, 09:35 AM   #6
 
ittech's Avatar
 
Join Date: Mar 2007
Location: Reading, UK
Posts: 894
england
Thanks: 89
Thanked 37 Times in 31 Posts
Rep Power: 14 ittech has a spectacular aura about ittech has a spectacular aura about
Default

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.
  Reply With Quote
Reply

EduGeek.net Forums > Technical > MIS Systems

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


Tags
logoff , sims.net , sql


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

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:10 PM.
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.
Copyright EduGeek.net




website uptime

© 2005 - 2010 EduGeek.net
SERVER: 4
no new posts