January, 2007

Christophe Fiessinger's Blog
Updates on Microsoft's Enterprise Social Networking (ESN) and Project Portfolio Management (PPM) offerings

  • Christophe Fiessinger's Blog

    Common mistakes when configuring the Cubes Building Service (CBS) with SQL Server Analysis Services 2005

    Prior to troubleshooting your Analysis Services 2005 configuration to "build" your Project Server Cubes, I'll assume you have read the following KB article: 921116 

    During the CBS you get the following error: "Error: ActiveX component can't create object"

    -> Install the following SQL Server 2005 SP1 components:
     
    1. Microsoft SQL Server Native Client (sqlncli.msi)
    2. Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi)
    3. Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi)

    DSO section in Analysis Services configuration file is malformed   

    The msmdsrv.ini is typically located in the following directory: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config, once you edit the file use a proper XML editor to ensure that are no carriage return; and no white space are present so that it's a properly formatted XML file.

    Ensure the proper sharing permissions have been set on the share DSO9 folder

    If you are using NTFS make sur both the user account used fot the CBS has been added to the Permission and the Security sections.

    N Tier Deployement

    If your EPM 2007 deployment contains multiple servers (front end with PWA and back end with SQL DB for instance) you'll have to use a domain account on the to configure the access the to AS repository. You'll also have to deploy the DSO components listed earlier on each from end server for it to communicate to the back end DB server.

    Ensure the account used to connect to the CBS has access to AS

     

  • Christophe Fiessinger's Blog

    Configuring load balanced PWA site

    1. Install and configure a WSS Farm on ServerA
    2. Add a second server (ServerB) to the WSS Farm created above
    3. Configure the load balancing using Windows LB for instance (or using a hardware device)
    4. Note the Virtual IP address configured in step 3
    5. Creat a new Web Application and under Load Balanced URL enter the adress from Step 4.
    6. Create Site Collection/SSP/PWA ... 
    7. That's it....

    If you change your mind about the load balanced URL, you can modify it afterward in the WSS Central Admin site: OperationsàAlternate Access Mapping link

    For more information on Network Load Balancing and Sharepoint please check this excellent post from Joe Oleson: NLB (Network Load Balancing) and SharePoint... Troubleshooting and Configuration tips

  • Christophe Fiessinger's Blog

    New Downloads of Office Project Server on MSDN (13 New!)

    13 new languages, 16 total languages are now available for MSDN subscribers. Both the x86 or x64 versions are included in the ISO download package (353MB).  

    1. Office Project Server 2007 (Arabic)
    2. Office Project Server 2007 (Dutch)
    3. Office Project Server 2007 (English)
    4. Office Project Server 2007 (French)
    5. Office Project Server 2007 (German)
    6. Office Project Server 2007 (Hebrew)
    7. Office Project Server 2007 (Italian)
    8. Office Project Server 2007 (Japanese)
    9. Office Project Server 2007 (Korean)
    10. Office Project Server 2007 (Polish)
    11. Office Project Server 2007 (Portuguese-Brazil)
    12. Office Project Server 2007 (Simplified Chinese)
    13. Office Project Server 2007 (Spanish)
    14. Office Project Server 2007 (Swedish)
    15. Office Project Server 2007 (Traditional Chinese)
  • Christophe Fiessinger's Blog

    Office Project Portfolio Server 2007 available on MSDN

    Available since January 4th, 25MB in size.
Page 1 of 1 (4 items)