SYMPTOM:
In Strategy Web 9.x, when creating a DSN-less connection, there’s an option to check “Use windows authentication for login”. After check this option, and click OK to save, it prompts for empty username and password fields, as shown below:
If a dummy values is set in the field and save the connection. When click to retrieve the warehouse tables, the invalid dummy credentials is used.
Workaround:
Edit the DSN-less connection from Developer, check “Use network login ID (Windows Authentication) ” and save the DSN-less connection, as shown below:
CAUSE:
This is known issue in Strategy Web 9.x.
ACTION:
This issue was reviewed by our Technology team for feasibility and will not be scoped for a code fix in any upcoming Strategy release.
