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.