My current situation below:
1. Created Login Credential 'USERID01' in SQL with Window Authentication, the newly created ID is the one running SIA currently.
2. Created ODBC to access SQL Server, Window Authentication is chosen in ODBC, tested the connection in local it work fine.
3. Created Universe based on connection setup above, tested and working fine in local server.
4. Login into BI Launchpad using Admin & normal Window AD user, created report in BI Launchpad using published universe above, 'Authentication Error' pop out. Screenshot below:
1. Is USERID01 compulsory to be one of the BI user?
2. Is there any extra configuration require?