+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Check SIMS logged in users? in Technical; Gotta pay a flying visit to a school to do the August upgrade. Is there a quick way to check ...
  1. #1

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,731
    Thank Post
    1,272
    Thanked 1,644 Times in 1,100 Posts
    Blog Entries
    22
    Rep Power
    505

    Check SIMS logged in users?

    Gotta pay a flying visit to a school to do the August upgrade.

    Is there a quick way to check if anyone is logged in to SIMS? I want to avoid going round every machine to check

    Also, is there any way to stop people logging in for the duration of the upgrade?

  2. #2

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    112
    My Computer | Manage | Shared Folders | Sessions should show you what sessions are open on the machine.

    If you bring up Services.msc and kill the SQL Server Browser service, that should stop anyone logging on until you restart it.

  3. Thanks to jamesb from:

    sparkeh (10th September 2009)

  4. #3

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,731
    Thank Post
    1,272
    Thanked 1,644 Times in 1,100 Posts
    Blog Entries
    22
    Rep Power
    505
    Quote Originally Posted by jamesb View Post
    My Computer | Manage | Shared Folders | Sessions should show you what sessions are open on the machine.
    Ah yes of course - thanks for that.

    Quote Originally Posted by jamesb View Post
    If you bring up Services.msc and kill the SQL Server Browser service, that should stop anyone logging on until you restart it.
    Just to check, that won't interfere with the upgrade on the server? Does that just stop remote connections to the db?

  5. #4
    Diello's Avatar
    Join Date
    Jun 2005
    Location
    Kent, England
    Posts
    1,063
    Thank Post
    112
    Thanked 228 Times in 128 Posts
    Rep Power
    74
    I prefer using SQL Server Management Studio.

    Connect to the SIMS instance, then Management --> Activity Monitor. Shared folder sessions aren't always acurate.

    Think stopping the Browser services just stops people listing SQL instances, not stop anyone connecting to them if they already know what they're connecting to (which connect.ini does).

    To stop people connecting - Go into SQL Server Surface Area Configuration, then Services & Connections. On the left, open up the SIMS instance, then Database Engine, then Remote Connections. Then on the right pane, change Local & Remote Connections to Local Connections Only, then restart the service. Obviously you'll then need to be on the local server to do the upgrade! Change it back once the upgrade is done.

  6. 2 Thanks to Diello:

    sparkeh (10th September 2009)

  7. #5

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,731
    Thank Post
    1,272
    Thanked 1,644 Times in 1,100 Posts
    Blog Entries
    22
    Rep Power
    505
    Quote Originally Posted by Diello View Post
    I prefer using SQL Server Management Studio.
    Oh wow, yeah that looks like the way to go - thanks!

  8. #6

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    12
    Quote Originally Posted by Diello View Post
    I prefer using SQL Server Management Studio.

    Connect to the SIMS instance, then Management --> Activity Monitor. Shared folder sessions aren't always acurate.

    Think stopping the Browser services just stops people listing SQL instances, not stop anyone connecting to them if they already know what they're connecting to (which connect.ini does).

    To stop people connecting - Go into SQL Server Surface Area Configuration, then Services & Connections. On the left, open up the SIMS instance, then Database Engine, then Remote Connections. Then on the right pane, change Local & Remote Connections to Local Connections Only, then restart the service. Obviously you'll then need to be on the local server to do the upgrade! Change it back once the upgrade is done.
    I thought (may be wrong here) that the new Sims.net homepage effected the Activity Monitor and gave false positives?

  9. #7
    Diello's Avatar
    Join Date
    Jun 2005
    Location
    Kent, England
    Posts
    1,063
    Thank Post
    112
    Thanked 228 Times in 128 Posts
    Rep Power
    74
    Quote Originally Posted by Steve_T View Post
    I thought (may be wrong here) that the new Sims.net homepage effected the Activity Monitor and gave false positives?
    Well, the homepage refreshes every so often, so re-establishes the connection. So theorically they could be away from the PC at the time. However, they're still logged into SIMS.

    Personally - we give them plenty of notice, then follow up any "important" users still logged in when it's time to do the upgrade, the others have been given fair warning!

  10. #8

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,731
    Thank Post
    1,272
    Thanked 1,644 Times in 1,100 Posts
    Blog Entries
    22
    Rep Power
    505
    Thanks for the help guys.

    Turns out I can't actually do the upgrade as the LA have told me that Capita still haven't updated our IP info after combining our networks, so we can't download the updates. Great.

  11. #9
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,214
    Thank Post
    156
    Thanked 146 Times in 131 Posts
    Rep Power
    102
    Hello,

    I'm sure Solus tells you the users logged in if you are using it. Like already said, give plenty of time when you do have to go do it, I was being nagged for ages and ages because I underestimated how long it'd take... angry office staff ftl.

  12. Thanks to dwhyte85 from:

    sparkeh (11th September 2009)

  13. #10
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    I concur with dwhyte85 - you can see it from within the Solus update screen, if you click on (I think) "Information" it will tell you who is logged in (not where though, so you may need to do a bit of hunting still, depends how/where you use SIMS).

  14. Thanks to enjay from:

    sparkeh (11th September 2009)

  15. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Doesn't the new dbupgrade lock the database before actually apply the (db) upgrade thus kicking everyone off until it's down?

  16. #12
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Not quite - it locks it preventing new logons, but if someone logs in before you start the upgrade, it will fail.

  17. #13

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    We use transient connections to the database which means you can't work out who is connected. I think we are changing this with SM7.

  18. #14

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    We could use such a flag - we did way back in the dbase days. I'm pretty sure that we have a solution coming.

SHARE:
+ Post New Thread

Similar Threads

  1. How to tell which users are logged on
    By Little-Miss in forum Wireless Networks
    Replies: 5
    Last Post: 5th January 2009, 03:59 PM
  2. VNC - View all logged in users
    By flashsnaps in forum Windows
    Replies: 7
    Last Post: 20th June 2008, 08:37 AM
  3. List of users logged on a workstation
    By sLiDeR in forum Windows
    Replies: 6
    Last Post: 4th December 2007, 12:40 PM
  4. Moodle - Slow when more than a few users are logged in
    By wesleyw in forum Virtual Learning Platforms
    Replies: 18
    Last Post: 21st September 2007, 02:34 PM
  5. Change start page for logged on users
    By ajbritton in forum Comments and Suggestions
    Replies: 7
    Last Post: 12th April 2006, 08:48 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
  •