+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, EventLog Messages after SQL2005 upgrade & Sims.Net migration in Technical; The SQL2005 upgrade & Sims.Net migration went okay (can log in to Sims.Net okay) but now I've got loads of ...
  1. #1

    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

    EventLog Messages after SQL2005 upgrade & Sims.Net migration

    The SQL2005 upgrade & Sims.Net migration went okay (can log in to Sims.Net okay) but now I've got loads of 'Failure Audit - Login failed for user 'sims'. [CLIENT: xx.xxx.xx.xx]' messages in the Application log.

    Thanks to:

    http://support.microsoft.com/kb/555332

    I know the cause but can I change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
    to "Mixed Mode (Windows Authentication and SQL Server Authentication)" as the KB resolution suggests? Or will this bugger things up?

  2. #2
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: EventLog Messages after SQL2005 upgrade & Sims.Net migra

    Have you restarted the server?

    You should be OK as long as you don't use single sign on for SIMS (it should have been set to mixed anyway :?)

    Once you've switched to mixed mode you will still get a few of these. According to capita these error messages are for information only and are no need for concern (except when your error log gets chokka block and your server falls over)

  3. #3

    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

    Re: EventLog Messages after SQL2005 upgrade & Sims.Net migration

    Hi TeddyKGB,

    Thanks for the help. Yeah, have rebooted the box a few times, and that's what's confused me as it is set to mixed as per Capita's instructions but I'm still getting rafts of these messages appearing.

    Suppose I'm not suprised Capita are saying we should expect to see these messages. Just don't like the words FAILURE AUDIT filling up my log lol. Have notified LEA support but as it's the holiday I'm not expecting a response until next Monday.

  4. #4

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    115

    Re: EventLog Messages after SQL2005 upgrade & Sims.Net migration

    Al you can really do is verify that the reg value LoginMode=2 (where "[blah]" is probably "MSSQL.1") in this key:

    HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\[blah]\MSSQLServer

    Then wait for Capita to sort it out (what do you think your LEA can do?).

  5. #5

    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

    Re: EventLog Messages after SQL2005 upgrade & Sims.Net migration

    Quote Originally Posted by PiqueABoo
    Al you can really do is verify that the reg value LoginMode=2 (where "[blah]" is probably "MSSQL.1") in this key:

    HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\[blah]\MSSQLServer

    Then wait for Capita to sort it out (what do you think your LEA can do?).
    Thanks for the info. As to what the LEA can do - perhaps they could sacrifice a chicken or something? 8O

  6. #6
    amvc's Avatar
    Join Date
    Oct 2007
    Posts
    136
    Thank Post
    39
    Thanked 14 Times in 12 Posts
    Rep Power
    18

    Re: EventLog Messages after SQL2005 upgrade & Sims.Net migration

    Hi

    I get exactly the same 'Failure Audit' entries in the Application Log. Dozens of them!

    I'm running in mixed mode as required and the SIMS upgrade to SQL2005 was fine and all works correctly. So why these entries??

    If anybody out there can work this out...

  7. #7

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79

    Re: EventLog Messages after SQL2005 upgrade & Sims.Net migration

    This is caused by some redundant pre-August code for Teachers Desktop upgrades. It should have no effect on your use of SIMS. It may not be possible to fix this for November release but should be fine for December.

  8. #8

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    115

    Re: EventLog Messages after SQL2005 upgrade & Sims.Net migration

    perhaps they could sacrifice a chicken or something?
    Dunno about yours but we're usually too busy sticking pins into effigies of school NetMans..

SHARE:
+ Post New Thread

Similar Threads

  1. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 02:06 PM
  2. Replies: 1
    Last Post: 21st December 2007, 03:21 PM
  3. SIMS Migration help
    By randle in forum MIS Systems
    Replies: 17
    Last Post: 10th November 2007, 12:00 PM
  4. SIMS migration - help needed!
    By ndavies in forum MIS Systems
    Replies: 15
    Last Post: 9th October 2007, 02:21 PM
  5. SIMS - Migration to new Domain
    By Gatt in forum Windows
    Replies: 2
    Last Post: 20th December 2006, 01:06 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
  •