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-09-25 : 06:46:22
|
| Hi SQL TEAMI'm trying to setup the followingProject Server 2007 and Analysis ServerIn Project Server Web Access under server setting and then Building setting after completing the form -Analysis Services Server-Analysis Services Database to be created-Extranet URL [Left this blank not to sure what goes in there.]Then i click on Save and Build i get the following error.Can someone please assist?Please note Analysis Server has been started.===== Initiating cube build process =====[2007/09/25 12:40 PM] Cube build request message has been added to the Project Server queue===== Verifying and running pre-build server event handler =====[2007/09/25 12:40 PM] Verifying and running pre-build server event handler===== Determining database and cube structure =====[2007/09/25 12:40 PM] Cube build initialization started[2007/09/25 12:40 PM] OLAP database and cube structure was determined successfully===== Building database and cubes =====[2007/09/25 12:40 PM] Cube build session started[2007/09/25 12:40 PM] Analysis Services session started[2007/09/25 12:40 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server IGSP1. 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 =====[2007/09/25 12:40 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server IGSP1. 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). |
|
|
|
|
|
Projects 2007 And Analysis Server