Error after changing password

[[ADMIN]Cryptic]

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.

 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

[viper4513]

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

[[ADMIN]Cryptic]

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...

[sondo81]

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.

[viper4513]

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

[[ADMIN]Cryptic]

My issue been resolved

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

[adamkoolkid23]

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.