Windows AD connection for a BO Universe.

[Former Member]

Hiu2026

I am new to the Universe Designer and CMC interface.

My question is this:

Can I establish a database connection, for a universe, to a MS-SQL 2008 server using either ODBC or OLE DB that uses Windows authenticated account and not a SQL Server authenticated login ID/Password?

When I create a ODBC / OLEDB integrated security on the BO server and test the universe connection, the user that is currently using the Universe is the account that is being passed to the MSSQL 2008 database, for authentication. I cannot use that pass-through connection. I need to use a dedicated service AD account to be the connection between our Universe an our MSSQL 2008 database.

I haven't read any on-line information that explains how to connect a universe to a data source, using a domain AD account. If someone can point me to some on-line documentation, I would appreciate it. And the BO server version that is being used: 3.1.

Thanksu2026

[Former Member]

It's a known issue. You need a dedicated account unfortunately

[Former Member]

Hi Joe,

your thread is close to

http://scn.sap.com/thread/1532816

http://scn.sap.com/thread/3309317

Regards

NK

[Former Member]

Hi Joe, I got the same problem as yours. Wonder if you have already got a solution to successfully connect to SQL Server using a service AD id?

Appreciate your sharing if you have a solution. thanks!

Eddie