Skip to Content
0
Oct 21, 2021 at 02:07 AM

SAP BI 4.2 Integrate SQL Database through Window AD

322 Views Last edit Oct 21, 2021 at 11:25 AM 3 rev

Hi all,

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:

error.png

Question

1. Is USERID01 compulsory to be one of the BI user?

2. Is there any extra configuration require?

Attachments

error.png (14.0 kB)