Error after changing password

10/12/2011 19:06 [ADMIN]Cryptic#1

I changed the password using a guide found here on forum.
I did this and added all HASH codes. But I get DC everytime right after I choose server

this is the error I get in DBagent.

Code:

 2011-10-12 14:17:25 PS_DBAGENT__system log start (DBAgent01)

2011-10-12 14:17:31 connect game, Name=



2011-10-12 14:17:31 connect game, Name=



2011-10-12 14:17:51 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Shaiya'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2011-10-12 14:17:51 ::LoadBillingItem 135  qerr=-1, EXEC usp_Read_Char_Product_Item_E 135

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

2011-10-12 14:18:10 ::LoadBillingItem 36  qerr=-1, EXEC usp_Read_Char_Product_Item_E 36

2011-10-12 14:18:22 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Shaiya'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2011-10-12 14:18:22 ::LoadBillingItem 992  qerr=-1, EXEC usp_Read_Char_Product_Item_E 992

2011-10-12 14:18:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Shaiya'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2011-10-12 14:18:47 ::LoadBillingItem 36  qerr=-1, EXEC usp_Read_Char_Product_Item_E 36

2011-10-12 14:18:55 1 1 SAgent::Disconnect: (4, 64)

2011-10-12 14:18:55 1 1 T=000:01:00:000, RC=8,RCS=0, RB=149,RBS=1, SC=114,SCS=1, SB=196008,SBS=2361

2011-10-12 14:18:55 disconnect game, Name=Game01



2011-10-12 14:18:55 1 1 SAgent::Disconnect: (4, 64)

2011-10-12 14:18:55 1 1 T=000:01:00:000, RC=16,RCS=0, RB=413,RBS=4, SC=76,SCS=0, SB=46693,SBS=562

2011-10-12 14:18:55 disconnect game, Name=Game01



2011-10-12 14:18:55 3 1 SERVICE_CONTROL_STOP

2011-10-12 14:18:55 save all... wait plz... enter /uc



2011-10-12 14:18:55 save market... wait plz...



2011-10-12 14:18:56 PS_DBAGENT__system log end (DBAgent01)


2011-10-12 14:18:56 3 1 SService::ServiceCtrlDispatcher(): service shutdown

I searched on forum and it seems like it might have something to do with the linked server but I dont see anywhere it says how to fix it. Anyone know? would help alot

10/12/2011 19:21 viper4513#2

Hey Cryptic, not too sure if it will help you or not with the linked servers, but..

If you go to the linked servers in your DB, right click and select "test connection" see what it says..
If it says something like login failed for user "Shaiya" go into the properties for that linked server, and change the user & pass to a new one you've created for yourself (under security)

It may help.. i gave up and re-installed.. gunna have another go at those passwords at another time :)

10/12/2011 19:34 [ADMIN]Cryptic#3

Hmm it does say that.

How do I change the pw in linked servers?
when i try and change it says ad hoc updates to system cataloges are not allowed.

can you pm me your skype? its very important I get this fixed so I can secure the last hole in my server...

10/13/2011 03:35 sondo81#4

why do you wont change the Pw? just secure your DB!! PW change dont need!!!!!!

SQL injection only function with an open port!
Close all TCP conections!

Run your SQL on Lokal mode!!

For PvP Rankings or User Online use an Pre resultServerSkript.

10/13/2011 13:29 viper4513#5

Hey Sondo, could you give a little more info on what a "pre result server script" would be, or look like for a php nubbie?

I can work out the php scripts here, like pvp ranks, users online, registration. But they obviously do have there "flaws" with security and connecting to the database. I was just wondering what you meant by the pre result script :)

10/13/2011 17:14 [ADMIN]Cryptic#6

My issue been resolved :)

and changing the DB password seems like a waste of time lol

10/16/2011 14:04 adamkoolkid23#7

well apparently i heard from someone that the DB PW change on here is exploited...someone can still get in your DB if you use the PW change...didnt get too much information on it and not sure if its actually true, but i wouldnt do it just in case.

EDIT: oh and also, all you really need to do is close port 1433, thats the SQL port, noone can get in your DB then, unless ofc they have your VPS/Dedi credentials if you are on a VPS/Dedi. Also might be a good idea to code in an IP tracker, IP change and IP blocker on your database...for extra security.