Solved

Project Portfolio 2007 issue, With Sharepoint

Posted on 2010-08-16
11
430 Views
Last Modified: 2013-11-15
Project Portfolio 2007 issue
Really need some help with Project Portfolio server install? This is my first time installing, I did download the how to doc from Microsoft, http://www.microsoft.com/downloads/details.aspx?familyid=8977c122-a64f-4c4e-a78b-0ea8e150fe3a&displaylang=en    but I am stuck at the install

I'm confused on how to install the Database and the Reporting Services.

 I am trying to install the Database on our database SQL server and The reporting services on another server, but i just don't see the option to do so.


I am running server 2003 32bit, and SQL 2005
0
Comment
Question by:sirichaiphumirat
  • 6
  • 4
11 Comments
 
LVL 5

Expert Comment

by:SMcP
ID: 33452540
PPS2007?
I know it might be a little too much to suggest but why not upgrade to SP 2010 and then install Project Server 2010?
Much better and a lot more usable.
0
 
LVL 12

Expert Comment

by:thausla
ID: 33452942
Hi,

the setup for PPS 2007 and Reporting Services are completely separate. During PPS installation you are being asked on which SQL Server the PPSAccountIndex and the PPSAccountData have been setup or should be created. For the SSRS installation you are being asked where the databases for Reporting Services should be setup, they are created by the SSRS Configuration program. This can be another SQL Server than PPS 2007!

The PPS setup program only asks for the location of the SSRS report templates and tries to copy the PPS report templates into this directory.

Hope this helps

Thomas
0
 

Author Comment

by:sirichaiphumirat
ID: 33456065

Thank  you for your response.

This is where I got confuse. Since there is two separate install, am I able to install PPS 2007 on one server and have it point to two different servers, one which will be the SQL server and the other being the Reporting Services.

Or does it mean I have to have two different servers and installs of PPS 2007. For example, I'll have to install PPS 2007 on serverA and point it to the SQL server and then install another PP7 on ServerB and point that to the Reporting Service server.

Because I have been trying to install PPS 2007 on one server, but I do not see any kind of option for me to install and point the Reporting Services anywhere.

This is how I have been trying to do the install

1. At the start of the install, I'll get asked on the location of the DB server, after putting that in, the install will be done.

2. Now I go back and start the install process again to add on the reporting Service feature, but now I don't see any option for me to install this on a different server.


@thausal , Have you had success with the installation of PPS 2007 before?

0
 
LVL 12

Expert Comment

by:thausla
ID: 33457791
Hi,

I've run 5 or 6 implementation projects for PPS 2007 and your assumptions are mostly correct:

- you only need to install PPS on ONE server, this will be your application server
- the SQL server can be "somewhere", i.e. on the PPS server or any other server where the database resides
- also the Reporting Services can run on any other machine or the PPS machine itself

In the end you need to have an application server running PPS 2007. The configuration (in the WEB.CONFIG file) then points to the right SQL server for the database and to the right Reporting Services server for the PPS reports.

Where are you in the installation process?

Thomas
0
 

Author Comment

by:sirichaiphumirat
ID: 33466371
I'm still on the installation part, I have been re-installing it many times.

i'm guessing i'm on the right track on the installation process.

so after my complete installation, i'll have to find web.config and edit the file so that PPS points to the reporting services server?

again thank you very much for your help.
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:sirichaiphumirat
ID: 33466467
also after installation, how do I even access PPS 2007
0
 

Author Comment

by:sirichaiphumirat
ID: 33505886
Any more help on this issue?
0
 
LVL 12

Expert Comment

by:thausla
ID: 33508184
Hi,

after you installed PPS, the Windows account that you used during installation has been setup as the super user. This means you connect to http://yourservername:port/portfolioserver/DEFAULT.aspx and should be logged on. If there is only PPS installed on your server and NO SharePoint you only need yourservername/portfolio...., if you have SharePoint on your server, one of the steps in the installation asked you to define a separate web (and port, e.g. 81). In this case you need to connect to http://yourservername:81/portfolio....

Regarding your earlier question on Reporting Services: yes, you set the url for the Reporting Services server in the web.config file. You find it in the installation directory for Portfolioserver, usually in c:\program files\Portfolioserver 2007\Portfolioserver OR c:\inetpub\wwwroot\Portfolioserver (depends on your installation settings).

Let me know how this works!

Thomas
0
 

Author Comment

by:sirichaiphumirat
ID: 33526324
I'm still a bit confusedon the web.conf part and where to add the server name for my reporting service server.

i however did managed to finally hit the PPS site, but when logging in. I get an error message saying "cannot open database "PPSAccountIndex" requested by the login. The Login Failed.

I used the same login I installed PPS with.


again thank for your help!!
0
 
LVL 12

Accepted Solution

by:
thausla earned 500 total points
ID: 33529580
Hi,

sounds like your database connection is not configured correctly. The login in your error message is the SQL login, not the PPS login. Please check the following entry in the web.config file:

<add key="PPSAccountIndex.ConnectionString" value="Provider=SQLOLEDB.1;Integrated security=SSPI;Initial Catalog=PPSAccountIndex;Data Source=SQLSERVERNAME;Workstation ID=XXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096"/>

This ONLY works if the Windows account that has been assigned to the application pool for the Portfolio Server website is a db_owner in the PPSAccountIndex database!

Alternatively you can use SQL authentication:

<add key="PPSAccountIndex.ConnectionString" value="Provider=SQLOLEDB.1;Initial Catalog=PPSAccountIndex;Data Source=SQLSERVERNAME;User ID=SQLUSERNAME;Password=SQLUSERPASSWORD;Workstation ID=XXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096"/>

---

The Reporting Services server is configured in this line:

<add key="ReportServerUrl" value="http://REPORTINGSERVER/ReportServer/"/>

Thomas
0
 

Author Comment

by:sirichaiphumirat
ID: 33562645
great thanks let me try that.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now