DB Connection failed! need help.

01/05/2012 15:08 ocean133#1
DB Connection failed! any1 can help me?

[Only registered and activated users can see links. Click Here To Register...]
01/05/2012 15:11 M4n1ak#2
Check server.cfg and Ini's in cert folder..
01/05/2012 15:15 ocean133#3
all is done but again get error :S
01/05/2012 15:58 M4n1ak#4
You opened all IIS features ?
01/05/2012 16:38 wolff66#5
your ini files are wrong 100%
copy ur SrShard.ini here
01/06/2012 20:12 ocean133#6
Now have new error :S
Shardmanager closed after 15sec..all is work but why its closed any1 help me pls?
01/09/2012 13:47 justknow#7
I have the same error DB Connection Failed! 2 file SR_ShardManager và SR_GameServer, plz help me. Plz check my config and help me fix. I fixed everything but it couldn't run. I'll try change SRO_VT_SHARD to SRO_VT_SHARD_INIT but still error. I've just enable only 1 network card or Loopback but the same error. Thank you so much. Nice day.

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

srGlobalService
Code:
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=CUIBAP-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=test;PWD=test;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

srNodeType
Code:
[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=192.168.1.202
nip=192.168.1.202
machine_manager_node_id=699

srShard
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Than Dia
query=DRIVER={SQL Server};SERVER=CUIBAP-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=test;PWD=test;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};CUIBAP-PC\SQLEXPRESS;DSN=Log_DB;UID=test;PWD=test;DATABASE=Log_DB
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

Server
Code:
Common {
    debug_option_debugger_present{
            DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
            DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
            DEBUG_OPTION_ASSERT_CANCEL_EXIT
    }
    debug_option_stand_alone{            
            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
    }
    netengine_debug_option_debugger_present{
            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
    }
    netengine_debug_option_stand_alone{
            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP 
    }


}


////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
        Certification "192.168.1.202", 32000 
        LoginFailureTolerance        3
        IBUVFailureTolerance        3
        LoginFailureBlockTimeMin    0
        IBUVFailureBlockTimeMin        0
        AutomatedPunisher            "AutomatedPunisher"
        LoginPunishmentGuide        "Blocked for 10 minutes due to incorrect password entered 3 times"
        LoginPunishmentDescription    "Blocked for 10 minutes due to incorrect password entered 3 times"
        IBUVPunishmentGuide            "Blocked for 10 minutes due to incorrect code entered 3 times"
        IBUVPunishmentDescription    "Blocked for 10 minutes due to incorrect code entered 3 times"
}


GatewayServer {
        LastFullVersion_SR_Client     130
        Certification "192.168.1.202", 15880
        IBUVQueueReserveCount        20000
        IBUVQueuePrepareRatio        0.10
        IBUVFailureIPTolerance        0
        IBUVStringSize                1
        IBUVCharacterSet            "ABCDEF1234567890"
}


DownloadServer {
        Certification "192.168.1.202", 15880
}
FarmManager {
        Certification "192.168.1.202", 15880
}


AgentServer {
        Certification "192.168.1.202", 15882 //no global manager running lol
            //traffic_filter_activity     "service_off"
            //MaxUser 5000
            //SockTCPCount 15000
        MaxConnectionsPerServer         "5000"
        MaxConnectionsPer1_OServer         "5000"
}


MachineManager {
        Certification "192.168.1.202", 15880
        CERTIFICATION_IP_BIND "192.168.1.202"
}


SR_GameServer {
        Certification "192.168.1.202", 15882
        SockTCPCount                                     "5000"
        ExpRatio                                         "35000"
        ExpRatioParty                                     "35000" 
        DropItemRatio                                     "5000"
        DropGoldAmountCoef                                 "15000"
        HwanGainFactor                                     "250"
        ShowFormulaDetail                                 "1"
    
            //WINTER_EVENT_2009                            EVENT_ON
            //EUBUSINESS_EVENT                            EVENT_ON
            //GOLDEN_PIG_FEBRUARY_EVENT                    EVENT_ON
            //THANKS_GIVING_EVENT                        EVENT_ON
            //LIBERATION_EVENT                            EVENT_ON
        LOCALE                                             LOCALE_VIETNAM
       
            //#ifdef OPEN_MARKET_SYSTEM
                SET_FEE_RATE                            "0,5,5,5"
                SELL_FEE_RATE                           "0,10,10,10"
            //#endif OPEN_MARKET_SYSTEM
            //RE FTW


        DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL     "OFF"
        ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED         "OFF"




}


SR_ShardManager {
        Certification "192.168.1.202", 15882
        BILLING_SERVER_URL                 "http://192.168.1.202:8080/"
        CREST_FTP_URL                     "ftp://test:test@192.168.1.202/"
        ChristmasEvent2007                 1
        SERVER_EVENT_SYSTEM             ON
        LOCALE                             LOCALE_VIETNAM
        FlagEvent                         1
            //HourForMeterRateLevelFirst    24
            //HourForMeterRateLevelSecond    0


        BattleArenaRandom                 1
        BattleArenaParty                 1
        BattleArenaGuild                 1
        BattleArenaJob                     1
        ArenaMatchOccupy                 1
        ArenaMatchFlag                     1
        ArenaMatchPoint                 1
}

ServiceManager
Code:
/*
*/


SMC {    
DivisionManager "192.168.1.202",15880
}


ModulePatch
{
    SrcPath    ".\Patch_Internal"
    DestPath ".\Patch_Internal_Comp"
}

smc_updater
Code:
GatewayServer {
    "192.168.1.202"
}

DBConnect
Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=CUIBAP-PC\SQLEXPRESS;Data Source=192.168.1.202;Initial Catalog=SRO_VT_ACCOUNT;user ID=test;password=test;"
DBConnA.Open strConnectA


%>
01/09/2012 17:04 wolff66#8
in srshard try to change SRO_VT_SHARD to SRO_VT_SHARD_INIT
01/09/2012 18:17 justknow#9
U mean change everything or *.ini?
Only change *.ini, not working.
01/09/2012 18:35 vorosmihaly#10
alright,I don't want to be rude,but if you can't run them after all those tutorials out here,you prolly shouldn't be trying to get them running..
01/09/2012 21:21 wolff66#11
Quote:
Originally Posted by justknow View Post
U mean change everything or *.ini?
Only change *.ini, not working.
PM ME with ur msn , i will take a look via Teamviewer
01/10/2012 03:47 justknow#12
Thx wolff66. Let me try re-setup my win and try again. If still error i will contact u. Thx Thx so much. I use win 7 64 bit.
08/15/2012 15:19 tes003#13
ANd me Plz Help me have DB SR_Shard and SR_GameServer DB Connection Failed