|
Home > Archive > Commerce Server General > February 2004 > URGENT!!!! OLAP datawarehouse is not created.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
URGENT!!!! OLAP datawarehouse is not created.
|
|
| Dinesh Chadha 2004-02-25, 6:35 pm |
| 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
| |
| Michael O'Donovan [MSFT] 2004-02-26, 6:34 am |
| 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
>
| |
| Dinesh Chadha 2004-02-26, 9:35 am |
| 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[color=darkred]
resource[color=darkred]
preparation"[color=darkred]
>
>
>.
>
|
|
|
|
|