#Error..... Check this out.

[1337NubzoR]

im getting this error over and over again after the SR_GameServer runs for a while :
[SR_GameServer] SQL Error State:08S01, Native Error Code: 0, ODBC Error: [Microsoft][ODBC SQL Server Driver]Communication link failure then the game crashes . anyone can help me? please :S


any solution?

[elmt]

here is the log

2012-03-25 02:18:34 [SR_GameServer] Query Error!!! Query Result : -1, Query : SELECT CharID,Deleted,RefObjID,CharName16,Scale,GuildID,C urLevel,MaxLevel,ExpOffset,SExpOffset,Strength,Int ellect,RemainGold,RemainSkillPoint,RemainStatPoint ,RemainHwanCount,GatheredExpPoint,LatestRegion,Pos X,PosY,PosZ,WorldID,HP,MP,NickName16,AppointedTele port,AutoInvestExp,InventorySize,DailyPK,TotalPK,P KPenaltyPoint,LastLogout,TelRegion,TelPosX,TelPosY ,TelPosZ,TelWorldID,DiedRegion,DiedPosX,DiedPosY,D iedPosZ,DiedWorldID,HwanLevel FROM _CHAR WHERE CharID=57324
2012-03-25 02:18:34 [SR_GameServer] SQL Error State:08S01, Native Error Code: 0, ODBC Error: [Microsoft][ODBC SQL Server Driver]Communication link failure
2012-03-25 02:18:34 [SR_GameServer] SELECT CharID,Deleted,RefObjID,CharName16,Scale,GuildID,C urLevel,MaxLevel,ExpOffset,SExpOffset,Strength,Int ellect,RemainGold,RemainSkillPoint,RemainStatPoint ,RemainHwanCount,GatheredExpPoint,LatestRegion,Pos X,PosY,PosZ,WorldID,HP,MP,NickName16,AppointedTele port,AutoInvestExp,InventorySize,DailyPK,TotalPK,P KPenaltyPoint,LastLogout,TelRegion,TelPosX,TelPosY ,TelPosZ,TelWorldID,DiedRegion,DiedPosX,DiedPosY,D iedPosZ,DiedWorldID,HwanLevel FROM _CHAR WHERE CharID=57324
2012-03-25 02:18:34 [SR_GameServer] Database Connection was lost!!! Server should be shutted down !!!
2012-03-25 02:18:34 [SR_GameServer] Query Error!!! Query Result : -1, Query : SELECT CharID,Deleted,RefObjID,CharName16,Scale,GuildID,C urLevel,MaxLevel,ExpOffset,SExpOffset,Strength,Int ellect,RemainGold,RemainSkillPoint,RemainStatPoint ,RemainHwanCount,GatheredExpPoint,LatestRegion,Pos X,PosY,PosZ,WorldID,HP,MP,NickName16,AppointedTele port,AutoInvestExp,InventorySize,DailyPK,TotalPK,P KPenaltyPoint,LastLogout,TelRegion,TelPosX,TelPosY ,TelPosZ,TelWorldID,DiedRegion,DiedPosX,DiedPosY,D iedPosZ,DiedWorldID,HwanLevel FROM _CHAR WHERE CharID=33529
2012-03-25 02:18:34 [SR_GameServer] SQL Error State:08S01, Native Error Code: 0, ODBC Error: [Microsoft][ODBC SQL Server Driver]Communication link failure
2012-03-25 02:18:34 [SR_GameServer] SELECT CharID,Deleted,RefObjID,CharName16,Scale,GuildID,C urLevel,MaxLevel,ExpOffset,SExpOffset,Strength,Int ellect,RemainGold,RemainSkillPoint,RemainStatPoint ,RemainHwanCount,GatheredExpPoint,LatestRegion,Pos X,PosY,PosZ,WorldID,HP,MP,NickName16,AppointedTele port,AutoInvestExp,InventorySize,DailyPK,TotalPK,P KPenaltyPoint,LastLogout,TelRegion,TelPosX,TelPosY ,TelPosZ,TelWorldID,DiedRegion,DiedPosX,DiedPosY,D iedPosZ,DiedWorldID,HwanLevel FROM _CHAR WHERE CharID=33529
2012-03-25 02:18:34 [SR_GameServer] Database Connection was lost!!! Server should be shutted down !!!
2012-03-25 02:18:34 [SR_GameServer] Query Error!!! Query Result : -1, Query : SELECT CharID,Deleted,RefObjID,CharName16,Scale,GuildID,C urLevel,MaxLevel,ExpOffset,SExpOffset,Strength,Int ellect,RemainGold,RemainSkillPoint,RemainStatPoint ,RemainHwanCount,GatheredExpPoint,LatestRegion,Pos X,PosY,PosZ,WorldID,HP,MP,NickName16,AppointedTele port,AutoInvestExp,InventorySize,DailyPK,TotalPK,P KPenaltyPoint,LastLogout,TelRegion,TelPosX,TelPosY ,TelPosZ,TelWorldID,DiedRegion,DiedPosX,DiedPosY,D iedPosZ,DiedWorldID,HwanLevel FROM _CHAR WHERE CharID=41679
2012-03-25 02:18:34 [SR_GameServer] SQL Error State:08S01, Native Error Code: 0, ODBC Error: [Microsoft][ODBC SQL Server Driver]Communication link failure
2012-03-25 02:18:34 [SR_GameServer] SELECT CharID,Deleted,RefObjID,CharName16,Scale,GuildID,C urLevel,MaxLevel,ExpOffset,SExpOffset,Strength,Int ellect,RemainGold,RemainSkillPoint,RemainStatPoint ,RemainHwanCount,GatheredExpPoint,LatestRegion,Pos X,PosY,PosZ,WorldID,HP,MP,NickName16,AppointedTele port,AutoInvestExp,InventorySize,DailyPK,TotalPK,P KPenaltyPoint,LastLogout,TelRegion,TelPosX,TelPosY ,TelPosZ,TelWorldID,DiedRegion,DiedPosX,DiedPosY,D iedPosZ,DiedWorldID,HwanLevel FROM _CHAR WHERE CharID=41679
2012-03-25 02:18:34 [SR_GameServer] Database Connection was lost!!! Server should be shutted down !!!

[1337NubzoR]

bump

[CrystalCoder]

 Spoiler

Database Connection was lost!!! Server should be shutted down !!!

the Sql Server crash from critical error this sometime happan from worng installion becuse of this he close the connection between sql to the files
do as i say you
just restart sql his services shutdown
trust me i got this issue long time ago