SAP BI 4.2 Integrate SQL Database through Window AD

[former_member419024]

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:

Question

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

2. Is there any extra configuration require?

[former_member419024]

Update:

Login using Window AD authentication to refresh the newly created report, error below occurred.

User ID CMS using is the same ID from SQL Server Window Authentication Login ID. Any other steps that I missed out?

[DellSC]

For the CMS, you need to be running the SIA with a AD service account and give that service account SQL Server credentials to the CMS and Audit databases.

For the data, you either have AD users and give each user access to the database for SSO to work, along with giving the service account from above the same access so that schedules will run, or you have to use SQL Server authentication for a common "generic" report login to the database.

-Dell

[former_member419024]

Hi Dell thanks for the advice!

I had actually done all the steps mentioned, however still getting 'SSO failed in CMS' error. Did you know what causes the error pop out?

Just for confirmation, the SQL database which wanted to integrate is not the database that run CMS, is it still possible to integrate with non-CMS running database via Window AD?

[DellSC]

Is the BOBJ user an AD user or is it an Enterprise user? I know for sure this won't work with an Enterprise user.

-Dell