+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, Force Sims Log Off in Technical; Anyon know how to force sims users to log off? I know that when you apply a patch or restore ...
  1. #1
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41

    Force Sims Log Off

    Anyon know how to force sims users to log off? I know that when you apply a patch or restore the database you have the option to force but just force users off?

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,582
    Thank Post
    107
    Thanked 761 Times in 592 Posts
    Rep Power
    179

    Re: Force Sims Log Off

    IIRC restarting the database services boots them out sufficiently well... it isn't a clean way of doing it though.

  3. #3


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,534
    Thank Post
    271
    Thanked 752 Times in 590 Posts
    Rep Power
    218

    Re: Force Sims Log Off

    we find that waiting until they're all out of school, locking the doors and then guarding those doors with a shotgun is the only sure way to ensure people don't "just pop into SIMS for a minute" or "I could get in, so you'd finished working on SIMS hadn't you?"

  4. #4
    Disease's Avatar
    Join Date
    Jan 2006
    Posts
    1,059
    Thank Post
    112
    Thanked 63 Times in 44 Posts
    Rep Power
    54

    Re: Force Sims Log Off

    Unshare the sims folder? Thats all we do that and the shotgun thing suggested above.

  5. #5

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,853
    Thank Post
    1,160
    Thanked 1,028 Times in 729 Posts
    Rep Power
    323

    Re: Force Sims Log Off

    Sims server>right click>manage>shared folders> open files>select which files>right click>close files or you can right click the open files folder and disconect all open files. before you do this though netsend to all those machines a message to log out of Sims first then if they are still logged in with files open you revert to the above.

  6. #6
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41

    Re: Force Sims Log Off

    Thanks for the replies.. if you not the time of my post its well outside working hour and most definately no chance of anyone on sims at that time However sims sql database seems to think there are users still logged in, probably logged out of sims failed so flag was left behind.

    I will check out IIRC, just thought there might be a sims command that would do it.

  7. #7
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41

    Re: Force Sims Log Off

    Man I'm really having a hard time with this stupid upgrade... first it says there are users logged on when they are not.. then this morning we had no internet so cant download... then it only did a partial upgrade so i have to try and download and install again but guess what... download is stupid slow. Its funny that solus 2 was developed to ultimately makes things easier for us but its taking me several hours thus far to do what should have been a 20min job.. This ofcourse has a knock on effect on other departments so more time wasted... GRRR

    Suppose this post should go in FFS really.

  8. #8

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,853
    Thank Post
    1,160
    Thanked 1,028 Times in 729 Posts
    Rep Power
    323

    Re: Force Sims Log Off

    Just find SQL anywhere on Sims Server ours is here D:\ITSSMIS\SIMS\SQLANY50\WIN32\DBSVMN50.EXE then look at example below: You can stop and start SQL anytime you want to this will really p*** admin users off if they don't conform to your wishes. Don't forget who is in charge "YOU ARE" so they better take notice OK
    Attached Images Attached Images

  9. #9

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,853
    Thank Post
    1,160
    Thanked 1,028 Times in 729 Posts
    Rep Power
    323

    Re: Force Sims Log Off

    apeo:
    You may find that the partial downloaded files may stop the downloading of the rest of the files as Solus 2 only looks into the download folder of Sims for file signatures this can be annoying but if you delete these files then start the download again it should start from the beginning and then get the full upgrade. I had to do the July upgrade twice because two days after i did the first upgrade there was another upgrade to the first upgrade which was an enhanced upgrade due to the fact that the first upgrade was defective. There got that out but everything ok now. Took me ten minutes first upgrade and then 5mins for second, mind you we have 100Mb broadband connection.
    Good luck

  10. #10
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,386
    Thank Post
    10
    Thanked 483 Times in 423 Posts
    Rep Power
    110

    Re: Force Sims Log Off

    SQL anywhere does not affect solus upgrades afaik. I have had the same issue with users aparently being logged in. Do you have bromcom at all? I always shut ours down due to its constant comunication with with sims.

    There is some issue with solus2. I am almost certain that it attempts to upgrade the database before it has finished unlocking it from the backup. This leaves me with the unfinalised setups folder, which causes errors in further update attempts - it has a nice long name of numbers and characters, and is only renamed if the db upgrade is sucessful.

    Solus 1 was painful enough. Solus 2 has become a 3 hour long sims nightmare for patching.

  11. #11

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,374
    Thank Post
    625
    Thanked 951 Times in 653 Posts
    Blog Entries
    2
    Rep Power
    318

    Re: Force Sims Log Off

    You could use a remote process killer (like my own RPKiller :P) and close PULSAR.EXE on workstations...

  12. #12
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,386
    Thank Post
    10
    Thanked 483 Times in 423 Posts
    Rep Power
    110

    Re: Force Sims Log Off

    Its not just that. I've had it fail with just the user running solus logged in!

  13. #13

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,853
    Thank Post
    1,160
    Thanked 1,028 Times in 729 Posts
    Rep Power
    323

    Re: Force Sims Log Off

    Not talking about Solus upgrade per-se but the fact the users are logged in when we are doing upgrades via solus. so to deter these users after we have asked them kindly to log out of the Sims I shutdown the SQL server so that they are disconected to any sessions that they have in Sims. Then when i am sure that i have their undivided attention i send them a messege to their screens to let them know that the upgrade is in process and that they will not be allowed access to the Sims. I then give them 5 mins to try their luck after which they will be fed up and then i start the SQL server again and run the Solus upgrade. To date i have had no problems so far.

  14. #14
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41

    Re: Force Sims Log Off

    Quote Originally Posted by bossman
    apeo:
    You may find that the partial downloaded files may stop the downloading of the rest of the files as Solus 2 only looks into the download folder of Sims for file signatures this can be annoying but if you delete these files then start the download again it should start from the beginning and then get the full upgrade. I had to do the July upgrade twice because two days after i did the first upgrade there was another upgrade to the first upgrade which was an enhanced upgrade due to the fact that the first upgrade was defective. There got that out but everything ok now. Took me ten minutes first upgrade and then 5mins for second, mind you we have 100Mb broadband connection.
    Good luck
    Yeah thats what i was doing just.. by removing the package and redownloading.. this is the 3-4 time.. so annoying. Our sims is ms sql 2000 and yes i have restarted it with no luck..

    Contacted capita about how to kick users off and i was advised to run dbupgrade, only thing is i have nothing to upgrade (ie the upgrade files are in the temp folder solus creates and capita didnt want me to use dbupgrade from there) so i was told to run a patch (this one was 5685) and install it. At that point i have to option to kick users off.. kinda odd solution but i was told this patch can be run anytime.

  15. #15
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,040
    Thank Post
    22
    Thanked 175 Times in 121 Posts
    Rep Power
    51

    Re: Force Sims Log Off

    @Bossman: You've shown shutting down SQL Anywhere server which is only for the Finance package - FMS. To shut down the full SQL server via the SQL Server Service Manager - right click icon in notification area.

    To kick out users from the SQL server I have heard about running a patch that will not alter your data - where you'd get one of these though is another question.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 13
    Last Post: 8th November 2007, 02:53 PM
  2. System Force IT
    By it_badger in forum Bad Experiences
    Replies: 19
    Last Post: 16th October 2007, 03:12 PM
  3. Force shutdown when laptop lid closed
    By Homer in forum Windows
    Replies: 3
    Last Post: 23rd June 2007, 07:09 PM
  4. Force Group Policy installation to run again
    By Craig_W in forum Windows
    Replies: 4
    Last Post: 28th November 2006, 11:38 AM
  5. Force Teachers to update laptops
    By eejit in forum Windows
    Replies: 18
    Last Post: 13th July 2006, 06:03 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
  •