Post reply

DTS Analysis Services Processing Task

  • October 21, 2005 at 6:04 pm

    #110291

    I am having a problem in the Enterprise Manager while

    trying to use DTS Analysis Services Processing Task. I dragged the 

    Analysis Services Processing Task into the DTS design window.

    My server is listed in the "Select Object to process" pane. When i click on it, it thinks for about 45 seconds, and then comes up with an error box. It

    states: "Unable to connect to server". 

    I have tried connecting with localhost box checked, and without.

    The OLAP service is running, as i can open Analysis manager and browse through everything. I have my username added to OLAP administrators as well as the account that SQL Server Agent runs on.

    I am running SQL server 2000 with service pack 3.

    Thanks

    Regards, Jim C

  • October 22, 2005 at 2:50 pm

    #599375

    Do you have the appropriate users setup in SQL Server (sa, BUILTIN/administrator)?

     

    Which account did you find SQL Server Agent runs under?  SYSTEM ?

  • October 24, 2005 at 9:24 am

    #599550

    Thank you for the reply...Yes, both sa and BUILTIN/Administrators are set up on the server. SQL Agent runs under a windows account set up for that machine. That account was also added to the OLAP Administrators group.

    Regards, Jim C

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply