Change the connection string

In a development environment can be really useful to change AX connection string. For example it can allow to have a dev and a test database installed, without the need to continuosly backuping and restoring databases.

This can be done simply be modifing the web.config file placed in the AOS Service webroot folder.

Relevant settings are these:

 

<add key="DataAccess.Database" value="AxDB" />
<add key="DataAccess.DbServer" value="localhost" />
<add key="DataAccess.SqlPwd" value="AQAAAHNm4l3JT6ikAPoAN//zuzANlILUc2biXclPqKQA+gA3//O7MA2UgtRxzT05oPoHdAzzl8TJlogm+j1Bj/7lMw/J56psZPViVbGDqC1uIg4uPlLBQvw1Ux1kEb9FpmhOWQYTzVw11ZvR6KQLQhEbyKh3eJmgOT3fWoUHYE4RA08mGs90rEpzVq1RvPxL0WZHWOsAIMx1IHHuTVzTE5WA+vVwlGvgPCFVUQniwZvHBHJKIhMZoS+8LU3sW8f4ouVyIF1JcC67fN+XpfGmy6o+VaHrnpeTJbaBHwt8QfaG4I9ARBzNgi7vS0DkvrI0tYSpSQjOlkH8W0Bs1ktSk3kxyITktB46lY2fd8EzMA6xEH0+fiZR/vAQ0m7YlTLajUDwXzSbqP3yXs7EHh2M4kDf5z3i0Wizfq4FRh04XAPS+uS7gpmY/j3TRqkQX19Mb9Oe52ldJVU2JsbFoZ2fTtisYyAElj1ICbTUc3rHsxrAcny7aBL37AO/SMTERRQAX1GDrmfpZLBy9AO3fyoOaDXcSVsKHyQ+ifWpndIqqlABrqkojitzpE481xa+eZDmcSldkb8RadXyQGeR9zDeJfbL6IERGm1+aZltt2FGjLsSDbJPQZdHyCnFVl618qezaIvIM94sXTfPslKYoH4wlvCr70p9GriB+GigIZXLWaP+wsxd9lteCnVyFQmN3JWBVfJxvySo7CMG5pTBGFNlf8Oj8J9Jp06eo7lNxKQy1BYq7sq1oNpLy9DME6Zh4Vrp9mX7nFmFdjv5jnNb" />
<add key="DataAccess.SqlUser" value="axdbadmin" />

 

First two settings refer to database name and Sql Server name. Next two represent user credentials. As you can see password is encrypted, so it is not easy to change it. So I wrote a simple utility to encrypt\decrypt Sql Server passwords. I called it Ax365DbPasswordManager.

Here its usage:

Ax365DbPasswordManager [/h|/help|/?|password] [/encrypt|/decrypt] [/v|/verbose]

  password     The password that should be processed (it is not mandatory just if this help is not required).
  /h /help /?  Shows this help.
  /encrypt     Encrypts the password.
  /decrypt     Decrypts the password.
  /v /verbose  Shows more info during the process.

You can download it by clicking here. My utility must be executed with administrator permissions and on the machine where the AOS is installed.

Leave a comment