+ 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,017
    Thank Post
    304
    Thanked 288 Times in 200 Posts
    Rep Power
    120

    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,063
    Thank Post
    112
    Thanked 228 Times in 128 Posts
    Rep Power
    74
    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,206
    Thank Post
    372
    Thanked 377 Times in 335 Posts
    Rep Power
    148
    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,135
    Thank Post
    1,908
    Thanked 1,344 Times in 742 Posts
    Blog Entries
    3
    Rep Power
    395
    We had it some months back and the detach / reattach trick worked for us.

  9. #7


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 796 Times in 715 Posts
    Rep Power
    347
    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, 12:26 PM
  2. System Manager access in SIMS.net
    By WFellows in forum MIS Systems
    Replies: 7
    Last Post: 2nd July 2009, 10:59 AM
  3. SIMS system manager documentation
    By peterteckhokgoh in forum MIS Systems
    Replies: 8
    Last Post: 2nd January 2009, 12:56 PM
  4. SIMS (Aug 2007) System Manager on Vista
    By enjay in forum MIS Systems
    Replies: 2
    Last Post: 3rd October 2007, 11:16 AM
  5. SIMS System Manager backup path
    By Quatermass in forum MIS Systems
    Replies: 2
    Last Post: 12th September 2007, 09: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
  •