Christophe Fiessinger's Blog Updates on Microsoft's Enterprise Social Networking (ESN) and Project Portfolio Management (PPM) offerings
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>
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
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:
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!
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