Problem : SQLserver and MSAS on 2 diffferent servers

#1

Client doesn't want to install AnalysisServices on same server as SQL 2000...
Why ??

Problem now is how to automate processing of cubes.

Normally I add a "Analysis Services Processing Task" as last step in my
DTS-jobs on the SQLserver.

Since MSAS is not installed on the SQLserver I cant find this task in DTS !
And on the server with MSAS there is no SQLserver.....

Any ideas how this can be solved ????

#2

Tale Liereng wrote:

Quote:

Client doesn't want to install AnalysisServices on same server as SQL 2000...
Why ??

Problem now is how to automate processing of cubes.

Normally I add a "Analysis Services Processing Task" as last step in my
DTS-jobs on the SQLserver.

Since MSAS is not installed on the SQLserver I cant find this task in DTS !
And on the server with MSAS there is no SQLserver.....

Any ideas how this can be solved ????

Install the AS tools on the SQL Server. This includes the processing
task, but since it is tools only, it will not install the engine. You
can do the same on a workstation, to allow remote management (and
processing) of AS.

--
Darren
http://www.sqldts.com
http://www.sqlis.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Problem : SQLserver and MSAS on 2 diffferent servers

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Problem : SQLserver and MSAS on 2 diffferent servers - 12-14-2005 , 06:25 PM

Re: Problem : SQLserver and MSAS on 2 diffferent servers - 12-15-2005 , 02:34 AM