connecting to sql

tracker62 · 10/31/2011, 23:52

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ツ~~ · 11/01/2011, 00:59

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 · 11/01/2011, 01:30

thank you for the response and how it is please

castor4878 · 11/01/2011, 01:34

possible fix:

run the following script in a request window:

Code:

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 · 11/01/2011, 01:56

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 · 11/03/2011, 03:30

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