none
hi all ,How to solve the Moss Server 2010-Project Web App and SQL Server 2008 R2 admin account verification problem (details in text) RRS feed

  • Question

  • Hi,all  How to solve the Moss Server 2010-Project Web App and SQL Server 2008 R2 admin account verification problem !

    I declare the computer system environment:

    ------------------------------------------------------ 

    Computer Name: A 

    System:Windows Server 2008 R2 X64 

    SQL Server2008R2 Database Server: FRANKCHEN

    But No Install Project Server 2010 and SharePoint 2010

    Domain:FRANKCHEN\Administrator(Local Account)  [No AD]

    -------------------------------------------------------

     Computer Name: B

    System:Windows Server 2008 R2 X64 

    NO SQL Server 2008 R2 !! 

    But Have Install Project Server 2010 and SharePoint2010  

    Domain:INV2008\Administrator(Local Account)  [No AD]

     

    I will use Project Server2010 computers B connected to the computer A ,SQL Server database to do authentication

    In the establishment of Project Web Access will appear computer administrator account  computer B,  Computer A database administrator account can not be found

    Please Help Me! thanks

    ----------------------------------------------------------

    Error Message:

    Deployment '/ pwa01': can not be granted to the main server 'INV2008 \ Administrator' login privileges.

    Event ID:6983

     

    Wednesday, September 1, 2010 10:29 AM

Answers

  • Hello Mr.  Charlie,

    I would follow the guide in TechNet or read the MsProjectExperts book on installing and configuring Project Server 2010.

    Without getting into a whole lot of details, you need to use domain accounts for many of these processes, specially the SQL Server access.   The SharePoint and Project Server will not get access to SQL server, unless the SQL server has some trust from SharePoint. 

    The security model in Project 2010 is rigid, so all requirements must be meet when doing the installation and configuration.

    Cheers!

    Michael Wharton, MBA, PMP, MCT


    Sincerely, Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA www.WhartonComputer.com
    Wednesday, September 1, 2010 1:22 PM
    Moderator

All replies

  • Hello Mr.  Charlie,

    I would follow the guide in TechNet or read the MsProjectExperts book on installing and configuring Project Server 2010.

    Without getting into a whole lot of details, you need to use domain accounts for many of these processes, specially the SQL Server access.   The SharePoint and Project Server will not get access to SQL server, unless the SQL server has some trust from SharePoint. 

    The security model in Project 2010 is rigid, so all requirements must be meet when doing the installation and configuration.

    Cheers!

    Michael Wharton, MBA, PMP, MCT


    Sincerely, Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA www.WhartonComputer.com
    Wednesday, September 1, 2010 1:22 PM
    Moderator
  • Hi Charlie,

    when you installing the Project Server in two server architecture, you need SQL Server domain account with windows authentication . 

    You can use local administrator account when you installing the Project Server and SQL Server on same machine.

    Please refer my website about domain accounts on two server installation. Please read the sections "Choose Domain name for Servers and Domain account for Installation" and "Verify domain account access on both the servers". These instructions for Project Server 2007 but it's same for 2010.

    http://www.epmcentral.com/deploy/pj07farminstall.php

    Thanks
    Chak

     


    Chak Tukkadi pVector Technologies Consulting: http://www.pvectortech.com Blog: http://www.epmcentral.com
    Wednesday, September 1, 2010 5:18 PM
  • Chak your post is incorrect for 2010, as documented in TechNet you cannot use local account for the install
    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Wednesday, September 1, 2010 6:20 PM
  • Chris,

    I mean, we can use local admin account in stand alone mode installation (with SQL Server 2008 Express). It will work.

    Thanks

    Chak

     


    Chak Tukkadi pVector Technologies Consulting: http://www.pvectortech.com Blog: http://www.epmcentral.com
    Wednesday, September 1, 2010 7:25 PM
  • Hello everybody, good actually, my task is to test in the absence of clear state of Active Directory, use of Computer-A 中 under the Project Server2010 connect to Compluter-B data in the SQL Server2008 database to complete the installation, but the problem is two computers in the local client account can not be found. Is there any way you can be smoothly resolved.
    Thursday, September 2, 2010 3:44 AM