Fix Pause services.

But my configs at Configuration Managers are right.... so idk why this doesn't connect

You are not config your sql server

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

Quote:

Originally Posted by SnickQ You are not config your sql server [Only registered and activated users can see links. Click Here To Register...]

Neph Tried to fix that problem with TeamViewer, but we still cant. i've already re-installed Windows and SQL... After dat, i've followed his guide (for 3th time) and now i can connect to 127.0.0.1. But servers still pause after few time. My logs now are:

ps_DBagent_system.log

2015-09-14 07:31:46 PS_DBAGENT__system log start (DBAgent01)

2015-09-14 07:32:03 DB gamedata connect error

2015-09-14 07:32:03 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2015-09-14 07:32:03 DBKillCountSave db alloc failed

2015-09-14 07:32:03 SAVE kill count ERROR

2015-09-14 07:32:03 CKeepObeliskMgr::DBSave db alloc failed

2015-09-14 07:32:03 SAVE g_KeepObeliskMgr ERROR

2015-09-14 07:32:03 GuildMgrSave::DBSave db alloc failed

2015-09-14 07:32:03 SAVE g_GuildMgrSave ERROR

2015-09-14 07:32:03 PS_DBAGENT__system log end (DBAgent01)


2015-09-14 07:32:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown

ps_game_system.log

2015-09-14 07:31:46 PS_GAME__system log start (Game01) [KR]

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/sorp1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/croco1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/croco2

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Troll1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Spink1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/GoldenPig

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Sorp3

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/SorpNamed1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/SorpNamed2

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Sorp2

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/CrocoNamed1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/CrocoNamed2

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/CrocoNamed3

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/OrcNamed1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/OrcNamed2

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/OrcNamed3

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/TrollNamed1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Deinos

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Parridalis

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Alcarian

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/ZinAlcaria

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Belizabeth

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Kirhiross

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/CrypticOne

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Haruhion

2015-09-14 07:31:46 Loaded Behavior In Factory : data/ai/Freezing

2015-09-14 07:32:03 DB gamedef connect error

2015-09-14 07:32:03 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2015-09-14 07:32:03 Call save all waiting...

2015-09-14 07:32:03 Call save all failed dbagent disconnected(user count = 0)...

2015-09-14 07:32:03 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

2015-09-14 07:32:03 Save Shaiya.SData 0

2015-09-14 07:32:03 PS_GAME__system log end (Game01)

2015-09-14 07:32:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown

ps_gamelog_system.log

2015-09-14 07:31:44 PS_GAMELOG__system log start (GameLog01)

2015-09-14 07:32:01 DB gamelog connect error

2015-09-14 07:32:01 init db error

2015-09-14 07:32:01 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2015-09-14 07:32:01 PS_GAMELOG__system log end (GameLog01)

2015-09-14 07:32:01 3 1 SService::ServiceCtrlDispatcher(): service shutdown

ps_login_system.log

2015-09-14 07:31:48 PS_LOGIN__system log start (Login01)

2015-09-14 07:31:58 <Console input> /vchkoff

2015-09-14 07:31:58 <Console output> cmd version chk off ok

2015-09-14 07:32:05 DB userdata connect error, id=Shaiya, pass=Shaiya123

2015-09-14 07:32:05 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2015-09-14 07:32:05 PS_LOGIN__system log end (Login01)

2015-09-14 07:32:05 3 1 SService::ServiceCtrlDispatcher(): service shutdown

ps_session_system.log

2015-09-14 07:31:44 PS_SESSION__system log start (Session)

2015-09-14 07:31:45 userlog connect failed

2015-09-14 07:31:45 initserver() failed

2015-09-14 07:31:45 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2015-09-14 07:31:45 PS_SESSION__system log end (Session)

2015-09-14 07:31:45 3 1 SService::ServiceCtrlDispatcher(): service shutdown

ps_userlog_system.log

2015-09-14 07:31:44 PS_USERLOG__system log start (UserLog)

2015-09-14 07:32:00 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2015-09-14 07:32:00 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2015-09-14 07:32:00 PS_USERLOG__system log end (UserLog)

2015-09-14 07:32:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

you havent give privliges for this user on the database you might wanna check the rolls

Quote:

Originally Posted by Big_ you havent give privliges for this user on the database you might wanna check the rolls

U mean that about "check" every databases privileges at "server functions" and "usser mapping" in each db, i've already did it...

no the server rolls above the user mapping

CHange user sa to Shaiya in Security-->Login

Quote:

Originally Posted by SnickQ CHange user sa to Shaiya in Security-->Login

I've already did both things... Still cant... i'm Since 2014 trying to build sv but still cant u.u BUT this is the 1st time i'm answering on forums... If i cant this time, then i'll stop try :(

You are add port 1433 in manager?

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

He did everything, I checked it via TeamViewer, I guess its because he runs 2 Server Files in 2 different folders and/or maybe some problems with sql 2005. However, the files are okay.

then check if the database is acceptiong conection try see if a resgister script can make an account if it carnt then its the database connection or connectivity

Everything done, as mentioned the problem lies in running 2x Server-Files instead of running 1 which causes problems. However, I'll fix that laters for him.