{Guide/Release} SQL Server configuration For vsro files & Patches options

[buriko_0007]

@Dr.Abdelfattah

Fixed Login Problem.

I have Only 1 problem with ITEM BUG ! How to FIX ?

And 2 Game Server Dont load all region Why ?

[MaShanDra]

Originally Posted by badji

the problem seems fixed by compatibility mode windows 2000

and now its connecting to DB

but now its giving me

Association Reputation Check is Failed

got the same problem! you fixed it?

@Dr Abdel =) need some help im using patch 3.1



i use 2 root server all works but so you can see 2nd gameserver have error and wont work! cert problem or so

[buriko_0007]

@Dr.Abdelfattah

Fixed Login Problem.

I have Only 1 problem with ITEM BUG ! How to FIX ?

And 2 Game Server Dont load all region Why ?

@MaShanDra

Use Patch 3.0

[MaShanDra]

you activated the regions set the last regions to 2 in DB?

regions 1 gamerserver set to 1 regions 2 gameserver det to 2

[octage]

hey... I get fatal DB Connection failed! at SR_GameServer and at GatewayServer on my Second machine.... and I know it has smth to do with SQL... I had a problem there too I did all those steps BUT I have a problem at step 4: when I select Local remote connection , Using both TCP, etc..... and when I press Apply I get an error:

"Change to Connection Settings will not take effect untill you restart the Database Engine service"

and I've restarted it many times.... the rest is same like you, I think ....

So... I would apreciate any solution to my problem .... Have a great day, and btw nice job, keep it going Dr.Abdelfattah .

[buriko_0007]

Originally Posted by MaShanDra

you activated the regions set the last regions to 2 in DB?

regions 1 gamerserver set to 1 regions 2 gameserver det to 2

No xD 1 and 0 - U shard db backup and upload ?

And I have ITEM BUG How to fix ?

[MaShanDra]

hey... I get fatal DB Connection failed! at SR_GameServer and at GatewayServer on my Second machine.... and I know it has smth to do with SQL... I had a problem there too I did all those steps BUT I have a problem at step 4: when I select Local remote connection , Using both TCP, etc..... and when I press Apply I get an error:

"Change to Connection Settings will not take effect untill you restart the Database Engine service"

and I've restarted it many times.... the rest is same like you, I think ....

So... I would apreciate any solution to my problem .... Have a great day, and btw nice job, keep it going Dr.Abdelfattah

if you configured your SQL Server with Abdels TUT
you need connect with yourip,1433 in cert with second Machine not with ./SQLEXPRESS

then it will work fine =)

Originally Posted by buriko_0007

No xD 1 and 0 - U shard db backup and upload ?

And I have ITEM BUG How to fix ?

go to the table in you can enable regions!
the regions who runs on 1 Gameserver is set to 1 right?

the Item Bug will be fixed if you run 2 Gameservers with all regions xD
and the regions with 0 set it to 2 and all regions will be loaded

@buriko_0007 patch 3 same error... =(

[menagamil95]

help plz why i get

[skeyline]

FarmManager warningError: "unhandled msg received CFarmManagerMainProcess : IP:xxxxx NoDir:0x0209 (0xB001) (MsgType:2), 7 - 7"

Can login but if i choose a char then i get this error and cant login

[bibi_fr]

We can't put this server online don't try it :/

[MaShanDra]

Originally Posted by menagamil95

help plz why i get

you get this error because your system hardware is too low

how much ram you have???

[mertcoskun]

Originally Posted by MaShanDra

if you configured your SQL Server with Abdels TUT
you need connect with yourip,1433 in cert with second Machine not with ./SQLEXPRESS

then it will work fine =)



go to the table in you can enable regions!
the regions who runs on 1 Gameserver is set to 1 right?

the Item Bug will be fixed if you run 2 Gameservers with all regions xD
and the regions with 0 set it to 2 and all regions will be loaded

@buriko_0007 patch 3 same error... =(

do you explain 1433? still second pc can not connect db:/

[MaShanDra]

Originally Posted by buriko_0007

@Dr.Abdelfattah

Fixed Login Problem.

I have Only 1 problem with ITEM BUG ! How to FIX ?

And 2 Game Server Dont load all region Why ?

@MaShanDra

Use Patch 3.0

how do you fixed login problem?

you try to login with GM Acc?? or normal Acc

[Dr.Abdelfattah]

i will complete support all tomorrow cuz i'm verry sleeply now & w8 update LastThief ^^

in

[entry3]
node_id=699
operation_type=22
global_operation_id=0
associated_shard_id=0
node_type=335
service_type=4
certification_node_id=697
port=15778
node_icon=0
u1=96
u2=23
u3=24
u4=1
u5=48
u6=148
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=0
u16=0
u17=0
u18=0
u19=0
u20=0

change node_type=335 to node_type=336
in patch 5&5.1

[buriko_0007]

@Dr.Abdelfattah

I have Only 1 problem with ITEM BUG ! How to FIX ?

Please Help Me Come Tw And Set DB Write/Read Permission