[HELP]Server disconnects after selecting server.

09/10/2011 11:19 Ablax#1
Quote:
2011-09-10 01:55:04 PS_DBAGENT__system log start (DBAgent01)

2011-09-10 01:55:08 connect game, Name=



2011-09-10 01:55:08 connect game, Name=



2011-09-10 01:56:25 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Shaiya'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2011-09-10 01:56:25 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2011-09-10 01:57:39 1 1 SAgent::Disconnect: (4, 64)

2011-09-10 01:57:39 1 1 T=000:02:00:000, RC=5,RCS=0, RB=174,RBS=1, SC=6,SCS=0, SB=2197,SBS=14

2011-09-10 01:57:39 disconnect game, Name=Game01



2011-09-10 01:57:39 save all... wait plz... enter /uc



2011-09-10 01:57:39 1 1 SAgent::Disconnect: (4, 64)

2011-09-10 01:57:39 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=4,SCS=0, SB=3838,SBS=25

2011-09-10 01:57:39 disconnect game, Name=Game01



2011-09-10 01:57:39 save market... wait plz...



2011-09-10 01:57:39 3 1 SERVICE_CONTROL_STOP

2011-09-10 01:57:39 PS_DBAGENT__system log end (DBAgent01)


2011-09-10 01:57:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Everytime i select server and press OK i dc with error 120.I'll be thankfull if you could help me.
P.S:WE changed our db password.If i change it bacj\ to the default one (Shaiya123) the server connects.But after i change it to another one it doesnt connect from the selection of server.And yup o copyed all the hashes.
Shaiya Remix Team

I used the serch button and found a fix in abrasive's post but i dont have that problem in the database....
09/10/2011 14:36 -Dizzy-#2
i would you use this link to help fix the problem
[Only registered and activated users can see links. Click Here To Register...]

Disconnect after selecting game server and clicking ok
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to trace what happens in this case and look for error messages in the logs. If there is an error message present in the logs try to find which SQL query that you traced with the profiler caused it.

credits to abrasive
09/10/2011 15:48 Ablax#3
Dizzy i dont have a problem in the database....
If i change my dbs password to Shaiya123 and the server config back to Shaiya123 it connects no problem....
So just if i use another password i got the problem
09/10/2011 16:23 -Dizzy-#4
well i am not sure about that one because when i change my password i don't get any problems
09/10/2011 16:37 viper4513#5
Make sure you actually entered the right Hashes, not the old one.. there is a full guide on how to change your database password properly here, just use the search, it was even answered like 3 days ago.