A
al
After getting my user and permissions corrected, I still get this error when
trying to build a cube - suggestions?
Thanks,
trying to build a cube - suggestions?
Thanks,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary L. Chefetz [MVP]
What do you mean by "getting my user permissions corrected?" It certainly
doesn't sound like it.
doesn't sound like it.
A
al
I will try to be a little more lucid in my detail.
The user I am trying to create the cube with is:
a) a member of the Admin and OLAP Admin group on the Project server
b) a member of the Admin and OLAP Admin group on the SQL server
c) a member of the Admin group in Project (as a User)
d) a Domain Admin
PSComPlus.exe has been run, and tells me "Microsoft Project Server
components are now running in Com+".
The Analysis Services Repository was migrated at setup, and the ProjAdmin
user is Admin on the server, so he (presumably) can write anywhere.
I am trying to create the cube as the ProjAdmin user from the Project
Server.
Here are the specific errors I get:
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Date: 4/4/2005
Time: 10:36:25 AM
User: SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>
Date: 4/4/2005
Time: 10:36:25 AM
User: Biznet-1\SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Unable to connect to the registry on the server (DBSRVSQL2K), or
you are not a member of the OLAP Administrators group on this server.' Error
Number : '-2147221455]]></Description>
I have worked through the "OLAP cube generation may not be successful in MS
PWA" posting, and this is MS Project Server 2003.
Any guidance?
The user I am trying to create the cube with is:
a) a member of the Admin and OLAP Admin group on the Project server
b) a member of the Admin and OLAP Admin group on the SQL server
c) a member of the Admin group in Project (as a User)
d) a Domain Admin
PSComPlus.exe has been run, and tells me "Microsoft Project Server
components are now running in Com+".
The Analysis Services Repository was migrated at setup, and the ProjAdmin
user is Admin on the server, so he (presumably) can write anywhere.
I am trying to create the cube as the ProjAdmin user from the Project
Server.
Here are the specific errors I get:
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Date: 4/4/2005
Time: 10:36:25 AM
User: SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>
Date: 4/4/2005
Time: 10:36:25 AM
User: Biznet-1\SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Unable to connect to the registry on the server (DBSRVSQL2K), or
you are not a member of the OLAP Administrators group on this server.' Error
Number : '-2147221455]]></Description>
I have worked through the "OLAP cube generation may not be successful in MS
PWA" posting, and this is MS Project Server 2003.
Any guidance?
G
Gary L. Chefetz [MVP]
Al:
When you say "The user I am trying to create the cube with is" you mean that
this is the account you used to for the COM+ identity? Please confirm.
If so, the next thing we'd to know is the setup of your system. For the
moment, I'm going to assume that your SQL Analysis Services is not running
on the same box as Project Server. If this supposition is correct, I'd make
sure that SQL Server SP3.a has been applied to both the machine running SQL
and Analysis Services as well as the machine running Project Server.
When you say "The user I am trying to create the cube with is" you mean that
this is the account you used to for the COM+ identity? Please confirm.
If so, the next thing we'd to know is the setup of your system. For the
moment, I'm going to assume that your SQL Analysis Services is not running
on the same box as Project Server. If this supposition is correct, I'd make
sure that SQL Server SP3.a has been applied to both the machine running SQL
and Analysis Services as well as the machine running Project Server.
al said:I will try to be a little more lucid in my detail.
The user I am trying to create the cube with is:
a) a member of the Admin and OLAP Admin group on the Project server
b) a member of the Admin and OLAP Admin group on the SQL server
c) a member of the Admin group in Project (as a User)
d) a Domain Admin
PSComPlus.exe has been run, and tells me "Microsoft Project Server
components are now running in Com+".
The Analysis Services Repository was migrated at setup, and the ProjAdmin
user is Admin on the server, so he (presumably) can write anywhere.
I am trying to create the cube as the ProjAdmin user from the Project
Server.
Here are the specific errors I get:
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Date: 4/4/2005
Time: 10:36:25 AM
User: SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>
Date: 4/4/2005
Time: 10:36:25 AM
User: Biznet-1\SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Unable to connect to the registry on the server (DBSRVSQL2K), or
you are not a member of the OLAP Administrators group on this server.'
Error Number : '-2147221455]]></Description>
I have worked through the "OLAP cube generation may not be successful in
MS PWA" posting, and this is MS Project Server 2003.
Any guidance?
Gary L. Chefetz said:What do you mean by "getting my user permissions corrected?" It certainly
doesn't sound like it.
A
al
Both assumptions are correct. What is currently wrong is that, apparently,
in checking the service pack info on the Project server, there is NO
msmdsrv.exe in the \Program Files\Microsoft Analysis Services\Bin folder.
Apparently, the Analysis Services install was hosed. I do have msmdlog.mdb,
msmdrep.mdb, msolap.upd, and msmdrasf.lck there, so how to recover from
here?
Uninstall and reinstall Analysis Services on the Project Server? Since sp3a
was installed, it won't let me launch SQL2000 again to "repair".
in checking the service pack info on the Project server, there is NO
msmdsrv.exe in the \Program Files\Microsoft Analysis Services\Bin folder.
Apparently, the Analysis Services install was hosed. I do have msmdlog.mdb,
msmdrep.mdb, msolap.upd, and msmdrasf.lck there, so how to recover from
here?
Uninstall and reinstall Analysis Services on the Project Server? Since sp3a
was installed, it won't let me launch SQL2000 again to "repair".
Gary L. Chefetz said:Al:
When you say "The user I am trying to create the cube with is" you mean
that this is the account you used to for the COM+ identity? Please
confirm.
If so, the next thing we'd to know is the setup of your system. For the
moment, I'm going to assume that your SQL Analysis Services is not running
on the same box as Project Server. If this supposition is correct, I'd
make sure that SQL Server SP3.a has been applied to both the machine
running SQL and Analysis Services as well as the machine running Project
Server.
al said:I will try to be a little more lucid in my detail.
The user I am trying to create the cube with is:
a) a member of the Admin and OLAP Admin group on the Project server
b) a member of the Admin and OLAP Admin group on the SQL server
c) a member of the Admin group in Project (as a User)
d) a Domain Admin
PSComPlus.exe has been run, and tells me "Microsoft Project Server
components are now running in Com+".
The Analysis Services Repository was migrated at setup, and the ProjAdmin
user is Admin on the server, so he (presumably) can write anywhere.
I am trying to create the cube as the ProjAdmin user from the Project
Server.
Here are the specific errors I get:
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Date: 4/4/2005
Time: 10:36:25 AM
User: SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>
Date: 4/4/2005
Time: 10:36:25 AM
User: Biznet-1\SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Unable to connect to the registry on the server (DBSRVSQL2K), or
you are not a member of the OLAP Administrators group on this server.'
Error Number : '-2147221455]]></Description>
I have worked through the "OLAP cube generation may not be successful in
MS PWA" posting, and this is MS Project Server 2003.
Any guidance?
Gary L. Chefetz said:What do you mean by "getting my user permissions corrected?" It
certainly doesn't sound like it.
A
al
Thanks for your help - uninstalling Analysis Services, and reinstalling,
with SP3a fixed the problem.
with SP3a fixed the problem.
al said:Both assumptions are correct. What is currently wrong is that, apparently,
in checking the service pack info on the Project server, there is NO
msmdsrv.exe in the \Program Files\Microsoft Analysis Services\Bin folder.
Apparently, the Analysis Services install was hosed. I do have
msmdlog.mdb, msmdrep.mdb, msolap.upd, and msmdrasf.lck there, so how to
recover from here?
Uninstall and reinstall Analysis Services on the Project Server? Since
sp3a was installed, it won't let me launch SQL2000 again to "repair".
Gary L. Chefetz said:Al:
When you say "The user I am trying to create the cube with is" you mean
that this is the account you used to for the COM+ identity? Please
confirm.
If so, the next thing we'd to know is the setup of your system. For the
moment, I'm going to assume that your SQL Analysis Services is not
running on the same box as Project Server. If this supposition is
correct, I'd make sure that SQL Server SP3.a has been applied to both the
machine running SQL and Analysis Services as well as the machine running
Project Server.
al said:I will try to be a little more lucid in my detail.
The user I am trying to create the cube with is:
a) a member of the Admin and OLAP Admin group on the Project server
b) a member of the Admin and OLAP Admin group on the SQL server
c) a member of the Admin group in Project (as a User)
d) a Domain Admin
PSComPlus.exe has been run, and tells me "Microsoft Project Server
components are now running in Com+".
The Analysis Services Repository was migrated at setup, and the
ProjAdmin user is Admin on the server, so he (presumably) can write
anywhere.
I am trying to create the cube as the ProjAdmin user from the Project
Server.
Here are the specific errors I get:
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Date: 4/4/2005
Time: 10:36:25 AM
User: SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>
Date: 4/4/2005
Time: 10:36:25 AM
User: Biznet-1\SQLAdmin
Computer: APW3KS05
Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Unable to connect to the registry on the server (DBSRVSQL2K),
or you are not a member of the OLAP Administrators group on this
server.' Error Number : '-2147221455]]></Description>
I have worked through the "OLAP cube generation may not be successful in
MS PWA" posting, and this is MS Project Server 2003.
Any guidance?
"Gary L. Chefetz [MVP]" <gary AT chefetz DOT org> wrote in message
What do you mean by "getting my user permissions corrected?" It
certainly doesn't sound like it.