BUG: OLAP Manager:Error Processing When Data Source and Server Use Integrated Security

ID: Q225256

BUG #: 1298 (plato7x)
The information in this article applies to:


SYMPTOMS

The Microsoft OLAP Manager is unable to process a dimension when the underlying object(s) are owned by a user other than 'dbo' or the current account in which the MSSQLServerOLAPService service is configured to run. This occurs when the SQL Server data source uses integrated security. Database objects owned by the currently logged on user are available for use in building dimensions and cubes but return an error when processed.

The error messages returned during processing are:

ODBC error: Invalid object name '<source_table>'.;42S02; Time: <current datetime>
Invalid object name '<source_table>'.;42S02; Time: <current datetime>


CAUSE

This is caused because the OLAP Services uses the account of the currently logged on user to browse the list of objects available for building dimensions and cubes. However, when processing OLAP Services uses the account under which the MSSQLServerOLAPService service is configured to run. Because the object owner is not stored along with the object name, it cannot find objects owned by users other than the service account or 'dbo'.


WORKAROUND

Here are two workarounds for this issue:


STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0.

Additional query words:


Keywords          : kbSQLServ700 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: June 4, 1999