+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 25
MIS Systems Thread, All users unable to log in "invalid username/password" error in Technical; Morning all, Got an interesting one today, our sims is no longer allowing any users to log on. It attempts ...
  1. #1

    Join Date
    Feb 2009
    Location
    Hampshire
    Posts
    82
    Thank Post
    14
    Thanked 5 Times in 5 Posts
    Rep Power
    12

    All users unable to log in "invalid username/password" error

    Morning all,

    Got an interesting one today, our sims is no longer allowing any users to log on. It attempts to process the request and then presents the prompt "invalid username or password".

    I'm unable to log in to sims server side also.

    I have already tried bouncing the server, checked the event logs, and checked the size of the database and transaction logs.

    Whilst I wait for support from the LA, has anyone else got any ideas?


    Thanks in advance!

  2. #2
    MrMat's Avatar
    Join Date
    Jul 2013
    Location
    Solihull
    Posts
    183
    Thank Post
    20
    Thanked 40 Times in 30 Posts
    Rep Power
    28
    You ran any upgrades recently? Like SQL, SIMS etc?

  3. #3

    Join Date
    Jan 2009
    Posts
    104
    Thank Post
    6
    Thanked 27 Times in 24 Posts
    Rep Power
    22
    Have you checked the time on the SIMS server? Years ago I had issues when the clock skewed more than five minutes and kerberos couldn't do it's thing!

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Checking SQL server is running on the server would be the first thing to check.

  5. #5

    Join Date
    Feb 2009
    Location
    Hampshire
    Posts
    82
    Thank Post
    14
    Thanked 5 Times in 5 Posts
    Rep Power
    12
    Hi guys,

    No changes whatsoever to Sims server since the Spring 2014 update was applied in April. Literally just stopped allowing users to log in.

    Server time has been an issue in the past but is not now. All systems showing correct time.

  6. #6

    Join Date
    Sep 2011
    Location
    Manchester
    Posts
    8
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Blog Entries
    1
    Rep Power
    0
    I would check AV/Firewall to see if anything is blocking incoming connections to the server
    Last edited by RPilkington; 2nd July 2014 at 11:40 AM. Reason: spelling mistake

  7. #7

    Join Date
    Jul 2009
    Posts
    304
    Thank Post
    8
    Thanked 47 Times in 40 Posts
    Rep Power
    17
    What does SQL manager say against the databases ? Checking they are not "recovering". Also check the default databases

  8. #8

    Ephelyon's Avatar
    Join Date
    Aug 2008
    Location
    Cheshire, England
    Posts
    1,849
    Thank Post
    351
    Thanked 392 Times in 249 Posts
    Rep Power
    162
    Does SQL Server Management Studio reveal anything - authentication logs etc? Also, are all databases attached as they should be?

  9. #9
    dalehopper's Avatar
    Join Date
    Jan 2008
    Location
    Redcar
    Posts
    36
    Thank Post
    13
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    have you checked connect.ini is pointing at correct place

  10. #10

    Join Date
    Feb 2009
    Location
    Hampshire
    Posts
    82
    Thank Post
    14
    Thanked 5 Times in 5 Posts
    Rep Power
    12
    Hi guys,

    Quick update - I did check the firewall, database attachment, sql studio, connect.ini etc etc.

    Just spent the last 45mins or so in a remote session with Capita and they couldn't explain how or why it's happened but basically about 90% of our users have had their accounts reset to 'inactive'. During that process Sims has also re-amended users' usernames to LastnameFirstname instead of our normal naming convention which is FirstinitialLastname.

    The 'fix' is for me to log in as sysman and manually change each affected user's account back to 'active' and to amend their username back to our naming convention, then supply the new randomly generated password.

    I don't know if any edugeekers have ever had this before, I've certainly never encountered the issue, neither has the support teams from my LA or Capita. Very strange indeed.

    Thanks for all the replies above.

  11. #11

    Ephelyon's Avatar
    Join Date
    Aug 2008
    Location
    Cheshire, England
    Posts
    1,849
    Thank Post
    351
    Thanked 392 Times in 249 Posts
    Rep Power
    162
    Ah... that sounds like the database has been detached and subsequently re-attached (or updated/migrated) manually without using Capita's DBAttach tool. We had something similar with that before.

  12. #12

    Join Date
    Aug 2008
    Location
    norwich
    Posts
    62
    Thank Post
    1
    Thanked 11 Times in 11 Posts
    Rep Power
    14
    That's not a fix
    How much data is likely to have changed today (given most people can't login) - I would be looking to restore the database from last nights backup as a quick fix. Or if I could get away wit it the relevant table but bit risky and would take ages of digging to find it.

  13. Thanks to cullingsh from:

    vikpaw (2nd July 2014)

  14. #13

    Join Date
    Feb 2009
    Location
    Hampshire
    Posts
    82
    Thank Post
    14
    Thanked 5 Times in 5 Posts
    Rep Power
    12
    Quote Originally Posted by cullingsh View Post
    That's not a fix
    How much data is likely to have changed today (given most people can't login) - I would be looking to restore the database from last nights backup as a quick fix. Or if I could get away wit it the relevant table but bit risky and would take ages of digging to find it.
    I'm painfully aware that's not a fix - after all i'm the one who has to sit here manually changing everyone's details for however long that's going to take(!).

    I can certainly vouch that no database changes/upgrades were done on the sims server since the Spring 14 update was released in April.

    Re: last night's backup - the problem first occurred at 3.40pm yesterday afternoon and the backup took place at 6.07pm. I was toying with the idea of going back to the 30th June backup, but unfortunately it's reports season and so much data has been written in that 24hour period that i'd probably be lynched by the staff if I said they'd lost it all.

  15. #14

    Join Date
    Feb 2009
    Location
    Hampshire
    Posts
    82
    Thank Post
    14
    Thanked 5 Times in 5 Posts
    Rep Power
    12
    Quote Originally Posted by cullingsh View Post
    That's not a fix
    How much data is likely to have changed today (given most people can't login).
    Oh yeah...should add, two support staff members were able to log in, so of course they shared their login details with EVERYONE :-/

    So yeah there's probably too much data from today as well now.

  16. #15
    Jasbo's Avatar
    Join Date
    Mar 2014
    Location
    West Sussex
    Posts
    152
    Thank Post
    12
    Thanked 20 Times in 20 Posts
    Rep Power
    5
    That's your day sorted then....

    Has anyone else got admin access at a level allowing them to do any actions that would result in the issue?

    Perhaps the data entry would be less arduous after you have flogged someone?

    Have a quick scan round the office for any lack of eye contact and flushed faces



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

Similar Threads

  1. Replies: 23
    Last Post: 15th May 2012, 05:55 PM
  2. Replies: 0
    Last Post: 10th October 2011, 06:36 PM
  3. New users unable to print in colour
    By andrew_r_jackson in forum Windows
    Replies: 3
    Last Post: 11th November 2008, 04:42 PM
  4. Users unable to add favorites in IE7
    By jamin100 in forum Windows
    Replies: 9
    Last Post: 21st April 2008, 09:29 AM
  5. New users can't log in to Outlook Web Access
    By WithoutMotive in forum Windows
    Replies: 5
    Last Post: 7th September 2007, 12:17 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
  •