+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Problem after SQL Migration in Technical; Since doing the MSDE to SQL Express migration, my error log is reporting the below when someone tries to log ...
  1. #1

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    817
    Thank Post
    175
    Thanked 104 Times in 72 Posts
    Rep Power
    185

    Problem after SQL Migration

    Since doing the MSDE to SQL Express migration, my error log is reporting the below when someone tries to log in, even though SIMS appears to work correctly;

    Event Type: Failure Audit
    Event Source: MSSQL$SIMS2005
    Event Category: (4)
    Event ID: 18456
    Date: 24/10/2007
    Time: 08:50:45
    User: N/A
    Computer: ADMIN
    Description:
    Login failed for user 'sims'. [CLIENT: xx.xx.xx.xx]
    Data:
    0000: 18 48 00 00 0e 00 00 00 .H......
    0008: 0f 00 00 00 41 00 44 00 ....A.D.
    0010: 4d 00 49 00 4e 00 5c 00 M.I.N.\.
    0018: 53 00 49 00 4d 00 53 00 S.I.M.S.
    0020: 32 00 30 00 30 00 35 00 2.0.0.5.
    0028: 00 00 07 00 00 00 6d 00 ......m.
    0030: 61 00 73 00 74 00 65 00 a.s.t.e.
    0038: 72 00 00 00 r...

    Event Type: Warning
    Event Source: SQLBrowser
    Event Category: None
    Event ID: 3
    Date: 24/10/2007
    Time: 09:10:40
    User: N/A
    Computer: ADMIN
    Description:
    The configuration of the AdminConnection\TCP protocol in the SQL instance SIMS2005 is not valid.



    I've obviously removed the IP address from this error. Any idea what's going on? Is it related to the fact that SIMS now takes about 90 seconds to open whereas prior to the migration it was about 30?

    Any help greatfully received.

    Thanks

    Stuart

  2. #2

    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,343 Times in 742 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: Problem after SQL Migration

    Apparently the 'Audit Failure' is a 'feature' of using SQL 2005 - on Capita SupportNet KB72846 there is some information stating that these log entries are 'not a cause for concern'.....

    Roll on the bug fix, eh Capita?

    My app log is chocka with these now :-(

  3. #3

    Join Date
    Oct 2007
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Problem after SQL Migration

    Do any of you guys schedule reports? If so have you now got problems?

    I have found that this error prevents the schedule from working. (presumably AutoReport.exe attempts to log in to the SQL Server as user 'sims').

  4. #4

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    817
    Thank Post
    175
    Thanked 104 Times in 72 Posts
    Rep Power
    185

    Re: Problem after SQL Migration

    We don't use scheduled reports.

    Any thoughts on the speed issue? Thanks for pointing that KB out to me.

    Stuart

  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,343 Times in 742 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: Problem after SQL Migration

    We haven't noticed a decrease in speed but then again Sims.Net has always been a bit of an OAP for us..... ;-)

  6. #6

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

    Re: Problem after SQL Migration

    If SIMS is running slow then there is probably another cause. For example 300 full page reports will print in less then a minute and that involves grabbing data from attendance, assessment and gluing text together.

SHARE:
+ Post New Thread

Similar Threads

  1. FMS migration - help!! (surprise)
    By ndavies in forum MIS Systems
    Replies: 10
    Last Post: 20th August 2008, 11:05 AM
  2. FMS Migration - SA
    By ndavies in forum MIS Systems
    Replies: 5
    Last Post: 10th December 2007, 12:13 PM
  3. SIMS Migration help
    By randle in forum MIS Systems
    Replies: 17
    Last Post: 10th November 2007, 12:00 PM
  4. FMS migration
    By ndavies in forum MIS Systems
    Replies: 3
    Last Post: 3rd November 2007, 02:45 PM
  5. SQL Database Migration-HELP!!
    By Mr_M_Cox in forum MIS Systems
    Replies: 3
    Last Post: 16th August 2007, 03:24 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
  •