Need help error

Results 1 to 7 of 7
  1. #1
    Kill all humans Bender is offline
    MemberRank
    Jul 2010 Join Date
    RomaniaLocation
    795Posts

    Need help error

    I get this error when trying to connect to sql


  2. #2
    No cri pls savoge Zaruna is offline
    MemberRank
    Apr 2007 Join Date
    Desolation.Location
    1,113Posts

    Re: Need help error

    Not much info :o, make sure you type in your instance name to connect to the database, not your IP. If you didn't name it anything its usually your comp name\sqlexpress

  3. #3
    Alpha Member Hycker is offline
    MemberRank
    Dec 2010 Join Date
    /root/gameguardLocation
    1,590Posts

    Re: Need help error


  4. #4
    Kill all humans Bender is offline
    MemberRank
    Jul 2010 Join Date
    RomaniaLocation
    795Posts

    Re: Need help error

    I have fixed the error everything goes well sith the server but i put my ip in connect.txt and when i launch game its just a picture with a chapel and an angel on top.i used as ip :127.0.0.1,localhost,WAN ip.what did i do wrong?



    PHP Code:
    serverlist
    <?xml version="1.0" encoding="UTF-8" ?>
    <Maiet>
      <LoginServer id="101" />
      <AppServer id="102" />

      <GameServer id="1">
          <SharedField id="3" channel="2" />
        <SharedField id="107" channel="2" />
        <SharedField id="109" channel="2" />
      </GameServer>
     

      <!-- CBT?
      <GameServer id="3">
        <SharedField id="3" channel="3" />
        <SharedField id="107" channel="3" />
        <SharedField id="109" channel="3" />
      </GameServer>

      <GameServer id="4">
        <SharedField id="3" channel="4" />
        <SharedField id="107" channel="4" />
        <SharedField id="109" channel="4" />
      </GameServer>  
      -->

    </Maiet>
    PHP Code:
    AppServer server.ini

    [SERVER_INFO]
    NAME "AppServer"
    SERVER_ID 102
    WORLD_ID 
    1
    ODBC 
    "SQL Server"
    SOCKET_POOL_SIZE 100

    [CONFIG]
    PORT 7502

    [MASTER_SERVER]
    IP "127.0.0.1"
    PORT 7500


    [DB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_GAMEDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [LOGDB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_LOGDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [PATH]
    SYSTEM "system"

    [LOG]
    LOG_PATH "log"
    LOG_LEVEL 
    PHP Code:
    GameServer server.ini

    [SERVER_INFO]
    NAME "GameServer2"
    SERVER_ID 1
    WORLD_ID 
    1
    ODBC 
    "SQL Server"
    SOCKET_POOL_SIZE 2000

    [CONFIG]
    PUBLIC_IP "127.0.0.1"
    PORT 7202

    [NET]
    MASTER_SERVER_IP "127.0.0.1"
    MASTER_SERVER_PORT 7500


    [DB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_GAMEDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [LOGDB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_LOGDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [LOG]
    LOG_PATH "log"
    LOG_LEVEL 
    PHP Code:
    LoginServer server.ini

    [SERVER_INFO]
    NAME        "LoginServer"
    SERVER_ID    101
    WORLD_ID    
    1
    ODBC        
    "SQL Server"
    SOCKET_POOL_SIZE 5000

    [CONFIG]
    PORT        7501

    [MASTER_SERVER]
    IP        "127.0.0.1"
    PORT        7500

    [ACCOUNTDB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_ACCOUNTDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [DB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_GAMEDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [LOGDB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_LOGDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [LOG]
    LOG_PATH "log"
    LOG_LEVEL 0

    [CONST]
    ALLOW_INSERT_NEW_ACCOUNT 
    PHP Code:
    MasterServer server.ini

    [SERVER_INFO]
    NAME "MasterServer"
    SERVER_ID 100
    WORLD_ID 
    1
    ODBC 
    "SQL Server"
    SOCKET_POOL_SIZE 100
    SERVER_MODE 
    0

    [CONFIG]
    PORT 7500


    [ACCOUNTDB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_ACCOUNTDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [DB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_GAMEDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [LOGDB]
    SERVER "Veltzanu-pc\SQLExpress"
    DATABASE "RZ_LOGDB"
    USERNAME "sa"
    PASSWORD "mypass"

    [PATH]
    SYSTEM "system"
    FIELD "field"

    [LOG]
    LOG_PATH "log"
    LOG_LEVEL 
    Last edited by Bender; 19-08-11 at 12:14 PM.

  5. #5
    Kill all humans Bender is offline
    MemberRank
    Jul 2010 Join Date
    RomaniaLocation
    795Posts

    Re: Need help error

    no one can help me?

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

    Re: Need help error

    I don't see where is the problem? If you still have that networking problem enable name pipes and tcp connection in the mssql from the configuration tools.

  7. #7
    Kill all humans Bender is offline
    MemberRank
    Jul 2010 Join Date
    RomaniaLocation
    795Posts

    Re: Need help error

    i fixed it,but now my friend cannot login ,i am using hamachi do i have to do something to allow it to connect?



Advertisement