+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, SQL loging failed in Technical; The office has reported that since they moved to SQL2005 Sims has been running slow. On checking event log I ...
  1. #1
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24

    SQL loging failed

    The office has reported that since they moved to SQL2005 Sims has been running slow. On checking event log I find this:

    Event Type: Failure Audit
    Event Source: MSSQL$SQL2005
    Event Category: (4)
    Event ID: 18456
    Date: 31/08/2007
    Time: 09:32:09
    User: N/A
    Computer: Server1
    Description:
    Login failed for user 'sims'. [CLIENT: 10.2.110.97]

    Then I check the SQL log :

    2007-08-31 09:32:09.79 Logon Error: 18456, Severity: 14, State: 5.
    2007-08-31 09:32:09.79 Logon Login failed for user 'sims'. [CLIENT: 10.2.110.97]
    2007-08-31 09:32:55.10 Logon Error: 18456, Severity: 14, State: 5.
    2007-08-31 09:32:55.10 Logon Login failed for user 'sims'. [CLIENT: 10.2.110.97]
    2007-08-31 09:32:55.25 Logon Error: 18456, Severity: 14, State: 5.
    2007-08-31 09:32:55.25 Logon Login failed for user 'sims'. [CLIENT: 10.2.110.97]

    There’s no user called sims in the AD but there is a group called sims which has all the sims users in it. I understand that a state 5 error means invalid user ID but apart from Sims running slow it works.

  2. #2

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

    Re: SQL loging failed

    Jobos, this is a suggestion from one of our technical people.

    It might be worth asking the customer if their connect.in is set to Trusted/Auto. My guess is that it is and is therefore trying to connect as an AD user and not a SIMS SQL user. They could try changing the connect .ini to Trusted (ConnectionType=Trusted), this will give them to the option to use a AD account or SIMS account. Or they could remove their ConnectionType from their connect.ini.

  3. #3
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24

    Re: SQL loging failed

    Thanks for the reply. After reading the August Sims release notes I can see where you’re coming from but I have checked the connect.ini files and there is no mention of a ConnectionType string

  4. #4

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

    Re: SQL loging failed

    Sorry I think you will need to lodge a call with your support unit. You can email me if they can't help and I'll put you in touch with our techical team.

  5. #5

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55

    Re: SQL loging failed

    I get exactly the same error. Along with it my workstations now refuse to automatically update themselves when any user tries to log into SIMS, give an error and then fail the login. I logged a call with Capita via my support unit and their great advice was to run SIMSApplicationSetups.exe on each w/s to update it manually. This updates the w/s ok but now I have to now go round the entire school & logon to every single w/s & laptop to run the update. They didn't even bother to answer my question of why I was getting the SQL errors (so they continue to fill up my logs).

    I'm sure there's a link between the two but don't know enough about SQL. And what happens when the next update arrives? Manual installs all round again??

  6. #6

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,153
    Thank Post
    215
    Thanked 1,259 Times in 790 Posts
    Blog Entries
    4
    Rep Power
    507

    Re: SQL loging failed

    Have you checked the sims.ini file in the WINDOWS directory on your machines?

    In there is has a line called "updatepath" - this must point to the sims setups directory

  7. #7
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24

    Re: SQL loging failed

    Yep. All look ok.

  8. #8

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,287
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162

    Re: SQL loging failed

    We are having this problem as well with the added complication of new sims users not being logged on till another user has logged on before them.

    Tried adding the trusted user string into the local connect.ini to get the choice between windows or sql auth and I still got the logon failure in the event viewer.

    As far as we are aware though our updating is fine.

  9. #9

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55

    Re: SQL loging failed

    Domino - my problem with auto updates was indeed to do with the sims.ini file pointing to the wrong location (I migrated to a new server during the August update, more fool me). Auto updates is now working ok so many, many thanks for your help. I wonder why Capita couldn't come up with such a simple solution...

  10. #10

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,153
    Thank Post
    215
    Thanked 1,259 Times in 790 Posts
    Blog Entries
    4
    Rep Power
    507

    Re: SQL loging failed

    we did the same thing, no worries, tripped me up - and we eventually puzzled it out ourselves.

    Other thing to check is that under the C:\program files\sims\sims.net there is a local connect.ini

    you need to make sure this points at the new server too.

  11. #11

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,153
    Thank Post
    215
    Thanked 1,259 Times in 790 Posts
    Blog Entries
    4
    Rep Power
    507

    Re: SQL loging failed

    also Has everyone checked that the SQL server is not trying to use windows authentication...? or Mixed?

    Sims may not be, but maybe SQL is...

  12. #12
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24

    Re: SQL loging failed

    I was thinking along those lines myself but I don’t have SQL server management studio installed which I believe would fix it. See http://blogs.msdn.com/sql_protocols/...21/536201.aspx

    This morning I reported the issue to our LEA. They were unaware of the problems and after checking their test server found the same errors in their logs.

  13. #13

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,287
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162

    Re: SQL loging failed

    Jobos, Server management is on CD 2. We had missed that too but found it eventually.
    Our SQL server is on Mixed mode as that is what our instructions told us to do and that is what the previous version is on.

  14. #14
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24

    Re: SQL loging failed

    Can the studio be installed without messing up the Sims install? I don’t fancy any sleepless nights :cry:

  15. #15

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55

    Re: SQL loging failed

    Yes, but be careful what you do with it once installed as SIMS is a peculiar beast. If you don't have full SQL 2005 you can download Management Studio Express Edn from MS website for free.

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

Similar Threads

  1. Leopard - failed install help
    By thegrassisgreener in forum Mac
    Replies: 8
    Last Post: 19th November 2007, 12:58 PM
  2. Failed to copy files from CD
    By Dos_Box in forum Learning Network Manager
    Replies: 13
    Last Post: 12th April 2007, 10:42 AM
  3. failed redundancy - what to do?
    By browolf in forum Hardware
    Replies: 3
    Last Post: 2nd November 2005, 08:59 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
  •