database access problems post SP2

[Todd Hicks]

Started this last week, back on task this morning and the situation is this:
When attempting to access PWA, I'm challenged for username/password (this is
a new behaviour post SP2) My domain credentials are accepted. PWA then
presents the web form login with the 5001 "Project Server database cannot be
accessed" error.

PWA, SQL and SPS are each on separate servers. I have installed SP2 per the
instructions. I have recreated the SQL logins "MSProjectUser" and
"MSProjectServerUser". I have also validated the application pool user
credentials.

Anybody have ideas?

 

[Todd Hicks]

Just updated and confirmed the MDAC version on both machines. MDAC 2.8 SP2 on
Windows Server 2003 SP1 on the Project Server and the SQL Server.
Problem continues.

 

[scot.milroy]

Hi Todd,

If you are using SQL Client Configuration Aliases, then SQL is
partially broken but not un-recoverable. SP2 seems to screw up these
aliases and make SQL only listen on certain ports. Go to the server
which has SQL on it. Go to Program Files>SQl Server>Network
Configuration Utility and remove the Aliases located there. Next, in
the same menu, go to Client Configuraton Utility there and delete the
Alias. Stop and restart all the SQL services and try again. If this
still doesn't work, remove MSProjectServerUser and MSProjectUser and
then recreate them and add them to the appropriate roles. If you have
the Project Server CD under the support folder you can copy the script
PSRoles.sql and then paste it into Query Analyser and run it from their
to ensure that they are properly added to the roles.

Good luck!! Let us know if you resolve the issue.

Scot

 

[Myron Bollman]

Hi Scott,

I am having a similar problem with MSProjectServer. All was working fine,
until 2 weeks ago when suddenly we were no longer able to access the
database. Even the Administrator logon fails with a similar (5001) error.

Using the EditSite tool, everything "passes" just fine. I have recreated
the MSProjectUser and MSProjectServerUser logins multiple tiomes now, but
this does not fox the problem (in the past this has fixed it). We are
running on a W2K SP1 Server running both SharePoint and MSProjectServer
(SP2), MDAC 2.8.

I also confirmed and recreated the IIS Application Pool, and confirmed
permissions on the identity username.

Not sure, what to check next. Do you or anyone else have ideas I should
pursue?

Thanks,
Myron

 

[SMS@UT]

Scott, Myron and Todd,

Did any of you fellas resolve the issue - I am in the same boat and have
travelled down the same creek. Ive posted my issue on this discussion list
in the feeble hope of getting response. Ive checked everything I know to
check.

Thanks

Angie