Tecnomatix Quality Management DPV ETL - Entries in ETLConfigExplorer web.config file causing errors

After installation of DPV ETL, attempting to launch the Config Explorer shortcut results in a "not authorized to view this page" error, despite the domain user being a local admin, with all required access. Also, attempting to log in to the Administration section results in the message "Failed to establish connection with SQL Server. Please check." 


It was found that entries in the web.config file found in the DPVETLENTWebApps\ETLConfigExplorer directory were causing the issue. The entry created by the installation process is as follows:

Server=tcp:ServerName\DPV,PortNum;Database=DPVETLENT;User=UserName;Password=Password;MultiSubnetFlavors=True

Looking at another environment where things were working, this entry was changed by removing the "tcp" and "Portnum" entries:

Server=ServerName\DPV;Database=DPVETLENT;User=UserName;Password=Password;MultiSubnetFlavors=True

Doing this fixed the issue upon re-launching the Config Explorer page. 

Solution

Having MultiSubnetFailover=True is the result of not unchecking SQL AlwaysON checkbox at installation time.




Seeing the tcp and PortNum are also part of the same selection.

Notes and References

Hardware/Software Configuration

Platform: INTL64
OS: window
OS Version: 764SP1
Product: TECNOMATIX
Application: QUALITY
Version: P10.1.7
Function: DPV

Ref: 001-9276722