December, 2006

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

  • Christophe Fiessinger's Blog

    How to change an Administrator password on your Project Server 2007 Farm?

    Thanks to a colleague of mine, here is how to do it using STSADM (all the PS 2007 Service Accounts were using the same account):

    1.     Change the account password

    2.     Open a command line prompt (Start -> Run -> cmd)

    3.     Change directory wherever STSADM has been installed, typically:

     

    Ø  cd "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN"

     

    4.     Execute the following two command:

     

    Ø  stsadm -o updatefarmcredentials -userlogin DOMAIN\user -password NEWPASSWORD

     

    Ø  stsadm -o updateaccountpassword -userlogin DOMAIN\USER -password NEWPASSWORD –noadmin

     

    Ø  IISRESET

     

    5.     Reboot the server

  • Christophe Fiessinger's Blog

    Configuring a SQL 2005 Analysis Repository for DSO9 instead of an Access MDB

    The standard procedure to configure (KB 921116) the Cube Building Services (Analysis Services 2005) for Project Server is to copy the Msmdrep.mdb file on a network share.

    ¾  Get a backup of a SQL 2000 AS Repository database (you can use the migration wizard within AS 2000 to create one) or download the one below.

    ¾  Create a database in SQL Server 2005 and call it AS2000_Repository.

    ¾  Restore the database backup found in the link below to the AS2000_Repository database

    ¾  Locate the msmdsrv.ini file in C:\Program Files\Microsoft SQL Server\MSSQL.#\OLAP\Config (NOTE: MSSQL.# is the folder in which SQL Analysis Services 2005 files are installed)

    ¾  Modify the <DSO> section of the msmdsrv.ini to (NOTE: Each XML item should be on a single line):

    <DSO>
    <RemoteRepositoryConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=SERVERNAME;Initial Catalog=AS2000_Repository;</RemoteRepositoryConnectionString>
    <RepositoryConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=SERVERNAME;Initial Catalog=AS2000_Repository;</RepositoryConnectionString>
    <RemoteLocksDirectory/>
    <LocksDirectory/>
    </DSO>

    That's it!

  • Christophe Fiessinger's Blog

    How to disable logging in Windows Sharepoint Services V3

    WSS V3 out of the box has extensive logging activity, Logs can be usually found in this directory and tend to grow significantly over time:   C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS

    If you are running WSS V3 in a developement environement or in a VPC and want to optimize resources, you can disable logging activity by doing the following:

    • Go to WSS V3 Central Administration -> Operations -> Logging and Reporting
    • Click on Diagnostic Logging
      1. Customer Experience Improvement Program: select No, I don't wish to participate
      2. Error Reports: select Ignore errors and don't collect information.
      3. Trace log: clear the entire Path.
      4. Click OK
    • Click on Usage Analysis Processing
      1. Uncheck Enable logging
      2. Click OK
    • Click on Information Management Policy Usage Reports
      1. Uncheck Enable recurring policy usage reports

    Please remember that once you have disabled logging it will be impossible to troubleshoot any PS nor WSS errors. This is not a recommended setting for any production system!

    • Christophe Fiessinger's Blog

      Configuring Project Server 2007 with SQL Server Analysis Services 2005

      When you use SQL Server 2005 Analysis Services (please note you need to apply SP1), you'll have to follow the procedure described in this KB to configure the "cube refresh": http://support.microsoft.com/default.aspx/kb/921116/en-us

    • Christophe Fiessinger's Blog

      WSS V3 MOM Pack is available for download.

      Here: Microsoft Windows SharePoint Services 3.0 Management Pack for Microsoft Operations Manager 2005 .
    • Christophe Fiessinger's Blog

      Project Server & Professional 2007 are available for download on MSDN

      1. Login using your MSDN passport account
      2. Click on Subscriber Downloads & Product Key
      3. For Project Professional 2007: Applications -> Project -> Project 2007 (about 192MB ISO-9660 CD Image file)
      4. For Project Server 2007: Servers -> Project Server 2007 (about 323MB ISO-9660 CD Image file)
    Page 1 of 1 (6 items)