Connection with Business Objects Credential Mapping

[Former Member]

Hello,

We are on BOXI 3.1 SP2. We have a SQL Server 2005 database - which recognizes our Windows AD accounts and allows us access based on that.

I am trying to create a Universe connection that can use Business Objects Credential Mapping, so that users can use their AD account to access data. However the login always fails.

Can you please let me know if I am missing any steps here? We normally use SQL server accounts for connection , but we are trying to integrate and use AD security.

Thanks a lot.

[arijit_das · Accepted solution]

When you are using BO Credential mapping in universe connection, you have to set the database userid and password in the user settings in CMC. Have you done that ?

Also make sure that while configuring AD authentication in CMC, you have not selected any option to update users' data source credentials at log on time.