connecting to sql

10/31/2011 23:52 tracker62#1
green arrow and break after :handsdown:

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 :handsdown:
11/01/2011 00:59 taZツ#2
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!
11/01/2011 01:30 tracker62#3
thank you for the response and how it is please
11/01/2011 01:34 castor4878#4
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';
11/01/2011 01:56 tracker62#5
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

:confused:
11/03/2011 03:30 benoli105#6
maybe cauz u have to run as an administrator and because your password is toocomplex? :P