+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, SIMS System Manager annoyance in Technical; We have a little annoying problem with system manager in SIMS. We have removed a member of staff as they ...
  1. #1

    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,195
    Thank Post
    321
    Thanked 314 Times in 219 Posts
    Rep Power
    125

    SIMS System Manager annoyance

    We have a little annoying problem with system manager in SIMS. We have removed a member of staff as they dont work here any more and we are getting a Warning on the database whenever we try to make any changes. It isnt causing the database to not function correctly, its just very annoying. The error is

    "Microsoft OLD DB Provider for SQL server -iser or role 'simsshs_USERNAME' does not exist in this database"

    Even if we add the user back into the database we get the same error

    Can anyone help us out on this matter?

    Thanks

    Tim

  2. #2
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30
    This has only stopped happening to me now that I have moved to a new server. Should have spoken to Capita about it but, frankly I just couldn't face the helpdesk hassle.

    Didn't stop anything working so just put up with it.

  3. Thanks to skunk from:

    timbo343 (11th September 2009)

  4. #3
    Diello's Avatar
    Join Date
    Jun 2005
    Location
    Kent, England
    Posts
    1,067
    Thank Post
    117
    Thanked 228 Times in 128 Posts
    Rep Power
    75
    Try using dbAttach to detach the database, then move the mdf & ldf out of the data directory, then use dbAttach to reattach the database.

    Usually does it.

  5. Thanks to Diello from:

    timbo343 (11th September 2009)

  6. #4
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30
    Thanks essentially what I did with the new server, but a wee bit cheaper

  7. #5

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,268
    Thank Post
    379
    Thanked 388 Times in 343 Posts
    Rep Power
    150
    Quote Originally Posted by timbo343 View Post
    We have a little annoying problem with system manager in SIMS. We have removed a member of staff as they dont work here any more and we are getting a Warning on the database whenever we try to make any changes. It isnt causing the database to not function correctly, its just very annoying. The error is

    "Microsoft OLD DB Provider for SQL server -iser or role 'simsshs_USERNAME' does not exist in this database"

    Even if we add the user back into the database we get the same error

    Can anyone help us out on this matter?

    Thanks
    Tim
    I have this problem happening here with 3 or 4 users listed. Will try the detach / reattach trick

  8. #6

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,162
    Thank Post
    1,924
    Thanked 1,358 Times in 748 Posts
    Blog Entries
    3
    Rep Power
    400
    We had it some months back and the detach / reattach trick worked for us.

  9. #7


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,706
    Thank Post
    354
    Thanked 807 Times in 722 Posts
    Rep Power
    348
    Seen this when we took on SLG2 before I left; happened when an account was created in System Manager but not linked from personnel or whatever. (Whilst waiting for personnel to put people on the system we were pushed to give them SIMS access so this worked as a measure)..



SHARE:
+ Post New Thread

Similar Threads

  1. System Manager - North Devon
    By Alan_R in forum Educational IT Jobs
    Replies: 5
    Last Post: 9th September 2009, 01:26 PM
  2. System Manager access in SIMS.net
    By WFellows in forum MIS Systems
    Replies: 7
    Last Post: 2nd July 2009, 11:59 AM
  3. SIMS system manager documentation
    By peterteckhokgoh in forum MIS Systems
    Replies: 8
    Last Post: 2nd January 2009, 01:56 PM
  4. SIMS (Aug 2007) System Manager on Vista
    By enjay in forum MIS Systems
    Replies: 2
    Last Post: 3rd October 2007, 12:16 PM
  5. SIMS System Manager backup path
    By Quatermass in forum MIS Systems
    Replies: 2
    Last Post: 12th September 2007, 10:24 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
  •