connecting to sql

[tracker62]

green arrow and break after

PHP Code:

2011-10-31 22:19:18 PS_DBAGENT__system log start (DBAgent01)

2011-10-31 22:19:18 DB gamedata connect error

2011-10-31 22:19:18 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-10-31 22:19:18 DBKillCountSave db alloc failed

2011-10-31 22:19:18 SAVE kill count ERROR

2011-10-31 22:19:18 CKeepObeliskMgr::DBSave db alloc failed

2011-10-31 22:19:18 SAVE g_KeepObeliskMgr ERROR

2011-10-31 22:19:18 GuildMgrSave::DBSave db alloc failed

2011-10-31 22:19:18 SAVE g_GuildMgrSave ERROR

2011-10-31 22:19:18 PS_DBAGENT__system log end (DBAgent01)


2011-10-31 22:19:18 3 1 SService::ServiceCtrlDispatcher(): service shutdown 


PHP Code:

2011-10-31 22:19:18 PS_GAME__system log start (Game01) [KR]

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/sorp1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/croco1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/croco2

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Troll1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Spink1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/GoldenPig

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Sorp3

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/SorpNamed1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/SorpNamed2

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Sorp2

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/CrocoNamed1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/CrocoNamed2

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/CrocoNamed3

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/OrcNamed1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/OrcNamed2

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/OrcNamed3

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/TrollNamed1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Deinos

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Parridalis

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Alcarian

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/ZinAlcaria

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Belizabeth

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Kirhiross

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/CrypticOne

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Haruhion

2011-10-31 22:19:18 Loaded Behavior In Factory : data/ai/Freezing

2011-10-31 22:19:18 DB gamedef connect error

2011-10-31 22:19:18 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-10-31 22:19:18 Call save all waiting...

2011-10-31 22:19:18 Call save all failed dbagent disconnected(user count = 0)...

2011-10-31 22:19:18 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

2011-10-31 22:19:18 Save Shaiya.SData 0

2011-10-31 22:19:18 PS_GAME__system log end (Game01)

2011-10-31 22:19:18 3 1 SService::ServiceCtrlDispatcher(): service shutdown 


PHP Code:

2011-10-31 22:19:18 PS_GAMELOG__system log start (GameLog01)

2011-10-31 22:19:18 DB gamelog connect error

2011-10-31 22:19:18 init db error

2011-10-31 22:19:18 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-10-31 22:19:18 PS_GAMELOG__system log end (GameLog01)

2011-10-31 22:19:18 3 1 SService::ServiceCtrlDispatcher(): service shutdown 


PHP Code:

2011-10-31 22:19:18 PS_LOGIN__system log start (Login01)

2011-10-31 22:19:18 DB userdata connect error, id=Shaiya, pass=Shaiya123

2011-10-31 22:19:18 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-10-31 22:19:18 PS_LOGIN__system log end (Login01)

2011-10-31 22:19:18 3 1 SService::ServiceCtrlDispatcher(): service shutdown 


PHP Code:

2011-10-31 22:19:18 PS_SESSION__system log start (Session)

2011-10-31 22:19:19 userlog connect failed

2011-10-31 22:19:19 initserver() failed

2011-10-31 22:19:19 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-10-31 22:19:19 PS_SESSION__system log end (Session)

2011-10-31 22:19:19 3 1 SService::ServiceCtrlDispatcher(): service shutdown 


PHP Code:

2011-10-31 22:19:15 PS_USERLOG__system log start (UserLog)

2011-10-31 22:19:15 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2011-10-31 22:19:15 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-10-31 22:19:15 PS_USERLOG__system log end (UserLog)

2011-10-31 22:19:15 3 1 SService::ServiceCtrlDispatcher(): service shutdown 


need help please

[taZツ]

There is your problem:
"2011-10-31 22:19:18 DB userdata connect error, id=Shaiya, pass=Shaiya123"

Check the SQL in the Security>Logins.

And create the Shaiya/Shaiya123 account!

[tracker62]

thank you for the response and how it is please

[castor4878]

possible fix:

run the following script in a request window:

IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
	EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END	
EXEC sp_addsrvrolemember 'Shaiya', 'sysadmin';

[tracker62]

I have no connection to the Shaiya on your order I made her tell me her

Msg 15118, Level 16, State 1, Line 1
Failed to validate password. This password does not meet Windows policy requirements because it is too complex.
Msg 15007, Level 16, State 1, Procedure sp_addsrvrolemember, Line 68
"Shaiya" is not a valid login or you do not have permission.

why it says it please

Msg 15118, Level 16, State 1, Line 1
Failed to validate password. This password policy Does not Meet Windows Requirements Because It Is too complex.
Msg 15007, Level 16, State 1, Procedure sp_addsrvrolemember, Line 68
"Shaiya" is not a valid login or you do not Have Permission

[benoli105]

maybe cauz u have to run as an administrator and because your password is toocomplex? :P