[Request] How to change database pwd

[darryusa]

does any one know how to change the server and database password? i tried to change the password in PSMSERVER_Mgr and then i update it it said "disable update check service PSM_AgentServer

[Souljah671]

uhmm lol

[joeh1cks]

MARVEL'd

[alregenhardt]

not sure if this is even relevent. I am clueless when it comes to this kind of stuff.

[darryusa]

tried that and its messed up the sv file

[lae]

PSM is only using your SQL database and the account in the PSM is only a simple user of the SQL database with database access permit.

If you want to change the password of a user u can simple do it like this:

EXEC sp_password 'Old_password','new_password','login'

After you have to change the password in the PSM and update.

[joeh1cks]

Originally Posted by lae

PSM is only using your SQL database and the account in the PSM is only a simple user of the SQL database with database access permit.

If you want to change the password of a user u can simple do it like this:

EXEC sp_password 'Old_password','new_password','login'

After you have to change the password in the PSM and update.

i tried it, didnt work for my server

[jamessimpler]

Originally Posted by lae

PSM is only using your SQL database and the account in the PSM is only a simple user of the SQL database with database access permit.

If you want to change the password of a user u can simple do it like this:

EXEC sp_password 'Old_password','new_password','login'

After you have to change the password in the PSM and update.

This shit took me 2 days to figure out. After tries after tries , I finally managed to figure it out. The above statement is correct except one thing, DO NOT USE THIS TO PSM UPDATE tool! This does not work!

Before I start giving the actual technique, i would like to say is although there are some exceptional guys like our hero Lilpro, Profs, and a few others who continuously and selflessly contributed back to the Elitepvper community, i think generally the community here are relatively selfish in giving back or share their knowledge to the community. I am not blaming or trying to offend anyone but just wishes to express my disappointment. I think as community, our purpose is to help each other out where it is possible. But I thanks those who selflessly contributed to this community and i sincerely hope that we could be a better community as a whole.

Anyway, back to changing the password, the key word here is HASH. Just for your info, THE PSM also can run using another SQL username (if u created a different SQL username instead of just sticking to the original 'Shaiya') and still able to run the PSM.

1st Step:
I shutdown all services. Uninstall all services (which give u the pause button) and I also kill the PSM_Agent.exe and PSMServer_Agent.exe service from Task Manager just to make sure its clean.

2nd Step:
I changed the password of the SQL username 'Shaiya' by using SQL Server Management Studio. I changed from default Shaiya123 (the original password) to something like 'admin123'. Once ur password has change. U can close the SQL Server Management Studio.

3rd Step: This IS IMPORTANT
Now u need to open the following files using ur choice of text editor:
1. PSMServer_Config.ini --> found at "D:\SHAIYA_SERVER\SERVER\PSM_Server\Config"

2. ps_userlog.ini
3. ps_login.ini
4. ps_gameLog.ini
5. ps_game.ini
6. ps_dbAgent.ini
which u can find D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config

From here on u will need the following application called 'PS_PasswordEnc.exe' which u can find it on ur Shaiya Private Server Folder. I found this file under "D:\SHAIYA_SERVER\SERVER\PSM_Server". Open this executable application and u will see there is an input or text box. Enter your password that u have change into the input box, which in my case is "admin123". Now the moment u enter the password, u will see the encrypted or hash code below ur input box appear, which look something like:

FC4F94FE1DEF4900DBBC030D0F588488DED411C73BE405F563 DDF175566DF63AD80DF9F1FB2A3FB3223357620ED51D85A918 708501FB20E8CAA3608B0522A741C1A63027B2C8FD06865DFB 61D9AAD14698E8D87D3ED95D2B118D4B804B798326ED495989 EB609DCF26808384B0420A3A954AC26970ABFCF9307F8ED058 AB1575

THIS IS SOMETHING U NEED TO COPY TO your configuration files (or the opened ini files i mentioned above). Now the important part, u need to make new Hash Code for each of the Hash Code u have on ur ini files. If you notice, although your SQL user password is same, the Hash Code generated or (which already appeared on ur ini files) are very different. Therefore u will need to create new hash code for each line that need the hash code inside the specified ini files.

You may ask how can we generate new hash code? Well in the PS_PasswordEnc.exe text box, i just delete the old one and re enter back the password which in my case is admin123. U will see the Hash Code generated are different from the old one.

After you done with all the *.ini files changes (after u added ur version of hash code generated from the PS_PasswordEnc.exe) and save it. Restart/install the PSM services (if u terminated or killed ur PSM_Agent.exe and PSMServer_Agent.exe service, just restart ur machine is the easiest or else manually add them back to the service). And you will see this work. Hopefully my explanation helps.

[Danco1990]

Changing the password takes ALOT more then just editing a few lines... Came into this myself a long time ago when i had my own server. Just make sure people cant reach your SQL and you wont have to change it... I made a tutorial here:



Danco1990

[jamessimpler]

Originally Posted by Danco1990

Changing the password takes ALOT more then just editing a few lines... Came into this myself a long time ago when i had my own server. Just make sure people cant reach your SQL and you wont have to change it... I made a tutorial here:



Danco1990

After spending days after days on the server... i concluded and agreed with what Danco said is correct. SIMPLE DONT OPEN THE PORT 1433. Infact hell with changing password. There is so many hidden things in the Pserver that i was not made aware of and therefore not worth the time to explore it any further.

[yitiana]

I know a tool which can instantly reset MS SQL Server and Express 2000/2005/2008 password, including SA and other users password, no matter the password is how long and complex, Only the master.mdf file is needed for resetting the password within seconds. And you do not need to reinstall MS SQL Server on your PC. Save more time and trouble.

[AriezOMG]

I've followed this tutorial jamessimpler wrote after getting my accounts table deleted by a php file, i'm requesting help as I am now getting an "Account Does Not Exist" error, people cannot login.

[[ADMIN]Cryptic]

Originally Posted by jamessimpler

2nd Step:
I changed the password of the SQL username 'Shaiya' by using SQL Server Management Studio. I changed from default Shaiya123 (the original password) to something like 'admin123'. Once ur password has change. U can close the SQL Server Management Studio.

how exacly did you do that step? change the pw of the username shaiya thats it. Nothing seem to work for me

[viper4513]

Go into your SQLSMS
Go to Security, and find the account
Right click and go to properties
Then change your password
Simples But still not effective with hashing in the ini's

[[ADMIN]Cryptic]

So this method not effective?

Ok I did this and added all HASH codes. But I get DC everytime right after I choose server

edit: 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