December, 2006

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!

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

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!

1. Go to http://msdn.microsoft.com/subscriptions/
2. Login using your MSDN passport account
3. Click on Subscriber Downloads & Product Key
4. For Project Professional 2007: Applications -> Project -> Project 2007 (about 192MB ISO-9660 CD Image file)
5. For Project Server 2007: Servers -> Project Server 2007 (about 323MB ISO-9660 CD Image file)

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