Session Failed !

[iamtemo]

Hello all !
I'm playing with some Shaiya Episode and now i wanna try newest version but facing this error Session Wont start :
Can you help me with this error ...?

More details :
Logs Here

 Spoiler

//PS_DBAGENT__charsave log start (DBAgent01)

--<Begin Market> 2018-12-17 20:37:41

--<Market End>2018-12-17 20:37:41





//PS_DBAGENT__charsave log start (DBAgent01)

 Spoiler

2018-12-17 20:37:24 PS_DBAGENT__system log start (DBAgent01)

2018-12-17 20:37:41 DB gamedata connect error

2018-12-17 20:37:41 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-12-17 20:37:41 DBKillCountSave db alloc failed

2018-12-17 20:37:41 SAVE kill count ERROR

2018-12-17 20:37:41 CKeepObeliskMgr:BSave db alloc failed

2018-12-17 20:37:41 SAVE g_KeepObeliskMgr ERROR

2018-12-17 20:37:41 GuildMgrSave:BSave db alloc failed

2018-12-17 20:37:41 SAVE g_GuildMgrSave ERROR

2018-12-17 20:37:41 CMarketMgr:BSaveMarket db alloc failed

2018-12-17 20:37:41 CMarketMgr:BSave ERROR

2018-12-17 20:37:41 PS_DBAGENT__system log end (DBAgent01)


2018-12-17 20:37:41 3 1 SService::ServiceCtrlDispatcher(): service shutdown

 Spoiler

2018-12-17 20:37:27 PS_GAME__system log start (Game01) [GERMANY]





================================================== ==============

2018-12-17 20:37:43 Exception !!!, code=0xE06D7363, address=0x7748AB32

2018-12-17 20:37:43 DB gamedef connect error

2018-12-17 20:37:43 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-12-17 20:37:43 Call save all waiting...

2018-12-17 20:37:43 Call save all failed dbagent disconnected(user count = 0)...

2018-12-17 20:37:43 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0

2018-12-17 20:37:43 PS_GAME__system log end (Game01)

2018-12-17 20:37:43 3 1 SService::ServiceCtrlDispatcher(): service shutdown

 Spoiler

2018-12-17 20:37:22 PS_GAMELOG__system log start (GameLog01)

2018-12-17 20:37:39 DB gamelog connect error

2018-12-17 20:37:39 init db error

2018-12-17 20:37:39 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-12-17 20:37:39 PS_GAMELOG__system log end (GameLog01)

2018-12-17 20:37:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown

 Spoiler

2018-12-17 20:37:29 PS_LOGIN__system log start (Login01)

2018-12-17 20:37:46 DB userdata connect error, id=Shaiya, pass=Shaiya123

2018-12-17 20:37:46 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-12-17 20:37:46 PS_LOGIN__system log end (Login01)

2018-12-17 20:37:46 3 1 SService::ServiceCtrlDispatcher(): service shutdown

 Spoiler

2018-12-17 20:37:19 PS_SESSION__system log start (Session)

2018-12-17 20:37:20 userlog connect failed

2018-12-17 20:37:20 initserver() failed

2018-12-17 20:37:20 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-12-17 20:37:20 PS_SESSION__system log end (Session)

2018-12-17 20:37:20 3 1 SService::ServiceCtrlDispatcher(): service shutdown

 Spoiler

2018-12-17 20:37:17 PS_USERLOG__system log start (UserLog)

2018-12-17 20:37:33 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2018-12-17 20:37:33 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-12-17 20:37:33 PS_USERLOG__system log end (UserLog)

2018-12-17 20:37:33 3 1 SService::ServiceCtrlDispatcher(): service shutdown

I know this comes from SQL Server doesn't connect to game but look this:

 Spoiler

How to solve this ?

Appreciate any answer !

Thanks in advice all !

[pardilias]

hello
error
PS_UserData, User=Shaiya, Pass=Shaiya123

LinkedServers ?

[[King]Yubel]

As you see there is SQL Problem ...
Make sure to free the port 1433 (default port) ,
also make sure SQL Manager is configured good

The server is not linked so...

Imo You need to set port in "SQL Server Configuration Manager " TCP Port 1433

hope i help you !
Peace

[[MXD]Takeshi]

Originally Posted by iamtemo

bla bla bla

userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

here is the error....

Originally Posted by [King]Yubel

bla bla

not need the port specific.... not need open port in firewall, just open

SQL Server Configuration Manager --> SQL Server 20XX Network Configuration --> Protocols for MSSQLSERVER --> ENABLE all service --> TCP/IP Configuration

click and enable ALL.

start to 4:27

P.S. SQL Native Client need enable VIA in Client Protocols

[iamtemo]

Originally Posted by [King]Yubel

As you see there is SQL Problem ...
Make sure to free the port 1433 (default port) ,
also make sure SQL Manager is configured good

The server is not linked so...

Imo You need to set port in "SQL Server Configuration Manager " TCP Port 1433

hope i help you !
Peace

Thanks solved ! Life saver