Failed in deploy Service Pack 1

[jyxing007]

Hi,
Have Project Server 2007 and MOSS 2007 deployed and running together
on the same server and it was working fine, until yesterday I tried to
deploy 2007 Office Server Service Pack 1. I followed the guide on
techNet:
http://technet.microsoft.com/en-us/library/cc197653.aspx
I started with deploy service pack 1 for WSS 3.0, and with Office
Server Service Pack 1, things went OK until I run the SharePoint
Product and Technology configuration wizard, it faied at step 8 of 9.
In event log I found a series of 4 error messages, start with this
one:

SQL Database 'ProjectServer_Published' on SQL Server instance 'TOR-
EPMPILOT01\EPMPILOT' not found. Additional error information from SQL
Server is included below.

Cannot open database "ProjectServer_Published" requested by the login.
The login failed.
Login failed for user 'CMDOMAIN\EPMSFA'.

The wierd thing is my database is called
"ProjectServer_PWAPilot_Publish", so of course
"ProjectServer_Published" won't be found. But the user 'CMDOMAIN
\EPMSFA' is dbo of my actual database.

Anybody can shed some light on this? Now my share service provider
site is down with this message:
Server error: http://go.microsoft.com/fwlink?LinkID=96177

I'm banging my head now that I should not have done the upgrade... too
late.

Very much appreciated if you can help!!!

Jerold X

 

[Paul Conroy]

I would hope you have a full farm backup to restore to !

Have you got more than one server in the farm ? If so, have you updated all
the servers?

Try the upgrade again, but instead of running config wizard, run the
following from the command line

PSConfig.exe –cmd upgrade –inplace b2b –force