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.