Originally posted by Covea.Quote:
2 Minutes Searchin':
Failed to connect to game server, after selecting server and clicking ok
May be caused by Windows Firewall blocking the client trying to connect to the server.
Can also be caused by the incorrect IP address entered in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_g ame.ini on the line that starts with GamePublicIP=
It could possibly also be from incorrect IP addresses in other .ini files.
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.
I've ran into this specific cause of the above many times now, and it always happens to me when I set up a fresh server. Never have I seen anyone else mention it before though. I decided to add it here just in case it would be useful to someone.
Inside of PS_GameData.dbo.usp_Read_Char_Product_Item_E there is this query:
Code:
SELECT Slot,ItemID,ItemCount FROM PS_USERDB01.PS_Billing.dbo.Users_Product WHERE UserUID=@UserUIDSince PS_USERDB01 does not exist, it causes my client to disconnect after selected the server and clicking ok.
To fix it, I remove PS_USERDB01 from the stored procedure so the query looks like this:
Code:
SELECT Slot,ItemID,ItemCount FROM PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID[GUIDE] Troubleshooting Common Server Set Up Problems
Thanks to abrasive.