+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 24
MIS Systems Thread, SQL memory issues and Reason 0 in Technical; Dear All, We're having a bit of a nightmare with sims.net and the March update. Although I'm not convinced the ...
  1. #1

    Join Date
    Mar 2007
    Location
    Milton Keynes
    Posts
    34
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SQL memory issues and Reason 0

    Dear All,

    We're having a bit of a nightmare with sims.net and the March update. Although I'm not convinced the march update has anything to do with it as our problems starting happening about 3 weeks ago.

    Basically we're getting the Reason 0 when people try to login. At first it was random people, which turned into the whole school. After speaking to capita, they suggested that we do admin work directly on the server as this with use SQL named pipes and should there be a problem, it will not lock the whole database in maintenance mode.

    We tried this and it seemed to work for a little bit.

    Roll forward to today. I performed the March 2009 update last night and all worked ok. I logged into a number of machines and the update run fine. We already had some users who still were getting the Reason 0 problem before the update. They still had the problem after the update, along with some new staff. Capita suggested resetting their passwords in system manager. This actually worked. However, those same people are now getting the same problem. Only this time when we try and reset their password, it doesn't seem to make any difference. Still Reason 0.

    Our sims.net server is running under Virtual Server 2005r2 but here is the spec.

    Hosting Server: Dell PowerEdge 2950, 2 x Quad Xeon E5320, 16GB Ram, 1TB SAN

    Virtual Server (for sims.net): Windows 2003r2, 3.7GB Ram

    One thing I have notice is that SQL doesn't use any more then 1.7GB. Yet I've assigned 3.7GB to the server. Is there a way I can allocate another 1GB of ram to SQL with it making the machine too slow. Surely that's got to help?

    Still waiting for capita to get back about the reason 0 issues. I know the detaching the database and reattaching will fix it but it's not ideal. Finance are doing their year end at the moment so they won't be too happy.

    any help greatly received.

    Len

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,164
    Thank Post
    522
    Thanked 2,558 Times in 1,985 Posts
    Blog Entries
    24
    Rep Power
    879
    What version of SQL are you using Express or full?

  3. #3

    Join Date
    Mar 2007
    Location
    Milton Keynes
    Posts
    34
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We're running the SQL 2005 Full version

  4. #4
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    972
    Thank Post
    38
    Thanked 174 Times in 139 Posts
    Rep Power
    96
    Reason 0 normally points to an error with the connect.ini

    Have you changed any shares or links on the network that point to a connect.ini

  5. #5

    Join Date
    Mar 2007
    Location
    Milton Keynes
    Posts
    34
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    No we haven't changed anything. We have a user who cannot log into sims on their PC but if they use someone elses sims.net login, it works ok. Leaves me to believe it's a database issue rather then a PC issue.

    The person who then tries another PC still cannot login. So people who cannot login, the problems followes them around the site.

  6. #6
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    972
    Thank Post
    38
    Thanked 174 Times in 139 Posts
    Rep Power
    96
    Capita advise for this would be to dettach the database and re attach.

    Have you checked the event logs on the machines at the time that users try to login and also take a look at the server at the same time.

  7. #7

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    396
    We have experienced this same problem only three weeks ago.

    We have yet to have the March upgrade rolled out to us so that was not a factor for us.

    The KB article on the Capita site lists 7 possible fixes, none of which were applicable to us.

    Capita finally said to detach - re-attach the database, by which time our problem had mysteriously disappeared on its own.

    We still do not know the cause of the problem, which randomly affected both existing and new users, teaching and non-teaching. Resetting their passwords worked in some cases, not in others.

  8. #8

    Join Date
    Mar 2007
    Location
    Milton Keynes
    Posts
    34
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I figured that was going to be their standard answer. How easy is it to detached and reattach the database. Capita have remote controlled our server before and said they would prefer to do it. I've had a look at the DBAttach. Is there anything I should do before hand. I think Capita moved the database into another folder and allowed it to be copied back? Does that sound right. I would imagine that's why it took so long. Surely just detaching and re attaching would be ok?

    In terms of my server event log, I'm getting plenty of these

    Login failed for user 'SIMSRedirectService'. [CLIENT: 10.82.23.2]

    &

    Login failed for user 'sims_sheilab'. [CLIENT: 10.82.23.2]

  9. #9
    AyatollahPies's Avatar
    Join Date
    Jan 2008
    Location
    Earth
    Posts
    900
    Thank Post
    48
    Thanked 105 Times in 95 Posts
    Rep Power
    42
    We've had a few reason 0's recently. Usually fixed by recreating connect.ini as someone else mentioned, but this wasn't making a difference this time.

    The only thing we found that seemed to be a common issue, was that SIMS stopped working as soon as the schools internet went down. As soon as the internet came back up, so did SIMS.

    I know what you're thinking, there is absolutely no link and you're right. We first thought that perhaps the DNS settings were wrong, but they all checked out. We could fully ping the SIMS servers from the workstations and vice-versa.

    Happens to be a very strange and frequent co-incidence of late though.

  10. #10
    garrysaddington's Avatar
    Join Date
    May 2007
    Location
    Hogsthorpe
    Posts
    89
    Thank Post
    3
    Thanked 25 Times in 16 Posts
    Rep Power
    39
    Quote Originally Posted by Ayatollah Pies View Post

    I know what you're thinking, there is absolutely no link and you're right. We first thought that perhaps the DNS settings were wrong, but they all checked out. We could fully ping the SIMS servers from the workstations and vice-versa.

    Happens to be a very strange and frequent co-incidence of late though.
    Just a stab in the dark really. How is dns accessed? We once had a similar problem (not SIMS though) when dns was actually being served by the internet router and we had to install dns internally, because if the router died so did all our thin clients. Of course if you are using an external dns server and internet goes down then.....
    HTH
    Regards
    Garry

  11. Thanks to garrysaddington from:

    AyatollahPies (31st March 2009)

  12. #11
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,355
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    We had the same issue with Reason 0 here, seems to point to a general connection error. Connect.ini all fine, seemed to go away on its own here as well. It seemed to appear for us during periods of high network traffic and when the server was under extreme load. It was especially common when we had the antivirus scan scheduled over lunch with people logging onto it around that time it tended to have a hissy fit!

  13. #12
    AyatollahPies's Avatar
    Join Date
    Jan 2008
    Location
    Earth
    Posts
    900
    Thank Post
    48
    Thanked 105 Times in 95 Posts
    Rep Power
    42
    Quote Originally Posted by garrysaddington View Post
    Just a stab in the dark really. How is dns accessed? We once had a similar problem (not SIMS though) when dns was actually being served by the internet router and we had to install dns internally, because if the router died so did all our thin clients. Of course if you are using an external dns server and internet goes down then.....
    HTH
    Regards
    Garry
    Admin server which hosts SIMS is also the DNS server. We wondered if the clients might have somehow been going out of the LAN and then back in, but this wasn't the case.

    It's a strange one that's for sure.

  14. #13

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    I fix reason 0's in the following order,

    -Check services (you'd be surprised)
    -Connect.ini's - check local redirects - check the server's one is correct.
    -Add time out (don't ask me why but it sometimes works
    -Change server name to IP
    -Don't redirect the local connect.ini replace it with the server's one
    -De-attach/re-attach
    -Reinstall - always reluctant to do this but sometimes your left with no choice

    If it become a consistent problem more related to usernames you could map the Sims usernames via AD?

    All of the above work it just depends what the scenario is.

  15. Thanks to Steve_T from:

    Oops_my_bad (29th November 2009)

  16. #14

    Join Date
    Mar 2007
    Location
    Milton Keynes
    Posts
    34
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Think we might have found the cause of the problem but don't really know how to fix it.

    It seems that the when you use Sims System Manager to create users or reset passwords etc that is when the reason 0 problem starts.

    We were told not to use system manager on a workstation as if there is a timeout, it leaves the SQL database in maintenance mode and you have to detach and re attach it. Capita suggestion was to do it on the server as this uses named pipes and not TCPIP for connection.

    We did this and initially we thought it seemed to fix the problem. However, it started going wrong again. We're about 95% sure that it's system manager that is causing problems with peoples accounts and not necesssary the account your editing.

    Can anyone confirm if they are having the same problem. You might find that when you have the problem, it's always after system manager has been used.

    I've told our person who uses it to do all the changes at the end of the day. Only people who use sims.net so infrequently are likely to forget their passwords. Why upset our power users because we have to reset someone's password during the day. They can wait until the end of the day and if it goes wrong, it doesn't upset too many people.

  17. #15
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    972
    Thank Post
    38
    Thanked 174 Times in 139 Posts
    Rep Power
    96
    We have had the same problem and it is fixed by detaching and then re attaching the database.



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

Similar Threads

  1. [SIMS] SQL migration "Login failed: Reason 0"
    By zag in forum MIS Systems
    Replies: 52
    Last Post: 16th January 2011, 04:15 PM
  2. Another reason not to choose Acer
    By Gibbo in forum Bad Experiences
    Replies: 15
    Last Post: 26th February 2009, 08:12 PM
  3. Reason 3
    By amvc in forum MIS Systems
    Replies: 3
    Last Post: 9th June 2008, 10:50 AM
  4. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 06:10 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
  •