+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
MIS Systems Thread, SQL memory issues and Reason 0 in Technical; Sorry to post on an old thread.... But I have this very issue and dettaching and reattaching hasnt helped... We ...
  1. #16

    Join Date
    Dec 2005
    Posts
    542
    Thank Post
    38
    Thanked 90 Times in 80 Posts
    Rep Power
    39
    Sorry to post on an old thread....

    But I have this very issue and dettaching and reattaching hasnt helped...

    We have just been recommended to upgrade our old server to a faster one.

    Anyone else have other fixes for this issue?

  2. #17

    Join Date
    Sep 2005
    Location
    W. Cumbria
    Posts
    89
    Thank Post
    15
    Thanked 3 Times in 3 Posts
    Rep Power
    19
    To cut a long story short, we can fix it by going into SQL Server Management studio express and making sure the Sims_init box is checked.
    Need to stop remote connections first and re-enable once you are done.

  3. #18

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    Dropping logins would have resolve the problem when detach? Maybe this was where your differences in outcomes were?

  4. #19

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,779
    Thank Post
    714
    Thanked 1,437 Times in 1,190 Posts
    Rep Power
    359
    Quote Originally Posted by Steve_T View Post
    Dropping logins would have resolve the problem when detach? Maybe this was where your differences in outcomes were?
    if you do that, then all sims passwords will be reset wont they?! that's not ideal....more of a last last resort.

  5. #20
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,286
    Thank Post
    868
    Thanked 394 Times in 305 Posts
    Blog Entries
    60
    Rep Power
    287
    When we had this problem, I phoned the LEA who did the drop/re-attach routine and fixed it. Unfortunately Reason 0 is a nasty one. The LEA told us SIMS chucks that error message out if it can't think of any other reason code causing the problem. It means anything could have happened!

  6. #21
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    569
    Thank Post
    106
    Thanked 25 Times in 22 Posts
    Rep Power
    19
    we are having this at the momment very random user and machines. Our sims server runs from a sas san, its a esx vm 2008 32bit server with 3gb ram 2 processor, i am not sure weather its processor, disk, ram etc.. anyone care to share there ideas i am running out and slt are moaning, last thing to try is to install it to its own physical server

    mark

  7. #22

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,074
    Thank Post
    160
    Thanked 937 Times in 731 Posts
    Blog Entries
    3
    Rep Power
    275
    we are getting alot of reason 0 errors on the machines which are running windows vista, the reception machines were replaced with some HP workstations, the run windows vista and they seem to be the only machines in the school getting this problem. we are currently re-building the client images to see if that solves the problem as we think it is something to do with that rather then the server itself.

    Our setup for reference is:

    1x SIMSSERVER Front End (Virtual)
    1x SQL-SERVER Back End (Physical) - Runs SIMS2005 Instance

    James.

  8. #23
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    444
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Quote Originally Posted by Steve_T View Post
    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

    All of the above work it just depends what the scenario is.
    I agree with all of these although not necessarily the order in which to do it, I'm quite a big fan of reinstalling the client components of a workstation early on! - ie Delete the C:\Program Files\SIMS\SIMS .net folder and rerun SIMSApplicationSetup.exe / SIMSManualSetup.exe / SIMSAmparkSetup.exe...

    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
    On the SIMS going down when the internet goes down thing -

    Prior to the ??May?? upgrade the way in which .net framework implemented calls from the Client to an SQL Server changed slightly. Subsequently Capita had to make changes to the SIMS .net code as clients would automatically try to go through the proxy server - for those who use external proxy server this problem could be explained away by this change. Basically no access to proxy = no sims.

    This got sorted very quickly I hasten to add.


    Quote Originally Posted by leonard.powers View Post
    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?
    Detaching and reattaching is a reliable routine but you should really move the DB inbetween. So:

    Backup SIMS DB
    Run DBAttach and Detach Database.
    Close DBAttach and Stop SQL Server Service.
    Cut and paste DB to elsewhere.
    Start SQL Server.
    Run DBAttach and Attach Database.
    Close DBAttach
    Restart SQL Server

    Also no one else has mentioned it here but keeping on top of cleaning out old SIMS Backups helps with general performance seeing that they typically encroach on the Partition the SQL Server is installed on. I suspect there are some fairly big DB's out there.

    Also See KB87878, from Capita - mostly happens to express installations but note there is a patch if you think you may be affected.

    http://support.capitaes.co.uk/websup...87878.xmlFalse

  9. #24
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    569
    Thank Post
    106
    Thanked 25 Times in 22 Posts
    Rep Power
    19
    we got a fix from captia about reason 0, it happens when making changes in the system manager, ran the fix and no more reason 0!

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

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