1# Does Project Server 2010 support MS SQL Server 2005?
Answer: Yes, Project Server 2010 support only 64-Bit MS SQL. Database server must be either of the following: Microsoft SQL Server 2005 SP3 with Cumulative Update 3 (64-bit) · Microsoft SQL Server 2008 SP1 with Cumulative Update 2 (64-bit).
2# How to display RES_AVAILABILITY and RES_RATES_TABLE in SSRS Report?
Answer: Well, it can queried directly to ReportDb as it stores in Binary format. You can retrieve this information from the PSI, but it does not exist in the RDB in the format you are requesting.
However, the PSI can be queried by SSRS, so you should still be able to build your report.
3# How to install Project server 2010?
Answer: Detail outlined steps available at Microsoft Technet. Click HERE.
4# Can we customize the Office Project Professional 2010 Ribbon?
Answer: Yes, it is possible. For further details access this MSDN link.
5# How to use Powershell to migrate Project Server 2010 to Project Server 2013?
Answer: HIT here to find out the script.
6# Which version of Windows Power is Pre-requisite for SharePoint 2010 Products?
Answer: It is Windows PowerShell 2.0. It will be installed, if necessary, when you run the Microsoft SharePoint Products Preparation Tool. By default, Windows PowerShell is located at the following path: <%SystemRoot%>\System32\WindowsPowerShell\v1.0\PowerShell.exe.
Please note :Windows PowerShell 2.0 is backward compatible with Windows PowerShell 1.0 and subsequently installs to the v1.0 folder.
7# Create Project in Project server using Powershell script?
Answer: Script is available on the Microsoft technet gallery. Click here to access http://gallery.technet.microsoft.com/projectserver/Server-2010-Powershell-d66d4b4c
8# Script to Create the WCF Webservice Proxy Object in Powershell?
$WebSvcURL = “http://snweb10/aurTEST/servlet/services/_WS?wsdl”
$proxy = New-WebServiceProxy -Uri $AurionWebSvcURL -Namespace ExportTool -Class Program -UseDefaultCredential
Write-host -ForegroundColor yellow $proxy
9# Resources for Partners?
1. PPM at Microsoft Partner network. Click here
2. Project Partner Blog – Click here