[Help]Database MSSQL 2005 Connection Failed

Results 1 to 8 of 8
  1. #1
    Account Upgraded | Title Enabled! error0024 is offline
    MemberRank
    Jul 2005 Join Date
    MalaysiaLocation
    896Posts

    [Help]Database MSSQL 2005 Connection Failed

    [Tue Oct 28 2008 07:07:09.180367 3065678752]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
    [Tue Oct 28 2008 07:07:09.180461 3065678752]: [##ERROR##] DB ERROR(CODE) : 20009
    [Tue Oct 28 2008 07:07:09.181053 3065678752]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Tue Oct 28 2008 07:07:09.181102 3065678752]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Oct 28 2008 07:07:09.181290 3065678752]: [##ERROR##] DB ERROR(STM_TEXT) :
    [Tue Oct 28 2008 07:07:09.181338 3065678752]: [##ERROR##] Database Connect Fail (uid=[Hidden];pwd=[Hidden];dsn=CabalGame08;APP=DBAgent_08)
    [Tue Oct 28 2008 07:07:09.181388 3065678752]: [##ERROR##] check 'pDB' fail
    [Tue Oct 28 2008 07:07:09.181433 3065678752]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Tue Oct 28 2008 07:07:09.181478 3065678752]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(xx.xxx.xxx.xxx[Hidden])

    Ive tried this thread
    http://forum.ragezone.com/f459/newbi...-error-487597/
    And i tried those setup made by chumpywumpy but then
    when i tried to run the server it doesn't let me and show those problem up there Database Connect Fail ive made a database GAMESERVER linked server there too
    (SQL SERVER EXPRESS 2005)
    And also ive made userId for the access and made the Rights for it at account,and etc properties and then ive set rights for it,but then when i went to logins there and set the cabal user's user mapping it doesn't let me set as db owner it wrote " User,Group,or Role "Username" already exists in the current database .(Microsoft Sql Server,Error :15023)
    Meanwhile that ive tried installing the UnixODBC but it doesn't work says nothing to do or nothing to install is there a way to fix that?im using centOS 4.5

    And also when i tried register an account it wrote
    Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: (local)\SQLEXPRESS in C:\xampp\htdocs\index.php on line 6 Tried with correct password and stuff it doesn't let me connect
    anyone can help? my servers been down for 3 days -.- using new files...

    yum install unixODBC*
    Setting up Install Process
    Setting up repositories
    Reading repository metadata in from local files
    Parsing package install arguments
    Examining unixODBC-2.2.11-1.RHEL4.1.i386.rpm: unixODBC - 2.2.11-1.RHEL4.1.i386
    unixODBC-2.2.11-1.RHEL4.1.i386.rpm: does not update installed package.
    Examining unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm: unixODBC-devel - 2.2.11-1.RHEL4.1.i386
    unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm: does not update installed package.
    Examining unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm: unixODBC-kde - 2.2.11-1.RHEL4.1.i386
    unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm: does not update installed package.
    Nothing to do
    [root@cabal /]# cd /root
    [root@cabal /]# yum install unixODBC*
    Setting up Install Process
    Setting up repositories
    Reading repository metadata in from local files
    Parsing package install arguments
    Nothing to do
    Last edited by error0024; 28-10-08 at 04:57 PM.


  2. #2
    The Cat in the Hat cypher is offline
    MemberRank
    Oct 2005 Join Date
    IrelandLocation
    5,073Posts

    Re: [Help]Database MSSQL 2005 Connection Failed

    I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

  3. #3
    Apprentice animetau is offline
    MemberRank
    Mar 2007 Join Date
    7Posts

    Re: [Help]Database MSSQL 2005 Connection Failed

    yes try yum install libssl
    error u have backup of DB?

    maybe u nead to reinstal all DB or even reinstal microsoft sql do all form begining with guide... server files leave alone.

  4. #4
    Account Upgraded | Title Enabled! error0024 is offline
    MemberRank
    Jul 2005 Join Date
    MalaysiaLocation
    896Posts

    Re: [Help]Database MSSQL 2005 Connection Failed

    animetau you are quite funny lolz
    that's not the database data problem
    its somekind of microsoft sql problem
    Im figuring out

  5. #5
    The Cat in the Hat cypher is offline
    MemberRank
    Oct 2005 Join Date
    IrelandLocation
    5,073Posts

    Re: [Help]Database MSSQL 2005 Connection Failed

    I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

  6. #6
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: [Help]Database MSSQL 2005 Connection Failed

    I think your sql server is installed as a named instance and that isn't going to work well. I would suggest reinstalling as a default instance as shown in my mssql 2005 guide as setup is much much simpler.

  7. #7
    The Cat in the Hat cypher is offline
    MemberRank
    Oct 2005 Join Date
    IrelandLocation
    5,073Posts

    Re: [Help]Database MSSQL 2005 Connection Failed

    I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

  8. #8
    Account Upgraded | Title Enabled! error0024 is offline
    MemberRank
    Jul 2005 Join Date
    MalaysiaLocation
    896Posts

    Re: [Help]Database MSSQL 2005 Connection Failed

    Oh ic guys thanks for the help
    it was the default instance problem ^^



Advertisement