[Request] How to change database pwd

[viper4513]

Yeah, i get the same thing Cryptic, trying to work out out myself right now..

Just DB_Agent my error is.. that "shaiya" account keeps failing.

[[ADMIN]Cryptic]

let me know if you figure it out im trying too

I read somewhere that this could have something to do with linked servers but no idea how that works or how to fix it... anyone?

[andya78]

sorry for bumping an old thread but cryptic or viper did either of you find out what caused this error and how to fix it? i changed the password in my SQL bt got confused so changed it back and now its saying my account doesnt exist

Originally Posted by jamessimpler

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.

Tottally stopped my server working and changing it back didnt fix it -_-

[adisportivul]

Open Microsoft SQL Server Management Studio Express ,,, Go to > Security> Server Objects > Linked Servers> Now you with a brain.exe you will need to know what missing or what need to change
__________________________________________________ ______
[Adm]WarSan
SandofWar