K
Kevin
I am attempting to build the OLAP Cubes for the first time and failing. I
have several user accounts in play with MOSS and Project server 2007 for
security reasons. How do I know which user it is trying to use to execute
this job?
Failure Message:
Your CBSRequest job failed. Its current state is FailedNotBlocking. It was
0% complete. It entered the queue at 10/15/2008 23:00:02.
To get more information about the job failure, please go to Project Web
Access. Select Personal Settings from the left menu. Then select My Queued
Jobs.
The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000
Detailed error below - send it to the administrator for more detailed
troubleshooting.
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure"
uid="cf347b3b-d77a-4c16-a8dd-2724ed1856b3" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=DHRM-DEV-SQL
ASDBName=PRJ07Analysis ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=10/15/2008 16:35:36 ToDate=10/15/2008 16:35:36
HighPriority=False" Error="Analysis Services session failed with the
following error: Failed to connect to the Analysis Services server
DHRM-DEV-SQL. Error: Your permissions on the server computer do not allow you
to administer this Analysis server.
Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="bdc3cadb-f43a-4402-bf4c-0c10330076d3"
JobUID="68bc0565-fceb-4ee1-9545-20087b83bd20" ComputerName="DHRM-VMDEV-PRJ0"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>
System Info:
DEV-SQL server running SQL Server 2005 + latest SPs
• The SQL Server Analysis Services user is SQLServiceAgent. This user has
User Mappings for the reporting database = db_datareader
DEV-PRJ07 server running Project 2007 + MOSS 2007 + Server 2008
• Of the many users I’ve setup to get Project 2007 running, SQLServerAgent
is not one of them. How do I learn which user is being used to build the
cubes and what other authority I need to give?
• The Database user for this configuration is not SQLServiceAgent.
Thanks for the help.
have several user accounts in play with MOSS and Project server 2007 for
security reasons. How do I know which user it is trying to use to execute
this job?
Failure Message:
Your CBSRequest job failed. Its current state is FailedNotBlocking. It was
0% complete. It entered the queue at 10/15/2008 23:00:02.
To get more information about the job failure, please go to Project Web
Access. Select Personal Settings from the left menu. Then select My Queued
Jobs.
The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000
Detailed error below - send it to the administrator for more detailed
troubleshooting.
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure"
uid="cf347b3b-d77a-4c16-a8dd-2724ed1856b3" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=DHRM-DEV-SQL
ASDBName=PRJ07Analysis ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=10/15/2008 16:35:36 ToDate=10/15/2008 16:35:36
HighPriority=False" Error="Analysis Services session failed with the
following error: Failed to connect to the Analysis Services server
DHRM-DEV-SQL. Error: Your permissions on the server computer do not allow you
to administer this Analysis server.
Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="bdc3cadb-f43a-4402-bf4c-0c10330076d3"
JobUID="68bc0565-fceb-4ee1-9545-20087b83bd20" ComputerName="DHRM-VMDEV-PRJ0"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>
System Info:
DEV-SQL server running SQL Server 2005 + latest SPs
• The SQL Server Analysis Services user is SQLServiceAgent. This user has
User Mappings for the reporting database = db_datareader
DEV-PRJ07 server running Project 2007 + MOSS 2007 + Server 2008
• Of the many users I’ve setup to get Project 2007 running, SQLServerAgent
is not one of them. How do I learn which user is being used to build the
cubes and what other authority I need to give?
• The Database user for this configuration is not SQLServiceAgent.
Thanks for the help.