Failed to grant login error when Installing Project Server 2007

[aSoundMind]

Hi Guys,

I encountered this problem when trying to create a pwa website in
project server 2007. where the error asked me to check the event
viewer.

This is the exact path
Shared Services Administration: SharedServices1 > Manage Project Web
Access Sites > Project Web Access Site Properties

I am not sure what is the problem. I couldn't see synergyatwork
\administrator in the sqlserver 2005 user login, however when I tried
to add synergyatwork\administrator to the sqlserver, it says that user
already exist.

Please assist any help is appreciated. Thanks in advance.

Following is the event viewer log

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 6983
Date: 9/19/2007
Time: 12:26:15 PM
User: N/A
Computer: SYNERGY-SVR01
Description:
Provisioning 'PWA': Failed to grant login to 'SYNERGYATWORK
\administrator' on primary server.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 6993
Date: 9/19/2007
Time: 12:26:15 PM
User: N/A
Computer: SYNERGY-SVR01
Description:
Provisioning 'PWA': Failed to provision databases. An exception
occurred: Failed to grant login on primary server..

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 6958
Date: 9/19/2007
Time: 12:26:15 PM
User: N/A
Computer: SYNERGY-SVR01
Description:
Provisioning 'PWA': Database provisioning failed.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 6971
Date: 9/19/2007
Time: 12:26:16 PM
User: N/A
Computer: SYNERGY-SVR01
Description:
Failed to provision site PWA.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

 

[Gary L. Chefetz [MVP]]

Jack:

The account you are using for the Shared Service Provider must have the
following SQL permissions:

Database Creator
Security Administrator

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[aSoundMind]

Jack:

The account you are using for the Shared Service Provider must have the
following SQL permissions:

Database Creator
Security Administrator

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

Hi Gary,

Thanks for your reply. The problem caused by corrupted database and
corrupted user accounts. After I deleted the username, and added the
new one. It works fine now.
Thanks and have a nice day.

Regards,
Jack