+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Can't log off SIMS users in Technical; I was trying to apply the re-index patch to my SIMS server last night but it kept failing saying it ...
  1. #1

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56

    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?

  2. #2
    wagnerk's Avatar
    Join Date
    Jun 2007
    Location
    Northants
    Posts
    822
    Thank Post
    65
    Thanked 169 Times in 137 Posts
    Rep Power
    48
    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

  3. #3

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56
    Full SQL (2005), with tools. Support is via LEA. Would be grateful for a copy of your guide, thanks.

  4. #4
    Diello's Avatar
    Join Date
    Jun 2005
    Location
    Kent, England
    Posts
    1,067
    Thank Post
    118
    Thanked 228 Times in 128 Posts
    Rep Power
    75
    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.

  5. Thanks to Diello from:

    timzim (11th November 2009)

  6. #5

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56
    This worked perfectly, thanks.

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

  7. #6
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    4,002
    Thank Post
    983
    Thanked 477 Times in 398 Posts
    Blog Entries
    12
    Rep Power
    98
    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.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] New SIMS install not letting users log on
    By Number6 in forum MIS Systems
    Replies: 41
    Last Post: 13th April 2011, 08:17 AM
  2. New users can't log in to Outlook Web Access
    By WithoutMotive in forum Windows
    Replies: 5
    Last Post: 7th September 2007, 12:17 PM
  3. Replies: 10
    Last Post: 31st March 2007, 06:40 PM
  4. Limit users log on to laptop
    By Kyle in forum Windows
    Replies: 5
    Last Post: 8th September 2006, 09:14 AM
  5. Only allow certain users to log on to a machine?
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 17th January 2006, 12:38 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •