I am trying to get Project Server 2010 up and running on a Win Server 2008 box. I've got Sharepoint 2010 installed and Project Server 2010 installed. I open SharePoint Central Administration, then I go to Manage Service Applications > Project Server Service Application. It looks like there is a site under the "Sharepoint - 80" section, but the Status says "Failed - see the Application event Log". When I click on the site and select "Retry" I get the same thing. In the event viewer, I see an error with SharePoint Foundation Search as the Source - it reads:
Could not create a database session.
Context: Application '276504a6-93b1-4c1f-a900-fd6ed9d5c117'
Details: The database connection string is not available. (0xc0041228)
How can I fix this? Is there some configuration I missed?