+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Force Logout of SIMS? in Technical; Hey, I constantly have to remind staff to logout of SIMS when I run updates. Is there a way to ...
  1. #1

    Join Date
    Mar 2010
    Location
    Hampshire
    Posts
    39
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Force Logout of SIMS?

    Hey,

    I constantly have to remind staff to logout of SIMS when I run updates. Is there a way to log all staff out at once?

    Thanks for your help!
    Last edited by EduTech; 12th March 2010 at 02:44 PM. Reason: Corrected Spelling in Title

  2. #2

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,068
    Thank Post
    160
    Thanked 925 Times in 727 Posts
    Blog Entries
    3
    Rep Power
    273
    If you:

    Click on Start > Computer > Manage > Shared Folders > Sessions

    End All The Sessions In There

    *Server 2003

    Not Sure where they have moved it to in 2008.

    James.

  3. Thanks to EduTech from:

    SamC (12th March 2010)

  4. #3

    broc's Avatar
    Join Date
    Jan 2006
    Location
    England
    Posts
    2,046
    Thank Post
    104
    Thanked 401 Times in 265 Posts
    Rep Power
    150
    Sometimes ending the sessions doesn't work & they reconnect. I always reboot the SIMS server

  5. #4
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    I always put the Server into Single User Mode before running a SIMS Upgrade!
    From SupportNet see:- KB88695 - How to force Users out of Sims.net

  6. #5

    Join Date
    Mar 2010
    Location
    Hampshire
    Posts
    39
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for all your suggestions, it would be useful if Capita released an upgrade that included a 'force logout' option though!

  7. #6
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    At one point im sure they did but no longer, probably something to do with data integrity. I use the single user mode too.

    To be fair i do all my patches/upgrades outside of working hours now.

  8. #7

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    This is from supportnet - KB88695 - It stops poeple connecting to the sims server... except the server itself (I have the sims client installed on the server to test with)

    How to force Users out of Sims.net KB88695
    THIS SOLUTION CANNOT BE USED FOR HOSTED SQL INSTANCES
    The following workaround will terminate any current connections to the SIMS SQL Instance, and if users are actually using SIMS .net, this will force them out.
    Any unsaved changes will be lost.

    Please set the Surface Area Configuration of the SIMS SQL Server to Local Connections Only.
    This means that only applications that use the SIMS SQL instance on the Server, itself, will be able to connect.
    This will stop the user refresh from logging into the database when trying to upgrade, and allow SOLUS, DBupgrade, and DBAttach to complete successfully.

    To re-configure this, please do the following:
    Click Start
    All Programs
    Microsoft SQL Server 2005
    Configuration Tools
    SQL Server Surface Area Configuration

    Click Surface Area Configuration for Services and Connections

    From the instance list, please click Remote Connections under the Database Engine for the correct instance (ie SIMS2005)
    Click Local Connections Only (The 1st radio button)
    Click Apply

    Click OK to the message

    Click the Service
    Click Stop, Click Start

    This will stop the Users from connecting to the Server outside of the actual box
    Run the specified application as required

    When complete, please do the following
    Click Start
    All Programs
    Microsoft SQL Server 2005
    Configuration Tools
    SQL Server Surface Area Configuration

    Click Surface Area Configuration for Services and Connections

    From the instance list, please click Remote Connections under the Database Engine for the correct instance
    Click Local and remote connections
    Click Using both TCP/IP and named pipes
    Click Apply

    Click OK to the message

    Click the Service
    Click Stop, Click Start

  9. #8
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Now I wonder where I saw that KB before .......................

  10. #9

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    lol!!

    I dont know what your on about... its all from my expert knowledge of SIMS... Hoooooooonest

  11. #10
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Look at one of my previous posts above!

  12. #11

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    DOH!!

    *makes note to read whole thread*

    I just copied it from our internal faq page as its one I dont want to have to dig around for
    Last edited by siuko; 12th March 2010 at 03:53 PM.

  13. #12
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Hey.......
    I've done that many a time! Usually on SupportNet tho' - not 'ere!

  14. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,007
    Thank Post
    679
    Thanked 1,396 Times in 1,156 Posts
    Rep Power
    353
    Quote Originally Posted by EduTech View Post
    If you:

    Click on Start > Computer > Manage > Shared Folders > Sessions

    End All The Sessions In There

    *Server 2003

    Not Sure where they have moved it to in 2008.

    James.
    With so many people going in and editing data, writing reports, using finance (!) i'm hesitant unless it's a last resort.

    Personally, i go to this section and remove permissions to the shared drive. Assuming all your users redirect their connect.ini to the shared drive, by removing permissions new people will not be able to log on. This doesn't remove existing users, but, is a nice way to stop people inadvertently logging in.

    Solus has an info page that tells you who is left logged into the database though i've never trusted the list, i also have a script that i got from a different thread in this forum that shows logged in users. I use this info to contact the relevant people and make sure they are out. Once out, they can't go back in without access to the shared drive.

    After this, i would use the single user mode option. It's a pain, but usually, there are only 4/5 culprits. I publicise a time slightly earlier than i want to start, i remove permissions, email staff, then start, it's usually clear.

    These sorts of problems can only get worse, as the usage of SIMS grows and you have remote users logging in, including parents via SLG or other applications . . .

    Doing upgrades at the weekend is bad enough without having to consider remote users in different timezones. ARGH!

  15. #14

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,212
    Thank Post
    372
    Thanked 379 Times in 337 Posts
    Rep Power
    148
    Quote Originally Posted by broc View Post
    Sometimes ending the sessions doesn't work & they reconnect. I always reboot the SIMS server
    Same here, it's the only way it seems to clear the ghost connections.

SHARE:
+ Post New Thread

Similar Threads

  1. [CSS] Force a font
    By Arcath in forum Web Development
    Replies: 5
    Last Post: 5th October 2009, 01:07 PM
  2. How to force Windows XP shut down
    By SteveB_NI in forum How do you do....it?
    Replies: 8
    Last Post: 2nd October 2008, 01:29 PM
  3. System Force IT
    By it_badger in forum Bad Experiences
    Replies: 19
    Last Post: 16th October 2007, 03:12 PM
  4. Force Sims Log Off
    By apeo in forum MIS Systems
    Replies: 17
    Last Post: 25th July 2006, 11:20 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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