+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
MIS Systems Thread, Ghosts in Solus when doing Spring 2010 upgrade in Technical; I've got ghost users showing in 'information about your system' when using Solus 2. I thought this problem had been ...
  1. #1

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,144
    Thank Post
    1,917
    Thanked 1,346 Times in 744 Posts
    Blog Entries
    3
    Rep Power
    396

    Ghosts in Solus when doing Spring 2010 upgrade

    I've got ghost users showing in 'information about your system' when using Solus 2. I thought this problem had been sorted? All the clients are shutdown so I know it's the ghost users problem still. How do I get rid of them - I can't remember?! The database upgrade tool can't lock the database because of them.

    I'm doing the Spring release remotely - being 25 miles away from the site is a bit of a problem!

    Many thanks!

  2. #2
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,283
    Thank Post
    477
    Thanked 188 Times in 182 Posts
    Blog Entries
    3
    Rep Power
    67
    I think when we had this, the only way to solve it was a server restart.

    Whether restarting the SQL services will achieve the same result or not I don't know.

  3. Thanks to Cache from:

    tech_guy (18th May 2010)

  4. #3

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,144
    Thank Post
    1,917
    Thanked 1,346 Times in 744 Posts
    Blog Entries
    3
    Rep Power
    396
    Thanks for the suggestions - I did a server restart but bizarrely they were still there. Stopping the SQL services had no effect either. I'm flummuxed!

  5. #4

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    Theres a way to force all users out, let me see if i can dig out the thing i get sent over from our support team.

  6. Thanks to glennda from:

    tech_guy (19th May 2010)

  7. #5
    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
    Check out how to use Single User Mode. See 'KB88695 - How to force Users out of Sims.net' via SupportNet.
    It does refer to SQL Server 2005 but is still relevant to SQL Server 2008!
    Last edited by Sivadam; 18th May 2010 at 11:34 PM.

  8. Thanks to Sivadam from:

    tech_guy (19th May 2010)

  9. #6

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    Quote Originally Posted by Sivadam View Post
    Check out how to use Single User Mode. See 'KB88695 - How to force Users out of Sims.net' via SupportNet.
    This is the one i meant.

    There is also another thread about this Force Logout of SIMS?

  10. Thanks to glennda from:

    tech_guy (19th May 2010)

  11. #7
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    16
    Quote Originally Posted by Sivadam View Post
    It does refer to SQL Server 2005 but is still relevant to SQL Server 2008!
    KB96140 for SQL Server 2008, it's effectively the same process, just that it looks different to 2005.

  12. Thanks to Sarconia from:

    tech_guy (19th May 2010)

  13. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Be careful though, as depending on how you do remote access, you might not have permission to do the upgrade if you limit it to local users only. I'm sure i had problems as a remote session wasn't considered local.
    Better to use something that replicates you being at the console, like a network accessed KVM or logmein . . .

  14. Thanks to vikpaw from:

    tech_guy (19th May 2010)

  15. #9

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,144
    Thank Post
    1,917
    Thanked 1,346 Times in 744 Posts
    Blog Entries
    3
    Rep Power
    396
    Quote Originally Posted by vikpaw View Post
    Be careful though, as depending on how you do remote access, you might not have permission to do the upgrade if you limit it to local users only. I'm sure i had problems as a remote session wasn't considered local.
    Better to use something that replicates you being at the console, like a network accessed KVM or logmein . . .
    I hit the server via logmein then RDP to the sql box from there. Do you think that's going to be an issue?

  16. #10

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56
    Quote Originally Posted by tech_guy View Post
    I hit the server via logmein then RDP to the sql box from there. Do you think that's going to be an issue?
    No because you'll be accessing SQL locally from the server.

  17. Thanks to timzim from:

    tech_guy (19th May 2010)

  18. #11

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,144
    Thank Post
    1,917
    Thanked 1,346 Times in 744 Posts
    Blog Entries
    3
    Rep Power
    396
    Quote Originally Posted by timzim View Post
    No because you'll be accessing SQL locally from the server.
    Thanks, I didn't think it would be!

  19. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    will it be considered locally, if you rdp from one server to the sql server...? i can't remember what issue i had before, but i'm sure it was to do with rdp. it was a Virtual server i was accessing.
    It worked okay if i did the VMWare simulated console access, but i'm sure rdp failed as it was considered remote - but i may be wrong. just try it and see. worst case you could try and logmein to the sql box maybe...?

  20. Thanks to vikpaw from:

    tech_guy (19th May 2010)

  21. #13

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,144
    Thank Post
    1,917
    Thanked 1,346 Times in 744 Posts
    Blog Entries
    3
    Rep Power
    396
    Quote Originally Posted by vikpaw View Post
    will it be considered locally, if you rdp from one server to the sql server...? i can't remember what issue i had before, but i'm sure it was to do with rdp. it was a Virtual server i was accessing.
    It worked okay if i did the VMWare simulated console access, but i'm sure rdp failed as it was considered remote - but i may be wrong. just try it and see. worst case you could try and logmein to the sql box maybe...?
    Thanks, for reasons I do not understand we can use logmein on our DC but not our sql box....

  22. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    I don't normally go for the single user mode, though it's probably the safest way to do it. I just kick all off and remove permissions to the SIMS share (S drive), so noone can access the connect.ini that's held there and thus not log in again. The only people that have local connect.ini are myself and the IT manager so it's not a problem.
    If anyone is left in the system they will still have access but if you restart the server / sql service that should throw them out
    sorry, i'm digressing from the recommended method, which is what you need if you are having problems with ghosts.

  23. Thanks to vikpaw from:

    tech_guy (19th May 2010)

  24. #15

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56
    Quote Originally Posted by vikpaw View Post
    I just kick all off and remove permissions to the SIMS share (S drive), so noone can access the connect.ini that's held there and thus not log in again. The only people that have local connect.ini are myself and the IT manager so it's not a problem
    Doesn't this cause problems when you restore permissions & want users to connect again though? Losing rights to S: could cause connectivity errors to pop up on users' workstations (and hence calls to the helpdesk) - might need them to logoff/log again, depending on how their drives are mapped.

  25. Thanks to timzim from:

    tech_guy (19th May 2010)



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

Similar Threads

  1. [SIMS] SIMS Spring 2010 release
    By vikpaw in forum MIS Systems
    Replies: 24
    Last Post: 1st December 2010, 09:53 PM
  2. SIMS 2010 Spring Release Withdrawn
    By AyatollahPies in forum MIS Systems
    Replies: 25
    Last Post: 15th May 2010, 02:21 PM
  3. exchange 2010 upgrade
    By ful56_uk in forum Windows
    Replies: 1
    Last Post: 12th May 2010, 10:35 PM
  4. Sharepoint 2010 Upgrade error
    By Gatt in forum Windows
    Replies: 11
    Last Post: 22nd April 2010, 11:27 AM
  5. SIMS Feb 2008 upgrade - SOLUS error
    By cf23 in forum MIS Systems
    Replies: 8
    Last Post: 8th April 2008, 11:21 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
  •