[HELP] Login failed for user ...

[sony65]

Hi, i have change my linked server & now i have this error :

2015-05-03 19:41:33 PS_DBAGENT__system log start (DBAgent01)

2015-05-03 19:42:44 connect game, Name=



2015-05-03 19:42:44 connect game, Name=



2015-05-03 19:43:01 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Rebirth'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2015-05-03 19:43:01 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

I have add my DBUser & DBpw in .ini files i don't understand i have this error on my db_agent, I have test to try an other instance name but my db_agent search for user Rebirth (If i add new linked server with userdb = Shaiya & i change all of my .ini files i have this error and my db_agent search for Rebirth) i have try to unistall my db_agent & reinstall but the error stay .. help please

[{Skrillex}]

Hi,
are you User-PW encrypted in the .ini files?

[sony65]

Yes he are .. :/

[{Skrillex}]

Then you SQL-Account credinials are not correct.

Regards

[SkuulCandy]

Remove your linked server and re-execute the correct linked server. Many instance figure in your sql ?