Cube building in MPP Server 2007 Standalone

[Muthukkumaran]

I have installed MPP server 2007 standalone version. I tried to configure
Data analysis. Unable to build a cube and get following error

===== Initiating cube build process =====
[4/18/2009 4:12 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[4/18/2009 4:13 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[4/18/2009 4:13 PM] Cube build initialization started
[4/18/2009 4:13 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[4/18/2009 4:13 PM] Cube build session started
[4/18/2009 4:13 PM] Analysis Services session started
[4/18/2009 4:13 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server PROJECTSERVER.
Error: A connection cannot be made. Ensure that the server is running.
===== Process Completed =====
[4/18/2009 4:13 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server PROJECTSERVER. Error: A connection cannot be made. Ensure
that the server is running.


I tried install following services on my server where i installed project
server.
sqlncli.msi
SQLServer2005_XMO.msi
SQLServer2005_BC.msi

But still I could not build the cube. MPP Standalone version installs SQL
Server2005 Exprerss as database. I found the SQL server express edtion does
not support Analysis service.

Is there any way to configure MPP server satanalone with SQL server 2005
standard or other editions?

Any help would be appreciated

 

[ProjmanZA]

I have installed MPP server 2007 standalone version. I tried to configure
Data analysis. Unable to build a cube and get following error

===== Initiating cube build process =====
[4/18/2009 4:12 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[4/18/2009 4:13 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[4/18/2009 4:13 PM] Cube build initialization started
[4/18/2009 4:13 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[4/18/2009 4:13 PM] Cube build session started
[4/18/2009 4:13 PM] Analysis Services session started
[4/18/2009 4:13 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server PROJECTSERVER.
Error: A connection cannot be made. Ensure that the server is running.
===== Process Completed =====
[4/18/2009 4:13 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server PROJECTSERVER. Error: A connection cannot be made. Ensure
that the server is running.

I tried install following services on my server where i installed project
server.
sqlncli.msi
SQLServer2005_XMO.msi
SQLServer2005_BC.msi

But still I could not  build the cube. MPP Standalone version installs SQL
Server2005 Exprerss as database. I found the SQL server express edtion does
not support Analysis service.

Is there any way to configure MPP server satanalone with SQL server 2005
standard or other editions?

Any help would be appreciated

Hey there ,

Should work .... you sure you configured the database as needed in
analysis server ? Did you complete the DSO objects ? Did you specify
the correct server to build ??

Andre

 

[Muthukkumaran]

Thanks Anre, for the reply.

I installed all three components required for DSO

Microsoft SQL Server Native Client (sqlncli.msi)

Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)

Microsoft SQL Server 2005 Backward Compatibility Components
(SQLServer2005_BC.msi)

But My server shows no analysis service running.

I don't know how to install analysis server on SLQ Server Express Edition.

Also, I could configure the OLAP users group
as SQLServer2005MSOLAPUser$<SERVERNAME>$MSSQLSERVER user group not there
in my server.

any help!

Thanks
Muthukkumaran

I have installed MPP server 2007 standalone version. I tried to configure
Data analysis. Unable to build a cube and get following error

===== Initiating cube build process =====
[4/18/2009 4:12 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[4/18/2009 4:13 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[4/18/2009 4:13 PM] Cube build initialization started
[4/18/2009 4:13 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[4/18/2009 4:13 PM] Cube build session started
[4/18/2009 4:13 PM] Analysis Services session started
[4/18/2009 4:13 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server PROJECTSERVER.
Error: A connection cannot be made. Ensure that the server is running.
===== Process Completed =====
[4/18/2009 4:13 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server PROJECTSERVER. Error: A connection cannot be made. Ensure
that the server is running.

I tried install following services on my server where i installed project
server.
sqlncli.msi
SQLServer2005_XMO.msi
SQLServer2005_BC.msi

But still I could not build the cube. MPP Standalone version installs SQL
Server2005 Exprerss as database. I found the SQL server express edtion does
not support Analysis service.

Is there any way to configure MPP server satanalone with SQL server 2005
standard or other editions?

Any help would be appreciated

Hey there ,

Should work .... you sure you configured the database as needed in
analysis server ? Did you complete the DSO objects ? Did you specify
the correct server to build ??

Andre

 

[Gary L. Chefetz]

Muthukkumaran:

SQL Express edition does not support Analysis Services. You must upgrade to
the SQL standard edition.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

Thanks Anre, for the reply.

I installed all three components required for DSO

Microsoft SQL Server Native Client (sqlncli.msi)

Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)

Microsoft SQL Server 2005 Backward Compatibility Components
(SQLServer2005_BC.msi)

But My server shows no analysis service running.

I don't know how to install analysis server on SLQ Server Express Edition.

Also, I could configure the OLAP users group
as SQLServer2005MSOLAPUser$<SERVERNAME>$MSSQLSERVER user group not there
in my server.

any help!

Thanks
Muthukkumaran

I have installed MPP server 2007 standalone version. I tried to
configure
Data analysis. Unable to build a cube and get following error

===== Initiating cube build process =====
[4/18/2009 4:12 PM] Cube build request message has been added to the
Project
Server queue
===== Verifying and running pre-build server event handler =====
[4/18/2009 4:13 PM] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[4/18/2009 4:13 PM] Cube build initialization started
[4/18/2009 4:13 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[4/18/2009 4:13 PM] Cube build session started
[4/18/2009 4:13 PM] Analysis Services session started
[4/18/2009 4:13 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server PROJECTSERVER.
Error: A connection cannot be made. Ensure that the server is running.
===== Process Completed =====
[4/18/2009 4:13 PM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to connect to the
Analysis
Services server PROJECTSERVER. Error: A connection cannot be made.
Ensure
that the server is running.

I tried install following services on my server where i installed
project
server.
sqlncli.msi
SQLServer2005_XMO.msi
SQLServer2005_BC.msi

But still I could not build the cube. MPP Standalone version installs
SQL
Server2005 Exprerss as database. I found the SQL server express edtion
does
not support Analysis service.

Is there any way to configure MPP server satanalone with SQL server
2005
standard or other editions?

Any help would be appreciated

Hey there ,

Should work .... you sure you configured the database as needed in
analysis server ? Did you complete the DSO objects ? Did you specify
the correct server to build ??

Andre

 

[ProjmanZA]

Muthukkumaran:

SQL Express edition does not support Analysis Services. You must upgrade to
the SQL standard edition.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting:http://www.msprojectexperts.com
Project Server Training:http://www.projectservertraining.com
Project Server FAQS:http://www.projectserverexperts.com
Project Server Help Blog:http://www.projectserverhelp.com

Thanks Anre, for the reply.

I installed all three components required for DSO

Microsoft SQL Server Native Client (sqlncli.msi)

Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)

Microsoft SQL Server 2005 Backward Compatibility Components
(SQLServer2005_BC.msi)

But My server shows no analysis service running.

I don't know how to install analysis server on SLQ Server Express Edition.

Also, I could configure the OLAP users group
as  SQLServer2005MSOLAPUser$<SERVERNAME>$MSSQLSERVER user group  not there
in my server.

any help!

Thanks
Muthukkumaran

On Apr 18, 1:05 pm, Muthukkumaran
I have installed MPP server 2007 standalone version. I tried to
configure
Data analysis. Unable to build a cube and get following error
===== Initiating cube build process =====
[4/18/2009 4:12 PM] Cube build request message has been added to the
Project
Server queue
===== Verifying and running pre-build server event handler=====
[4/18/2009 4:13 PM] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[4/18/2009 4:13 PM] Cube build initialization started
[4/18/2009 4:13 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[4/18/2009 4:13 PM] Cube build session started
[4/18/2009 4:13 PM] Analysis Services session started
[4/18/2009 4:13 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server PROJECTSERVER.
Error: A connection cannot be made. Ensure that the server is running.
===== Process Completed =====
[4/18/2009 4:13 PM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to connect to the
Analysis
Services server PROJECTSERVER. Error: A connection cannot be made.
Ensure
that the server is running.
I tried install following services on my server where i installed
project
server.
sqlncli.msi
SQLServer2005_XMO.msi
SQLServer2005_BC.msi
But still I could not  build the cube. MPP Standalone version installs
SQL
Server2005 Exprerss as database. I found the SQL server express edtion
does
not support Analysis service.
Is there any way to configure MPP server satanalone with SQL server
2005
standard or other editions?
Any help would be appreciated
Hey there ,
Should work .... you sure you configured the database as needed in
analysis server ? Did you complete the DSO objects ? Did you specify
the correct server to build ??
Andre

Hi there ,

As Gary have mentioned SQL express wont work. If you have either SQL
Standard or enterprise follow these steps :

Create a new DB in SQL -- Call it something like OLAP.
Connect to your SQL analysis Server from within SQL.
Right click your Analysis server name and select properties
tick the box that says so Avanced / all properties.
Browse Down to the DSO\RepositoryConnectionString and select your SQL
server and then select the Olap Database from the list.
Browse to DSO\RemoteRepositoryConnectionString and repeat the steps
mentioned above.
Go to server settings on PWA -- Build settings under Cube
Configuration. Type in the ServerName and the Name of the Cube it
should Create in analysis Server.
Set your schedule and select Save and build now.

That Should work. For more detailed info see
http://technet.microsoft.com/en-us/library/cc197552.aspx

Thanks

Andre