[HELP] Login failed for user ...

05/03/2015 19:48 sony65#1
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 :(
05/03/2015 19:57 {Skrillex}#2
Hi,
are you User-PW encrypted in the .ini files?
05/03/2015 20:08 sony65#3
Yes he are .. :/
05/03/2015 20:33 {Skrillex}#4
Then you SQL-Account credinials are not correct.

Regards
05/03/2015 22:02 SkuulCandy#5
Remove your linked server and re-execute the correct linked server. Many instance figure in your sql ?