Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

===== Initiating cube build process =====
[8/21/2007 12:45 PM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[8/21/2007 12:45 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/21/2007 12:45 PM] Cube build initialization started
[8/21/2007 12:45 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[8/21/2007 12:45 PM] Cube build session started
[8/21/2007 12:45 PM] Analysis Services session started
[8/21/2007 12:45 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[8/21/2007 12:45 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:

-

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

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="159956a3-840b-84af-9b29-dccf8649c22c" QueueMessageBody="Setting UID=00007829-4392-84b3-b533-5a5a4977e3c9 ASServerName=sql2005 ASDBName=ProjectServer_Repository ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/21/2007 12:28:15 ToDate=08/21/2007 12:28:15 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server. &#xD;&#xA; &#xD;&#xA;Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="cd4cb275-d48f-4a1e-bf43-0a3ccccd629a" JobUID="b4c3228f-97c1-5c39-9606-d32bbc423198" ComputerName="PROJECT" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

I have the same issue and have also went through the Microsoft configuration, step-by-step “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service”. http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true

My error displays as:

===== Process Completed ============================================

[8/21/2007 11:01 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server MYSERVERNAME Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

This problem was killing us as well, we followed all of the Microsoft documentation and nothing worked till this morning. You have to set the DSO\RemoteLocksDirectory value on the analysis server to \\yourserver\MSOlapRepository$\ and it should go. We spent hours trying every which way going as far as giving everyone permission to everything. Once I set this it went all the way. The document that gave me the hint is the following:

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

Today I found the cause of the problem we were having. The account we were using for the SSP had limited privileges on the domain. I replaced the SSP account with an elevated account, re-tested the OLAP and the build was successful.

|||

Help! I've given my SSP account every permission under the sun. (domain admin, local domain admin, analysis services repository db_owner, sql server db admin. Can you specify a) how to check to see that it is indeed the SSP account that is failing to access the server and b) what are the elevated permissions to give this user to get the cube to build?

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

One difference I noticed was, when the OLAP build was failing, the account being used for SSP was a “Domain User” level account that I had added to the local administrators group on both the SQL and Applications servers. When I changed the SSP account, I changed it to a “Domain Admin” account. This user was not added to the local admins group on the servers, because the “Domain Admin” group was already a member of the administrators group on both servers since they are members of the domain.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Analysis Services session failed with the following error: Failed to delete the Olap database: EPM2007_2. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Second time, it works fine (nothing changed in any settings, just re-build again)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

===== Initiating cube build process =====
[8/21/2007 12:45 PM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[8/21/2007 12:45 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/21/2007 12:45 PM] Cube build initialization started
[8/21/2007 12:45 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[8/21/2007 12:45 PM] Cube build session started
[8/21/2007 12:45 PM] Analysis Services session started
[8/21/2007 12:45 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[8/21/2007 12:45 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:

-

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

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="159956a3-840b-84af-9b29-dccf8649c22c" QueueMessageBody="Setting UID=00007829-4392-84b3-b533-5a5a4977e3c9 ASServerName=sql2005 ASDBName=ProjectServer_Repository ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/21/2007 12:28:15 ToDate=08/21/2007 12:28:15 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server. &#xD;&#xA; &#xD;&#xA;Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="cd4cb275-d48f-4a1e-bf43-0a3ccccd629a" JobUID="b4c3228f-97c1-5c39-9606-d32bbc423198" ComputerName="PROJECT" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

I have the same issue and have also went through the Microsoft configuration, step-by-step “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service”. http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true

My error displays as:

===== Process Completed ============================================

[8/21/2007 11:01 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server MYSERVERNAME Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

This problem was killing us as well, we followed all of the Microsoft documentation and nothing worked till this morning. You have to set the DSO\RemoteLocksDirectory value on the analysis server to \\yourserver\MSOlapRepository$\ and it should go. We spent hours trying every which way going as far as giving everyone permission to everything. Once I set this it went all the way. The document that gave me the hint is the following:

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

Today I found the cause of the problem we were having. The account we were using for the SSP had limited privileges on the domain. I replaced the SSP account with an elevated account, re-tested the OLAP and the build was successful.

|||

Help! I've given my SSP account every permission under the sun. (domain admin, local domain admin, analysis services repository db_owner, sql server db admin. Can you specify a) how to check to see that it is indeed the SSP account that is failing to access the server and b) what are the elevated permissions to give this user to get the cube to build?

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

One difference I noticed was, when the OLAP build was failing, the account being used for SSP was a “Domain User” level account that I had added to the local administrators group on both the SQL and Applications servers. When I changed the SSP account, I changed it to a “Domain Admin” account. This user was not added to the local admins group on the servers, because the “Domain Admin” group was already a member of the administrators group on both servers since they are members of the domain.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Analysis Services session failed with the following error: Failed to delete the Olap database: EPM2007_2. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Second time, it works fine (nothing changed in any settings, just re-build again)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

===== Initiating cube build process =====
[8/21/2007 12:45 PM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[8/21/2007 12:45 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/21/2007 12:45 PM] Cube build initialization started
[8/21/2007 12:45 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[8/21/2007 12:45 PM] Cube build session started
[8/21/2007 12:45 PM] Analysis Services session started
[8/21/2007 12:45 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[8/21/2007 12:45 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:

-

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

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="159956a3-840b-84af-9b29-dccf8649c22c" QueueMessageBody="Setting UID=00007829-4392-84b3-b533-5a5a4977e3c9 ASServerName=sql2005 ASDBName=ProjectServer_Repository ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/21/2007 12:28:15 ToDate=08/21/2007 12:28:15 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server. &#xD;&#xA; &#xD;&#xA;Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="cd4cb275-d48f-4a1e-bf43-0a3ccccd629a" JobUID="b4c3228f-97c1-5c39-9606-d32bbc423198" ComputerName="PROJECT" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

I have the same issue and have also went through the Microsoft configuration, step-by-step “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service”. http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true

My error displays as:

===== Process Completed ============================================

[8/21/2007 11:01 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server MYSERVERNAME Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

This problem was killing us as well, we followed all of the Microsoft documentation and nothing worked till this morning. You have to set the DSO\RemoteLocksDirectory value on the analysis server to \\yourserver\MSOlapRepository$\ and it should go. We spent hours trying every which way going as far as giving everyone permission to everything. Once I set this it went all the way. The document that gave me the hint is the following:

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

Today I found the cause of the problem we were having. The account we were using for the SSP had limited privileges on the domain. I replaced the SSP account with an elevated account, re-tested the OLAP and the build was successful.

|||

Help! I've given my SSP account every permission under the sun. (domain admin, local domain admin, analysis services repository db_owner, sql server db admin. Can you specify a) how to check to see that it is indeed the SSP account that is failing to access the server and b) what are the elevated permissions to give this user to get the cube to build?

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

One difference I noticed was, when the OLAP build was failing, the account being used for SSP was a “Domain User” level account that I had added to the local administrators group on both the SQL and Applications servers. When I changed the SSP account, I changed it to a “Domain Admin” account. This user was not added to the local admins group on the servers, because the “Domain Admin” group was already a member of the administrators group on both servers since they are members of the domain.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Analysis Services session failed with the following error: Failed to delete the Olap database: EPM2007_2. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Second time, it works fine (nothing changed in any settings, just re-build again)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

===== Initiating cube build process =====
[8/21/2007 12:45 PM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[8/21/2007 12:45 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/21/2007 12:45 PM] Cube build initialization started
[8/21/2007 12:45 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[8/21/2007 12:45 PM] Cube build session started
[8/21/2007 12:45 PM] Analysis Services session started
[8/21/2007 12:45 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[8/21/2007 12:45 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:

-

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

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="159956a3-840b-84af-9b29-dccf8649c22c" QueueMessageBody="Setting UID=00007829-4392-84b3-b533-5a5a4977e3c9 ASServerName=sql2005 ASDBName=ProjectServer_Repository ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/21/2007 12:28:15 ToDate=08/21/2007 12:28:15 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server. &#xD;&#xA; &#xD;&#xA;Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="cd4cb275-d48f-4a1e-bf43-0a3ccccd629a" JobUID="b4c3228f-97c1-5c39-9606-d32bbc423198" ComputerName="PROJECT" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

I have the same issue and have also went through the Microsoft configuration, step-by-step “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service”. http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true

My error displays as:

===== Process Completed ============================================

[8/21/2007 11:01 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server MYSERVERNAME Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

This problem was killing us as well, we followed all of the Microsoft documentation and nothing worked till this morning. You have to set the DSO\RemoteLocksDirectory value on the analysis server to \\yourserver\MSOlapRepository$\ and it should go. We spent hours trying every which way going as far as giving everyone permission to everything. Once I set this it went all the way. The document that gave me the hint is the following:

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

Today I found the cause of the problem we were having. The account we were using for the SSP had limited privileges on the domain. I replaced the SSP account with an elevated account, re-tested the OLAP and the build was successful.

|||

Help! I've given my SSP account every permission under the sun. (domain admin, local domain admin, analysis services repository db_owner, sql server db admin. Can you specify a) how to check to see that it is indeed the SSP account that is failing to access the server and b) what are the elevated permissions to give this user to get the cube to build?

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

One difference I noticed was, when the OLAP build was failing, the account being used for SSP was a “Domain User” level account that I had added to the local administrators group on both the SQL and Applications servers. When I changed the SSP account, I changed it to a “Domain Admin” account. This user was not added to the local admins group on the servers, because the “Domain Admin” group was already a member of the administrators group on both servers since they are members of the domain.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Analysis Services session failed with the following error: Failed to delete the Olap database: EPM2007_2. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Second time, it works fine (nothing changed in any settings, just re-build again)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

===== Initiating cube build process =====
[8/21/2007 12:45 PM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[8/21/2007 12:45 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/21/2007 12:45 PM] Cube build initialization started
[8/21/2007 12:45 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[8/21/2007 12:45 PM] Cube build session started
[8/21/2007 12:45 PM] Analysis Services session started
[8/21/2007 12:45 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[8/21/2007 12:45 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:

-

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

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="159956a3-840b-84af-9b29-dccf8649c22c" QueueMessageBody="Setting UID=00007829-4392-84b3-b533-5a5a4977e3c9 ASServerName=sql2005 ASDBName=ProjectServer_Repository ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/21/2007 12:28:15 ToDate=08/21/2007 12:28:15 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server. &#xD;&#xA; &#xD;&#xA;Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="cd4cb275-d48f-4a1e-bf43-0a3ccccd629a" JobUID="b4c3228f-97c1-5c39-9606-d32bbc423198" ComputerName="PROJECT" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

I have the same issue and have also went through the Microsoft configuration, step-by-step “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service”. http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true

My error displays as:

===== Process Completed ============================================

[8/21/2007 11:01 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server MYSERVERNAME Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

This problem was killing us as well, we followed all of the Microsoft documentation and nothing worked till this morning. You have to set the DSO\RemoteLocksDirectory value on the analysis server to \\yourserver\MSOlapRepository$\ and it should go. We spent hours trying every which way going as far as giving everyone permission to everything. Once I set this it went all the way. The document that gave me the hint is the following:

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

Today I found the cause of the problem we were having. The account we were using for the SSP had limited privileges on the domain. I replaced the SSP account with an elevated account, re-tested the OLAP and the build was successful.

|||

Help! I've given my SSP account every permission under the sun. (domain admin, local domain admin, analysis services repository db_owner, sql server db admin. Can you specify a) how to check to see that it is indeed the SSP account that is failing to access the server and b) what are the elevated permissions to give this user to get the cube to build?

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

One difference I noticed was, when the OLAP build was failing, the account being used for SSP was a “Domain User” level account that I had added to the local administrators group on both the SQL and Applications servers. When I changed the SSP account, I changed it to a “Domain Admin” account. This user was not added to the local admins group on the servers, because the “Domain Admin” group was already a member of the administrators group on both servers since they are members of the domain.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Analysis Services session failed with the following error: Failed to delete the Olap database: EPM2007_2. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Second time, it works fine (nothing changed in any settings, just re-build again)

Programmatically create a Report Model

Hello,

What we'd like to do is programmatically generate and maintain a report model based on how the individual install is configured. I've found some documentation that makes me believe this is possible, but I'm hoping someone can nudge me in the right direction. The ReportingServices2005 class has several model related methods (CreateModel) and I found the .xsd for the semantic model XML file
(http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
but no real documentation on how to put together a Report Model document from scratch. Looking at the files generated from BIDS is somewhat overwhelming and I have no idea where I'd pull most of the information.

Finally, I want to create Report Model(.smdl) file without Report Model Designer.

I want to Implement CreateModel Method to create new model, any source code sample..?

Any help that can be provided would be greatly appreciated. Thanks!

Sandip.

I am not positive but I don't think that the CreateModel method is for what you think it is for. I think it is for creating an instance of the model, uploading it to a ReportServer. IOW you read in an SMDL file and push it to a server, update it -- various management purposes.

Or I could be looking at a different part of the RS API than you are, and you could be right <s>.

IAC, fond as I am of reading schemas and creating XML files from scratch, this one is tough because of all the guids. Probably your best bet would be to start with a basic one and add nodes into it based on the privileges and configuration for an individual install or user, for example adjust the data sources or adding some fields.

>L<

|||

How can I update report models in the report server programmatically?

I was able to publish report models from one server to another using .rss file. I used the method ".createmodel". However, this doesn't have the overwrite parameter unlike ".createreport" method.

Is there a way or command to do this?

Any help would be greatly appreciated(",). Thanks.|||

To start with, I should say that I'm not clear enough about models to understand why you think there are associated parameters. I don't understand the connection, I'm not that familiar with models and didn't think they had parameters.

IAC, yes there is some scripting associated with models and the best advice I can give you is to become familiar with the scripting utilitiy you'll find here: http://www.sqldbatips.com/showarticle.asp?ID=62 It will interrogate your reporting services server and generate scripts for you (including models). And you will learn a lot from what it shows. There is an example of the script it generates here: http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_script_model

>L<

|||

Lisa,

Thanks. Actually, I was able to find the answer on the same site you've given me( http://www.sqldbatips.com/showarticle.asp?ID=62 ) ...

I downloaded the scripter, run rsscripter.exe, on the scripting options>data/model, i checked update existing model and generate the script. On the generated script, I noticed that they have used .SetModelDefinition method to do this. So, to sum up:

.SetModelDefinition - used to update report models in the report server

.CreateReport - used to create/add report models in the report server

Thanks again