Results 1 to 4 of 4

Thread: Problem : MSAS and SQLserver on 2 different servers

  1. #1
    Join Date
    Sep 2005
    Posts
    3

    Problem : MSAS and SQLserver on 2 different servers

    Client have 2 servers, one with Sqlserver 2000 and one with Analysis Services.

    Want to add a "Analysis Services Processing Task" to my DTS job on the SQLserver but the task does not exist since MSAS is not installed on the SQLserver...

    Client does not want to install MSAS on the SQL Server....

    Any ideas how to setup auto processing of the cubes ???




    Regards Tale Liereng

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    The task should be there no matter you install AS on it or not.

  3. #3
    Join Date
    Sep 2005
    Posts
    3
    No, there is no task in DTS like this. Checked another client without MSAS and there is no such task there. Think this is installed during inst. of MSAS.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Possible to install AS client on sql server?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •