A couple of years ago I had released a small command line tool to set the passwords of the send ports (primary transport only) and the receive locations.
You can find the latest release of this tool at https://github.com/pellitteris/BizTalkPassword.
This allowed me to create scripts that, in the case of a complete application deployment, set all the necessary passwords reducing manual operations that often can cause errors.
This is just an example that can be extended if necessary. However, it has several features that can be used as is.
In the release I released a few days ago I implemented some new features with the aim of facilitating and therefore speeding up the updating of the scripts.
In particular I added these features:
- List all the port that have a user account and a password set
- Generate script to set passwords
To list all the port that have a user account and a password set, is enough type the following command:
Here the result:
The output is made in such a way that it can be easily imported into an Excel spreadsheet for documentation purposes.
To set passwords it is necessary to execute the “set” command. Being a command line tool, it is possible to create a batch file that sets all the necessary usernames/passwords. Keeping the script up to date can be a problem or a rather expensive activity, so I added a couple of features to simplify the already difficult deployment adventure.
In this regard it is possible to execute the “generatescript” command which generates a file with the necessary commands. The command can be executed as is, and in this case the passwords will have a placeholder “######” or can be executed with a json mapping file.
To generate the mapping file, run the following command:
The command generates a file .json like the following:
Now you have to substitute “null” with the password, then you can run the following command:
As a result you will have a “cmd” file with the commands ready to be executed.