DTS Task Kit 1 OLAP Services Processing Task error 
Author Message
 DTS Task Kit 1 OLAP Services Processing Task error

I have installed DTS Task Kit 1 in order to use the OLAP Services
Processing Task.  The OLAP Services Processing Task icon is displayed
in the DTS Design taskbar.  But when I try to drag the OLAP Task onto
the DTS workspace, I get the following error messages:

Package Error
OLAP Services Processing Task
Microsoft SQL Server OLAP Services must be installed on this computer
and the user must be an OLAP Administrator in order to create an OLAP
processing task.

HResult of 0x80004ffff (-2147155969) returned.  Unexpected error
occurred.  An error result was returned without an error message.

OLAP Services is definitely running on the server and is running under
an account that is also part of the local OLAP Administrators group.
In Enterprise Manager, I have connected to the SQL Server using a
trusted connection with the same NT account as OLAP Services is running
under.  SQL Server Agent and SQL Server are also running under the same
account that is a member of the local OLAP Administrators group.

I have tried getting this to work on two servers, with the same results
on each.  I can process the cubes manually via OLAP Manager, but would
simply like to automate the processing.

Does anyone have any ideas about how to solve this problem?  Thanks.

David

Sent via Deja.com http://www.***.com/
Before you buy.



Sat, 31 Aug 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. OLAP SERVICES DTS TASK KIT 1 Beta add-in to DTS

2. OLAP SERVICES DTS TASK KIT 1 Beta Add-in to DTS

3. DTS: ActiveX Script task error when using with Analysis Processing Task

4. DTS: ActiveX Script task error when using with Analysis Processing Task

5. OLAP Services Processing Task Error 2146221411

6. OLAP Addins (DTS OLAP Processing Task) bug?

7. dynamic properties task and olap processing task

8. dts analysis services processing task error

9. Microsoft DTS Task Kit (OLAP)

10. DTS: Create Process Task and Data Driven Query Task properties

11. OLAP services processing task icon not appearing

12. OLAP Services Processing Task Problem


 
Powered by phpBB® Forum Software