Cube build process Keeps on failing

[TheWall]

Had a few issues with the cube build process but now back at the following
error:

===== Process Completed =====
[18/03/2008 10:12] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server ServerName. Error: The connection string to repository needs
to be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Any Ideas?

 

[Roberto Di Lello]

You must configurate the DSO properties from Analisys Services.
Log in in de analisis services console, edit properties, select advanced
features checkbox and configure the DSO properties.

Its about four items you must configure.

bye, Robert.

 

[Paul Conroy]

Checkout the following article for detailed instructions

http://technet.microsoft.com/en-us/library/cc303402.aspx

--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

You must configurate the DSO properties from Analisys Services.
Log in in de analisis services console, edit properties, select advanced
features checkbox and configure the DSO properties.

Its about four items you must configure.

bye, Robert.
--
Roberto Di''Lello | MCSE 2003 - MCSA Messaging 2003 | www.radians.com.ar

Had a few issues with the cube build process but now back at the following
error:

===== Process Completed =====
[18/03/2008 10:12] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server ServerName. Error: The connection string to repository needs
to be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Any Ideas?

 

[Dave808K]

We had a similar (possibly the same it was awhile ago) error. We had to set
the DSO\LocksDirectory and DSO\RemoteLocksDirectory to the hidden OLAP
repository directory (ours was \\SERVER\MsOLAPRepository2005$\). This is set
be right-clicking your analysis server name in the SQL Server Mangement
console and clicking properties. In the General section check "Show Advanced
(All) Properties" and you'll see both the DSO\LocksDirectory and
DSO\RemoteLocksDirectory.

 

[TheWall]

Great, thanks. Working

Quite a mission to configure but that link had all the info i needed

Checkout the following article for detailed instructions

http://technet.microsoft.com/en-us/library/cc303402.aspx

--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

You must configurate the DSO properties from Analisys Services.
Log in in de analisis services console, edit properties, select advanced
features checkbox and configure the DSO properties.

Its about four items you must configure.

bye, Robert.
--
Roberto Di''Lello | MCSE 2003 - MCSA Messaging 2003 | www.radians.com.ar

Had a few issues with the cube build process but now back at the following
error:

===== Process Completed =====
[18/03/2008 10:12] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server ServerName. Error: The connection string to repository needs
to be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Any Ideas?