Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2007-12-06 : 06:33:39
|
| Hi there SQL TEAMIm trying to build a cube in Project Web Access and this is the error i get, can someone please tell me what they are talking about.I found the msmdsrv.ini the contents of this files with regards to DSO is as follows.Please see error at the end of the post////////////////////<DSO><RepositoryConnectionString>[EncryptedDataStart]CAAAAAAAAADkhKAINXyYXHtK8jZaGCxdslVyekePRZ4exuoHDxAwqzIuEHQFO6NkPO6HdCjrKwGJ dPGsfxoFqsQKtjSOKwXK9Ed2rUqYzqOpr5fF2f1RT3l/6IxU/C2qcXcmk+we9BZK84dj8fuxo7AV KaHModnORXoYCYa8spgLPrID/Vop9lp1N8UMaK5Bf4ILkzXRKGNGZkwpVBLfUeIUEzfaeOk3i6aS 1+DFnfKVUJw25yfLKCp2esMUZlep9ul2zCWa8PfIpeyrSW+M+Zc2cNe+303H8EYj24Omu4LUtcXQ lVRKXiFH+G3SbnApylSCOFSCm4TvHzEZL4JHt7Akr3UsDpA1rjBwkipMggZdcQ/JChgd5U1EkUp2 RgTgRguLb9cmmZUNb37t+T4Spg== [EncryptedDataEnd]</RepositoryConnectionString><RemoteRepositoryConnectionString>[EncryptedDataStart]CAAAAAAAAABkiZl3D5F0J54njPPwQnqm [EncryptedDataEnd]</RemoteRepositoryConnectionString><RemoteLocksDirectory/><LocksDirectory/></DSO>////////////////////===== Initiating cube build process =====[12/6/2007 1:20 PM] Cube build request message has been added to the Project Server queue===== Verifying and running pre-build server event handler =====[12/6/2007 1:21 PM] Verifying and running pre-build server event handler===== Determining database and cube structure =====[12/6/2007 1:21 PM] Cube build initialization started[12/6/2007 1:21 PM] OLAP database and cube structure was determined successfully===== Building database and cubes =====[12/6/2007 1:21 PM] Cube build session started[12/6/2007 1:21 PM] Analysis Services session started[12/6/2007 1:21 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server 192.168.1.3. 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).===== Process Completed =====[12/6/2007 1:21 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server 192.168.1.3. 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). |
|
|
|
|
|
Configure DSO