My site is running on Server1 (CS 2002/sp2 on Windows 2000
Server) and SQL Server 2000 and Analysis Services are
running on Server2. The name of site is "store" and the
database name is "store_commerce".

I don't have datawarehouse installed initially. Now I am
trying to install datawarehouse for this site by running
CSharp.pup file and chosing "DataWareHouse" as a resource
to install. I tried with a user with all credentials but
still unable to get OLAP Services part. It
created "store_dw" database in SQL server, but doesn't
create OLAP Services part for the site.

So when I run DTS package it fails at "Report preparation"
task.

I will really appreciate any help on this.

Thanks
Dinesh Chadha

[ Post a follow-up to this message ]

Hi,

Check to make sure that the user account that is used when un-packing the DW
resource is a member of the OLAP administrators group.

Hope this helps,
Michael

--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dinesh Chadha" <anonymous@discussions.microsoft.com> wrote in message
news:1aa601c3fbf0$7d68f860$a101280a@phx.gbl...
> My site is running on Server1 (CS 2002/sp2 on Windows 2000
> Server) and SQL Server 2000 and Analysis Services are
> running on Server2. The name of site is "store" and the
> database name is "store_commerce".
>
> I don't have datawarehouse installed initially. Now I am
> trying to install datawarehouse for this site by running
> CSharp.pup file and chosing "DataWareHouse" as a resource
> to install. I tried with a user with all credentials but
> still unable to get OLAP Services part. It
> created "store_dw" database in SQL server, but doesn't
> create OLAP Services part for the site.
>
> So when I run DTS package it fails at "Report preparation"
> task.
>
> I will really appreciate any help on this.
>
> Thanks
> Dinesh Chadha
>

[ Post a follow-up to this message ]

Yes, user is a member of OLAP administrative group.

Both servers IIS & Database are on same domain. And I
tried running the pup package as a Domain User who is a
member of OLAP Administrative group and has full admin
rights on both servers.

Is there a way I can run pup package on Database server
(which doesn't have commerce server installed) ?

Thanks
Dinesh Chadha

>-----Original Message-----
>Hi,
>
>Check to make sure that the user account that is used
when un-packing the DW
>resource is a member of the OLAP administrators group.
>
>Hope this helps,
>Michael
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Dinesh Chadha" <anonymous@discussions.microsoft.com>
wrote in message
>news:1aa601c3fbf0$7d68f860$a101280a@phx.gbl... 
2000 
resource 
preparation" 
>
>
>.
>

[ Post a follow-up to this message ]