Some organizations may set up a mechanism by which the setup.xml is distributed to all users in order to distribute a common setup configuration. Because each user’s machine will have a unique certificate installed by default, this mechanism will fail if passwords are stored in the file as is the case with SQL server authentication (as opposed to using Windows Authentication).In order for SQL server authentication to work, the same certificate must be installed on each user’s machine, and the Setup.xml must be directed to use that certificate. This article describes how to obtain a certificate that can be installed on all machines.
Creating and distributing a security certificate is not necessary if using Windows Authentication on Setup or if the Setup.xml file is not going to be distributed.
Makecert.exe is Microsoft’s tool for creating certificates. It is available through the Windows SDK.
To create a certificate that can be installed on multiple computers, follow this procedure:
Install the .pfx file in the certificate store using the Microsoft Management Console plugin.
[ promis.e program data ]\Config\Setup.xml
[ Substation program data ]\Config\Setup.xml
Distributing the Setup configuration
Network Installation Guide