HELP!!!!! Connection with the server hawe been disconnected error 0

Justas157 · 06/18/2012, 05:14

Hello from the start i tray to use this

files to set up my server but i dont want to use GSQL i prefer to use mine 2008 R2 express so i add data base file to my database not that GSQL. change all paswords start server all >>> greens i enter commends into login and game know im ready to login to game ok i loged in i chose server and bam error ''Connection with the server hawe been disconnected error 0'' if i use GSQL then NO Error but i dont want to use it.

And this is my log file

HTML Code:

2012-06-18 05:51:48 PS_GAME__system log start (Game01) [KR]

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/sorp1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/croco1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/croco2

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Troll1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Spink1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/GoldenPig

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Sorp3

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Sorp2

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Deinos

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Parridalis

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Alcarian

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Belizabeth

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Kirhiross

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/CrypticOne

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Haruhion

2012-06-18 05:51:48 Loaded Behavior In Factory : data/ai/Freezing

2012-06-18 05:51:49 connect mgr 916

2012-06-18 05:51:49 connect dbagent 920

2012-06-18 05:51:49 connect dbagent2 924

2012-06-18 05:51:49 connect gamelog 940

2012-06-18 05:51:49 Market End -----------------------

2012-06-18 05:51:50 Load Shaiya.SData 0

2012-06-18 05:52:00 <Console input> /nprotectoff

2012-06-18 05:52:00 <Console output> cmd NProtect off ok

2012-06-18 05:52:44 discon client: (104,  1236) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

2012-06-18 05:53:00 3 1 SERVICE_CONTROL_STOP

2012-06-18 05:53:00 Call save all waiting...

2012-06-18 05:53:00 1 1 SAgent::Disconnect: (3, 1236)

2012-06-18 05:53:00 1 1 T=000:01:00:000, RC=2,RCS=0, RB=106,RBS=1, SC=5,SCS=0, SB=117,SBS=1

2012-06-18 05:53:00 1 1 SAgent::Disconnect: (3, 1236)

2012-06-18 05:53:00 1 1 T=000:01:00:000, RC=3,RCS=0, RB=2064,RBS=29, SC=1,SCS=0, SB=37,SBS=0

2012-06-18 05:53:00 1 1 SAgent::Disconnect: (3, 1236)

2012-06-18 05:53:00 1 1 T=000:01:00:000, RC=6,RCS=0, RB=2197,RBS=31, SC=6,SCS=0, SB=206,SBS=2

2012-06-18 05:53:00 1 1 SAgent::Disconnect: (3, 1236)

2012-06-18 05:53:00 1 1 T=000:01:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=3,SCS=0, SB=126,SBS=1

2012-06-18 05:53:00 1 1 SAgent::Disconnect: (3, 1236)

2012-06-18 05:53:00 1 1 T=000:01:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2012-06-18 05:53:00 discon gamelog ((3,1236, 0,37)

2012-06-18 05:53:00 gamelog Connection Lost INFO : T=000:01:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2012-06-18 05:53:00 game log server disconnection

2012-06-18 05:53:00 discon mgr ((3,1236, 106,117)

2012-06-18 05:53:00 discon dbagent ((3,1236, 2197,206)

2012-06-18 05:53:00 discon dbagent2 ((3,1236, 2064,37)

2012-06-18 05:53:00 dbagent Connection Lost INFO : T=000:01:00:000, RC=6,RCS=0, RB=2197,RBS=31, SC=6,SCS=0, SB=206,SBS=2

2012-06-18 05:53:00 discon userlog ((3,1236, 0,126)

2012-06-18 05:53:00 db agent server disconnected...

2012-06-18 05:53:00 dbagent2 Connection Lost INFO : T=000:01:00:000, RC=3,RCS=0, RB=2064,RBS=29, SC=1,SCS=0, SB=37,SBS=0

2012-06-18 05:53:00 userlog Connection Lost INFO : T=000:01:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=3,SCS=0, SB=126,SBS=1

2012-06-18 05:53:00 userlog log server disconnection

2012-06-18 05:53:00 call disconnectAll...

2012-06-18 05:53:00 mgr Connection Lost INFO : T=000:01:00:000, RC=2,RCS=0, RB=106,RBS=1, SC=5,SCS=0, SB=117,SBS=1

2012-06-18 05:53:00 db agent2 server disconnected...

2012-06-18 05:53:00 mgr server disconnection

2012-06-18 05:53:00 server shutdown Connection INFO : T=000:01:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=1,CReq=1,CCnt=1,DCCnt=1, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=24,RBS=0,RBSC=24,SBT=31,SBS=0,SBSC=31

2012-06-18 05:53:00 Save Shaiya.SData 0

2012-06-18 05:53:00 PS_GAME__system log end (Game01)

2012-06-18 05:53:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

[Boss]FemmeFatale · 07/17/2012, 23:22

Have you tested your Linked servers?
to test that you need to go to database
look under "server objects"
then "Linked Servers"
on each of these

game
PS_DEFINEDB
PS_GAMEDB01
PS_NCASH
PS_USERDB
PS_USERDB01

right click and Test connection
if you get an error here you need to reinstall the Linked server

if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'USER_SQL_SERVER','PASSWORD_SQ L_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_NCASH')
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'USER_SQL_SERVER','PASSWOR D_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB')
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'USER_SQL_SERVER','PASSWO RD_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'USER_SQL_SERVER','PASS WORD_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_DEFINEDB')
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'USER_SQL_SERVER','PASS WORD_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_GAMEDB01')
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'USER_SQL_SERVER','PASS WORD_SQL_SERVER'

delete all

<<< game
PS_DEFINEDB
PS_GAMEDB01
PS_NCASH
PS_USERDB
PS_USERDB01

then paste the above as new query ..execute .. then restart server