db connection lost after awhile

Results 1 to 6 of 6
  1. #1
    Valued Member Asaki is offline
    MemberRank
    Nov 2009 Join Date
    133Posts

    db connection lost after awhile

    not sure whether its a server problem or its being crashed.
    My mssql is often being turned off .
    not sure what happen .

    i am using a w2k8 64 bit
    with mssql 64 bit

    maybe be server being inactive for something .
    after awhile db connection will be lost.
    And the matchserver files will leave an error . giving me an option
    to give the mssql username and pw . then have to click ok . any ideas whats going on ?


  2. #2
    Developer Eronisch is offline
    MemberRank
    Jul 2009 Join Date
    The NetherlandsLocation
    1,328Posts

    Re: db connection lost after awhile

    i have the same problem, someon knows how to fix it?

  3. #3
    Valued Member Asaki is offline
    MemberRank
    Nov 2009 Join Date
    133Posts

    Re: db connection lost after awhile

    i have fixed it . if uare on 64 bit w2k8 . download netframework 3.0 and above and it will fix it.

    and also run this query :
    ALTER DATABASE "Your GunzDB name" SET AUTO_CLOSE OFF
    Last edited by Asaki; 22-12-09 at 09:12 AM.

  4. #4
    人◕ ‿‿ ◕人 Forean is offline
    MemberRank
    Jul 2008 Join Date
    1,183Posts

    Re: db connection lost after awhile

    Quote Originally Posted by Asaki View Post
    i have fixed it . if uare on 64 bit w2k8 . download netframework 3.0 and above and it will fix it.

    and also run this query :
    ALTER DATABASE "Your GunzDB name" SET AUTO_CLOSE OFF



    Thanks dude, Helped me a bit.

  5. #5
    Developer Eronisch is offline
    MemberRank
    Jul 2009 Join Date
    The NetherlandsLocation
    1,328Posts

    Re: db connection lost after awhile

    i'll try it tomorrow, but thanks for the reply!

  6. #6
    Account Upgraded | Title Enabled! killerzx is offline
    MemberRank
    Dec 2008 Join Date
    638Posts

    Re: db connection lost after awhile

    everyone's server crashed? D:

    Edit : hmm.. looks like microsoft just released an update. That should fix it :P
    Last edited by killerzx; 22-12-09 at 06:53 PM.



Advertisement