more quick actions
minimize quick actions
Hi All,
In a redundant PcVue architecture for Historical Servers, how PcVue handle the Database connections if a password is set required in database ?
The secureconnectionString(in the HDSConf.dat file) in the server1 is different than one in the server2.
How do you manage it ? configure the databases locally for each Historical Server ?
Thanks
Ibrahima
Posted : 12/04/2017 12:19 pm
Hi Ibrahima,
Using the SQL user to connect is a bad use in term of security and also in your case.
The real solution is to use the Windows user login.
Nico
Posted : 12/04/2017 12:24 pm
Hello Ibrahima,
Yes you'll have to manage 2 different configuration and to confogure connection string separately on both stations.
As Nicolas said, and if possible, it is recommended to use Window authentication (with PcVue running as a service) for security reasons (no password in the connection string and authentication messages, password manages by Windows, ...) and also because you'll have a unique configuration file.
@Nicolas: sometimes you have no other choices than to use SQL authentication, for instance, when there is no or untrusted domain controller. It is clearly a better use, but not a bad use, otherwise they'll stop enabling it (and they don't care about compatibility...)
Posted : 13/04/2017 11:22 am