+ Post New Thread
Results 1 to 15 of 15
MIS Systems Thread, SIMS Schools Database login error in Technical; We've just shifted to a locally hosted SIMS server, and things had gone reasonable well, until I found out today ...
  1. #1
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    386
    Thank Post
    160
    Thanked 66 Times in 55 Posts
    Blog Entries
    8
    Rep Power
    22

    SIMS Schools Database login error

    We've just shifted to a locally hosted SIMS server, and things had gone reasonable well, until I found out today that our Exams Officer can no longer access the Examinations module in SIMS. She gets a log box stating Login Using Trusted User or SQL Server User, rather than logging in automatically. Any attempt to login brings up the following error message:

    "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

    I know this is PC specific, as the Examinations module works fine on my machine, and the data manager's PC.

    Any help on this would be much appreciated, I'm not really sure where to even start looking...

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    Tried reinstalling SIMS on that client, as the administrator account. Exams is notorious for failing to upgrade and if you moved server , most likely some settings will have changed for connect.ini / sims.ini

  3. #3
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    386
    Thank Post
    160
    Thanked 66 Times in 55 Posts
    Blog Entries
    8
    Rep Power
    22
    Thanks for the help vikpaw, most appreciated.

    I've tried to follow the instructions found here:

    Exams Organiser - "Automation Error"

    However as the SIMS infrastructure isn't appearing on the Add/Remove programs list, I don't think I properly uninstalled SIMS before trying to reinstall it, as a result, I'm getting the same error message.

    Any idea on how to uninstall SIMS when it's been installed using Solus 3?

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    It doesn't show up any more, but if you rename the sims folder it should be enough and choose to overwrite all files when reinstalling. Not sure how Solus3 does it.
    You can probably tell it to uninstall sims, then redeploy.
    the old way if you still have a setups folder is to run simsinst.exe

    Has anything changed on the client side, new PC, different permissions on network or PC etc.? Did you use trusted logins before? Exams probably still wants teh old school dos logins. maybe you can try with different users? so login as you on that machine and try it under your account for both, then your account pc, their account sims, etc. different combos.

    I think worst case even try installing to a new PC, i know a few times where the quickest solution has been to reinstall the PC, but that seems drastic when you have a vaguely helpful message. what happens if you tell it to use trusted user by teh way? or don't you use trusted logins?

  5. Thanks to vikpaw from:

    simpsonj (20th August 2013)

  6. #5
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    386
    Thank Post
    160
    Thanked 66 Times in 55 Posts
    Blog Entries
    8
    Rep Power
    22
    We use trusted logins, though I purposely left myself and the Exams Office off for added security, so we both still need to login to SIMS using a SIMS user account rather than a linked AD account.

    I'll try some different logins, I've just started the third reinstall from solus 3 (easy enough to do, just find the lastest update in deployment history and redeploy to the affected workstation). I'm also waiting on 153 Windows updates, which could be causing the issue as well.

    Thanks again for the pointers!

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    Try re-adding permissions to exams user or changing password.
    Or make a new user for testing. This might propagate permissions.
    Changing server means some logins may get corrupted as they are stored out of the main db and copied in only during certain tasks.

  8. #7
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    386
    Thank Post
    160
    Thanked 66 Times in 55 Posts
    Blog Entries
    8
    Rep Power
    22
    If i log in as a domain admin on the workstation, but log in to SIMS as the Exams Officer, SIMS Examinations works absolutely fine. Trouble is, A2C migration isn't setup on that account. One step forward, one step back. Just changed permissions to give the Exams Office explicit full control over C:\WINDOWS and C:\Program Files\SIMS\ as well as being a local admin to see if that fixes the issue.

  9. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    Explicit perms should do it.

  10. #9
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    386
    Thank Post
    160
    Thanked 66 Times in 55 Posts
    Blog Entries
    8
    Rep Power
    22
    It short, it didn't work. So I tried making the Exams Officer account a domain admin, and it still didn't work. Next step, I copied the Exams Officer account in AD, added a 2 to username and surname, logged in and SIMS Examinations module is now working. Copied over relevant Desktop, documents, favourites and A2C Migration settings and we're good to go.

    However, I would like to know, where does SIMS store local user information? If I can find and delete that folder, then hopefully I can reuse the old account again.

    Still, I've got a working solution, thank you @vikpaw for your help, most appreciated!

  11. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    Sims data usually goes into the users my documents folder. my sims documents. That is per user.
    If the issue was with the particular user, SIMS shouldn't really know the difference. I take it they are logging in with the same sims user account?
    You can try deleting the original user's my docs folder, but if that was causing an issue, they would have had it on all computers.
    Maybe the profile was corrupt. Do you use roaming profiles?
    If it's windows 7, that stores weird bits of the profile locally, e.g. the sims temp docs, but that shouldn't affect access.

  12. Thanks to vikpaw from:

    simpsonj (21st August 2013)

  13. #11
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    286
    Thank Post
    31
    Thanked 67 Times in 39 Posts
    Rep Power
    33
    Reinstall SIMS .net using SIMSApplicationSetup.exe
    SOLUS3 does not work frustratingly.
    Don't need to uninstall the infrastructure first or SIMS .net.
    Don't ask my why that works, it just does.
    Just sorted out the same issue this evening.

  14. Thanks to Ghostgame from:

    simpsonj (21st August 2013)

  15. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    But it can't be that now if it works for the other cloned user.

  16. #13
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    386
    Thank Post
    160
    Thanked 66 Times in 55 Posts
    Blog Entries
    8
    Rep Power
    22
    Very strange, I might try reinstalling using the method @Ghostgame posted once results day has passed!

  17. #14
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    286
    Thank Post
    31
    Thanked 67 Times in 39 Posts
    Rep Power
    33
    The fix works for the automation error, so hopefully it will work for you.

    Quote Originally Posted by vikpaw View Post
    But it can't be that now if it works for the other cloned user.
    I know what you mean, makes no sense.
    School I had dealt with had cloned the SIMS folder on 4 machines for their exam officers.
    Only 1 out of the 4 did not work.

  18. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,428
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    Welcome to COM+ hell

    Another reason why Capita needs to upgrade Exams and Nova.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Database Configuration Error
    By kysumu in forum MIS Systems
    Replies: 4
    Last Post: 3rd October 2013, 03:22 PM
  2. [SIMS] Sims database properies error
    By kcymer in forum MIS Systems
    Replies: 2
    Last Post: 23rd June 2012, 10:23 AM
  3. [SIMS] Running an addional sims.net database for testing.
    By sj2780 in forum MIS Systems
    Replies: 18
    Last Post: 12th January 2012, 07:29 AM
  4. [SIMS] Sims on Win7 install error [SOLVED]
    By edutech4schools in forum MIS Systems
    Replies: 12
    Last Post: 16th November 2010, 03:08 PM
  5. moved sims sql database but logins not moved
    By Jamie_a in forum MIS Systems
    Replies: 3
    Last Post: 13th November 2010, 10:06 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
  •