Trial versions of Project Professional and Server 2007 are live (updated)

The Office Project Server 2007 & Office Project Professional 2007 Trials are now live. You can begin the experience at: http://www.microsoft.com/technet/prodtechnol/eval/default.mspx   Upon completion of this experience, you will have downloaded CD images and received product keys for each product.  You will need to expand the images using the CD burning software of your choice…

0

MOSS: White paper: Data protection and recovery for Office SharePoint Server in small to medium deployments

  A very good white paper has just been updated on Office Technet for MOSS:  Data protection and recovery for Office SharePoint Server in small to medium deployments http://go.microsoft.com/fwlink/?LinkId=102839&clcid=0x409  See also Brian’s blog article http://blogs.msdn.com/brismith/archive/2007/10/24/backup-and-restore-what-are-the-options.aspx Updated in June 2008: Now covers Farms of any size.

1

How to programmatically create a project server account (or profile) for Microsoft Office Project Professional (2003 or 2007)

If you don’t want to manually create your project server account for Microsoft Office Project Professional (2003 or 2007) , you can use the following VBscript code. You need to run this script in the context of the user: Option Explicit Dim ProjObj Set ProjObj = CreateObject(“msproject.application“) if ProjObj.Profiles.Count = 1 Then   ProjObj.Profiles.add “Production…

1

Moving the SharePoint Databases to a new SQL server instance

(Updated 20071004) Well, you just have a brand new database server and you need to move all the databases from your old SQL server to the new SQL server. This is what I did to change the SQL server instance of an existing EPM farm. You cannot just backup and restore (or detach it) the databases….

6

Configuring Data Analysis Views in an extranet configuration (updated)

You want to configure Data analysis Views in an extranet configuration. Here are the steps I did: Configure HTTP access to SSAS following the description given here: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx  This installation needs to done on the web server, configure http and/or https. Assume the server name is mywebserver.contoso.com and the virtual directory name is olap The…

5

Adding a new SSP Admin account to manage the SSP features

What happens when the person who installed and configured your MOSS or EPM solution is not there, and you need to access the SSP admin pages ?You get an access error.  By default only the setup account that was used to create the SSP (also know as farms’s shared service), is allowed to access the…

0

Controlling your admin content database name (or avoiding having a GUID in its name)

I am often asked, how to control the name of the admin content databases when you install and configure Project Server 2007 or MOSS. The databases are not automatically created when you install the product. The installation just install the binaries. You then need to configure the product using the SharePoint Products and Technologies Configuration…

1

Why use SQL 2005 SP2 with Project Server 2007: Reporting Services Add-in

The SQL 2005 SP2 has just been out for a couple of weeks now.. It brings a nice new feature in terms of reporting: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies:http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en With this add-in you can can use its Report Viewer Web Part that provides report viewing capability, export to other rendering…

0

Forcing uninstallation of Project Server 2007 or MOSS 2007

On a new server installation of MOSS 2007 and Project Server 2007 together, I had a problem applying KB 932091, update to WSS 3.0. My system was rebooted (by mistake) before the update was finished. After that the system was unstable: I could not run the SharePoint Products and Technologies Configuration Wizard (Upgrade in progress). I…

3

Dealing with connection problems to Analysis Services 2005

This article will discuss some of the connection problems you can have when using Analysis Services 2005. There are several cases to consider: Building the cube on a single box installation versus multi box configuration (check Accessing the cube For fixing building problem (CBS): check Christophe’s blog http://blogs.msdn.com/chrisfie/archive/tags/SQL+Analysis+Services+2005/default.aspx and Brian’s blog http://blogs.msdn.com/brismith/archive/tags/Analysis+Services/default.aspx Also don’t forget in…

0