Project Server 2010 uses Excel Services as the primary reporting technology, this post gives an overview on how users authenticate to each data source along with the errors seen if users / accounts don’t have access. There are two different data sources by default, the Reporting database and the OLAP Cube. Authentication In Excel Client... Continue Reading →
Error relinking Project Site to Project in #ProjectServer 2010 #PS2010 #Project #EPM
Do you receive the error below when trying to relink a Project Site to Project in PWA > Server Settings > Project Sites? The Web Site does not exist or is not configured for Project Server. Enter a Web Site that has been extended with a Project Server compatible template. You will normally run into... Continue Reading →
How to check the SharePoint 2010 and Project Server 2010 service pack / patch level #PS2010 #ProjectServer #SharePoint #SP2010
This article will show how to check the farm version for SharePoint Foundation 2010, SharePoint Server 2010 and Project Server 2010. The farm patch level can be check in the Central Administration site, click “Upgrade and Migration” then “Check Product and Patch Installation Status” The patch level of all farm components will be detailed here,... Continue Reading →
SQL Alias vs DNS Alias for Project Server 2010 install #PS2010 #EPM #ProjectServer
When installing Project Server 2010 it is always best practice to use an alias name for the SQL server as this makes life easier should you want to move SQL servers at a later date. This raises the question, SQL alias (using SQL cliconfg utility – pic below) or a network DNS Alias name (CNAME... Continue Reading →
Project Server 2007 / 2010 scheduled tasks not running #PS2010 #ProjectServer #EPM #PS2007
Scheduled jobs such as the daily scheduled backup in project server not running but work when you run them manually? I have seen this at many clients and the resolution is usually simple. All of the scheduled jobs in Project Server 2007 / 2010 run from a SharePoint Timer Job, if you look in Central... Continue Reading →
Project Server 2010 Database Maintenance Plans #EPM #PS2010 #ProjectServer
Just a quick post to mention that Microsoft have now released documentation on the recommended SQL server database maintenance plans for Project Server 2010. SQL Server database plans are very important in keeping Project Server performing reliably and smoothly. Please see the link below for more information: http://technet.microsoft.com/en-us/library/cc973097.aspx
Office 2010 / SharePoint 2010 / Project Server 2010 Service Pack 1 (SP1) #SP2010 #SharePoint #ProjectServer
Service Pack 1 for the Office 2010 products is now available, for information please see: http://blogs.technet.com/b/office_sustained_engineering/archive/2011/06/28/announcing-office-2010-and-sharepoint-2010-service-pack-1-availability.aspx The link to the Project Server 2010 KB article is: http://support.microsoft.com/kb/2460047 The link to the download is: http://www.microsoft.com/download/en/details.aspx?id=26636 As always, deploy this to a Test / Development environment and test thoroughly before applying to Production, also have a full... Continue Reading →
Project Server 2010 Project Site default fields #ProjectServer #PS2010
Getting synch errors in the Project Queue relating the Reporting WSS sync? Link to task functionality not working? Risks and issues not showing in the reminders web part on the PWA home page? If you have any of these issues then it is quite likely that you have either edited or deleted some of the... Continue Reading →
Project Server 2010 Grid issue
I would just like to share my findings with the behaviour of the Project Server 2010 grids. I was recently investigating an issue raised on one of the Project Server forums and thought I would blog the issue and workaround in case anyone comes across this in future. The issue is that the header rows... Continue Reading →