+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, SIMS System Manager Module error in Technical; Hi, I was dabbling about within SIMS System Manager and may have done something I shouldn't with the "System Manager" ...
  1. #1
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18

    SIMS System Manager Module error

    Hi,

    I was dabbling about within SIMS System Manager and may have done something I shouldn't with the "System Manager" user although didn't save anything I attempted to change yet when now trying to add users to groups I get the attached error. The user does still get added to the group but am not sure what I need to do to stop this error from appearing. Any ideas?
    Attached Images Attached Images

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,127
    Thank Post
    352
    Thanked 575 Times in 472 Posts
    Rep Power
    141
    Log a call with Local support team

  3. #3
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18
    Already have. This was while I was waiting for a callback...

  4. #4

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,033
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Making any changes in System Manager
    Warning Microsoft OLE DB Provider for SQL Server - User or role 'SIMS_<Teacher Name>' does not exist in this database.


    Where <Teacher Name> is the login name for a staff member and SIMS is the database name.
    This is usually a teacher who has left and has been made inactive
    Advice
    This problem is a warning message and can be ignored.


    To resolve the problem, please detach and re-attach the database using dbattach.

  5. Thanks to creese from:

    randle (20th October 2010)

  6. #5
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18
    As simple as that eh!! I'll give it a go and see what happens.

  7. #6

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,033
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Should be. I've seen it a few times before.

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,127
    Thank Post
    352
    Thanked 575 Times in 472 Posts
    Rep Power
    141
    Surely you wouldn't have a user called manager... wait... take it back.

  9. #8

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,151
    Thank Post
    369
    Thanked 365 Times in 323 Posts
    Rep Power
    145
    I've had that error before and as mentioned above - a detach / reattach fixed it.

  10. Thanks to Sylv3r from:

    randle (20th October 2010)

  11. #9
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18
    Just about to perform this. I take it i'm using the "SIMS Database Management Utility" and not ticking the "Drop SQLServer Logins" box?

  12. #10

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,033
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    DBattach.exe, yes. Don't tick the box.

  13. #11

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,033
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Quote Originally Posted by jinnantonnix View Post
    The tension mounts....
    Q the drum roll

  14. #12
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18
    Was a bit like that I tell ya. Never quite know when you're going to get a Unhandled exception or something along those lines Anyway all went as planned and the warning no longer appears. Thanks very much.

  15. #13

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,033
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Glad to hear it worked.

  16. #14

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    59
    Thank Post
    5
    Thanked 14 Times in 11 Posts
    Rep Power
    16
    Glad this is sorted - One of the things that has caused this error in the past is if you provision users using the ADProvisioning tool to SLG and those users are not a member of any permissions group in System Manager.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS System Manager Event Log?
    By Rawns in forum MIS Systems
    Replies: 9
    Last Post: 22nd June 2010, 01:16 PM
  2. SIMS Examination Organiser Module error
    By aneena in forum MIS Systems
    Replies: 7
    Last Post: 14th May 2010, 02:32 PM
  3. SIMS System Manager annoyance
    By timbo343 in forum MIS Systems
    Replies: 6
    Last Post: 12th September 2009, 02:29 PM
  4. System Manager access in SIMS.net
    By WFellows in forum MIS Systems
    Replies: 7
    Last Post: 2nd July 2009, 10:59 AM
  5. SIMS system manager documentation
    By peterteckhokgoh in forum MIS Systems
    Replies: 8
    Last Post: 2nd January 2009, 12:56 PM

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
  •