[Please Help] PS_DBAGENT error

07/13/2012 14:21 .Nexus'#1
Hello
I have a big Problem. When i start my Server , everything is OK , but when i want to connect to my Server ingame he says:


"Connection to the server has been disconnected
ERROR
0"


Then i looked in my PS_DBAGENT_system and saw this:

2012-07-13 14:02:34 PS_DBAGENT__system log start (DBAgent01)

2012-07-13 14:03:36 connect game, Name=



2012-07-13 14:03:36 connect game, Name=



2012-07-13 14:03:41 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER_SQL_SERVER'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2012-07-13 14:03:41 ::LoadBillingItem 26 qerr=-1, EXEC usp_Read_Char_Product_Item_E 26


Can someone help me to fix this error ?
07/13/2012 15:05 treica#2
Quote:
Originally Posted by EpicG4m3r
2012-07-13 14:03:41 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER_SQL_SERVER'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)
In ShaiyaServer > Server > Batch there is a file named Linked Servers open it copy the content and paste as a new query into mssql then replace the lines were is
User_SQL_Server with Shaiya
User_SQL_Password with Shaiya123
Then run the query and will fix your problem.