Change SQL Password on Knowledge v9.4

THIS ARTICLE APPLIES TO:

Customers wishing to change the Microsoft SQL password on Moxie Knowledge version 9.4 Hot Fix #2 or later should follow the instructions in this article. 

PROCESS:

  1. Login to the Microsoft SQL server management studio with a user that has full administration rights.


     
  2. Click on "New Query" and execute the query below (replace your_username & your_password with your new password):

    "ALTER LOGIN [your_username] WITH PASSWORD=N'your_password' "

  3. Now open a command prompt and go to “cd C:\Windows\Microsoft.net\Framework64\v4.0.30319” and run below commands.
            a. aspnet_regiis.exe -pdf “appSettings” “C:\Program Files (x86)\Knowledgebase.Net”

            b. aspnet_regiis.exe -pdf “connectionStrings” “C:\Program Files (x86)\Knowledgebase.Net”

     
  4. Now go to “C:\Program Files (x86)\Knowledgebase.Net” and open the “web“ config file. You can see the old password configured in the "appSettings" and "connectionStrings" sections. Update these sections with your new password and save the file.


     
  5.  Restart IIS. (Please note that the web config file will be automatically encrypted).

AFFECTED SYSTEMS & USERS:

These instructions are only certified for use with Moxie Knowledge version 9.4 Hot Fix #2. 

ADDITIONAL INFORMATION:

If you have additional questions, please contact our Support team at 877-373-7848 (option 2) or via email at Support@gomoxie.com.

ESCALATION PROCEDURE: