Green arrows

shaiyaforfriends · 06/14/2012, 09:20

Hey guys i installed an ep 4.5 server but i had a server before on this windows and it started normally but now it stops in 5 seconds all of them the SQL is running normally and in the express studio there are databases i checked the log and this is what it said:
PS_DBAGENT

Quote:

2012-06-14 09:25:00 PS_DBAGENT__system log start (DBAgent01)

2012-06-14 09:25:00 DB gamedata connect error

2012-06-14 09:25:00 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-06-14 09:25:00 DBKillCountSave db alloc failed

2012-06-14 09:25:00 SAVE kill count ERROR

2012-06-14 09:25:00 CKeepObeliskMgr:BSave db alloc failed

2012-06-14 09:25:00 SAVE g_KeepObeliskMgr ERROR

2012-06-14 09:25:00 GuildMgrSave:BSave db alloc failed

2012-06-14 09:25:00 SAVE g_GuildMgrSave ERROR

2012-06-14 09:25:00 PS_DBAGENT__system log end (DBAgent01)

2012-06-14 09:25:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAME

Quote:

2012-06-14 09:24:58 PS_GAME__system log start (Game01) [KR]

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/sorp1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/croco1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/croco2

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Troll1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Spink1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/GoldenPig

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Sorp3

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Sorp2

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Deinos

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Parridalis

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Alcarian

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Belizabeth

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Kirhiross

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/CrypticOne

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Haruhion

2012-06-14 09:24:58 Loaded Behavior In Factory : data/ai/Freezing

2012-06-14 09:24:58 DB gamedef connect error

2012-06-14 09:24:58 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-06-14 09:24:58 Call save all waiting...

2012-06-14 09:24:58 Call save all failed dbagent disconnected(user count = 0)...

2012-06-14 09:24:58 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

2012-06-14 09:24:58 Save Shaiya.SData 0

2012-06-14 09:24:58 PS_GAME__system log end (Game01)

2012-06-14 09:24:58 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAMELOG

Quote:

2012-06-14 09:25:00 PS_GAMELOG__system log start (GameLog01)

2012-06-14 09:25:00 DB gamelog connect error

2012-06-14 09:25:00 init db error

2012-06-14 09:25:00 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-06-14 09:25:00 PS_GAMELOG__system log end (GameLog01)

2012-06-14 09:25:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_LOGIN

Quote:

2012-06-14 09:24:54 PS_LOGIN__system log start (Login01)

2012-06-14 09:24:54 DB userdata connect error, id=Shaiya, pass=Shaiya123

2012-06-14 09:24:54 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-06-14 09:24:54 PS_LOGIN__system log end (Login01)

2012-06-14 09:24:54 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_SESSION

Quote:

2012-06-14 09:24:51 PS_SESSION__system log start (Session)

2012-06-14 09:24:52 userlog connect failed

2012-06-14 09:24:52 initserver() failed

2012-06-14 09:24:52 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-06-14 09:24:52 PS_SESSION__system log end (Session)

2012-06-14 09:24:52 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_USERLOG

Quote:

2012-06-14 09:24:51 PS_USERLOG__system log start (UserLog)

2012-06-14 09:24:51 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2012-06-14 09:24:51 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-06-14 09:24:51 PS_USERLOG__system log end (UserLog)

2012-06-14 09:24:51 3 1 SService::ServiceCtrlDispatcher(): service shutdown

~~cypherxxl~~ · 06/14/2012, 09:46

Did u create a user in ur mssql database?

This user must have the same password as ur passwords in ur .ini data files.

In ur case u have to create a user.

User: Shaiya <- give them admin rights.
Pass: Shaiya123

STIV123 · 06/14/2012, 10:45

Download This :

Click on that, it will run a query. Change the User and Pass there.

( Just to add, password can fail in changing, so if it do, try changing just the user thing )

but also after u do this u need to change INI Files and Server Patch Config.

Good Luck

~~cypherxxl~~ · 06/14/2012, 11:51

This are the Linked servers Only!
He MUST have a User (Login) named Shaiya on his Login for MSSQL.

~~orion72956~~ · 06/17/2012, 09:26

The standard New Installation.SQL inserts a user account into MSSQL as well as sets up the Linked Servers. As posted above, make sure that you use the enc_password.exe in PSM_Server to make your password to your database and paste it in all of your config files. There's one in PSM_Server, and 2 folders in PSM_Client. If that doesn't work, replace the 127.0.0.1 address in each config with the name of the computer ie Matrix_Server. Sometimes it has issues using the local IP address. Lastly, make sure that Named Pipes and TCP/IP, VIA are Enabled and that the port is 1433. If there's no port there, then you need to reinstall MSSQL Server as changing the value won't work.