I need to reset or fix the SQL Server login for the special login "trade"

Question

I was having problems getting things to work... so I changed the password to the special user account "trade".  Since the actual password is encripted in the web config file... what is the default???  I tried yyy and it doesn't work.  I have done a lot of work so I don't want to uninstall and reinstall everything just to get the password back.

---

scott

Answer 1

It's "trade" by default, same as the userid.  Note this is actually not stored in any .config file; rather its stored in the SQL Server Business Service and Order Processor repositories, and modified via ConfigWeb as an app-specific setting.

The repository logins, however, are stored in config files, and encrypted. 

-Greg

---

Greg Leake, Microsoft

Answer 2

thank you... it was rude of me to take so long to respond.  I figured i out.  I am busily adaptig the appliction.  I pointd trades to an different db name.   thank again

---

scott

Answer 3

Yes, for sure.   For the Trade stockdb database, you simply use config web and change for both the Business Services (both IISHOsted and self-hosted since these each have their own unique config dbs), after changing the password on SQL Server using SQL Management Studio.

 

For the config databases, these are contained in web.config and app.config files.  All elements by default login as the same user, configadmin, default pword yyy.  To change these, since the config files are encrypted on install, you need to decrypt the files (remember, only the machine you have installed to can decrypt the app/web.config files on that specific machine, since a machine-specific RSA key is used).  You can read on MSDN how to encrypt/decrypt config files using ASPNET_REGIIS.exe tool.  Once decrypted and passwords changed, you should re-encrypt using ASPNET_REGIIS.exe again.  Let me know if need help on syntax for ASPNET_REGIIS.

-Greg

---

Greg Leake, Microsoft

Answer 4

Also, need to use config web to change pword to stocktraderdb for order processor service as well....just like for business services.

---

Greg Leake, Microsoft