Article ID: 325843 - View products that this article applies to.
This article was previously published under Q325843
This article discusses the user accounts and permissions that you must have to install, configure, and connect to Microsoft Project Server, Microsoft SQL Server 2000 Analysis Services, and Microsoft SharePoint Team Services.
Microsoft Project ServerTo install Microsoft Project Server, you must have two SQL Server user accounts to connect to an existing Microsoft Project Server database, or one SQL Server or Microsoft Windows user account to create a new database.
If you are connecting to an existing database, the first user account must be a member of the MSProjectServerRole role in the Microsoft Project Server database. The second account must be a member of the MSProjectUserRole in the Microsoft Project Server database. If you are creating a new database, the user account must have the correct permissions to create databases and user accounts.
The minimum requirements to create the Microsoft Project Server database is a SQL Server or Windows user account that is a member of the following database roles:
Security AdministratorsTo create a new SQL Server login user account (if you are using SQL Server Authentication), follow these steps:
SQL Server Analysis ServicesTo install SQL Server Analysis Services, you need a Windows user account that is a member of the On-Line Analytical Processing (OLAP) Administrators group on the computer that is running Analysis Services.
To add your Windows user account to the OLAP Administrators group on the computer that is running Analysis Services, follow these steps:
SharePoint Team ServicesThe following are the user account and permissions requirements for installing SharePoint Team Services.
Using the SharePoint Configuration Wizard (Stswiz.exe)To install SharePoint Team Services by using the SharePoint Configuration Wizard, you need a SQL Server user account that is a member of the System Administrators (sysadmin) database role.
Running SharePoint Team Services SetupTo install SharePoint Team Services, you need a Windows user account that is a member of the Administrators group on the computer on which SharePoint Team Services is installed. The user must also be a member of the db_datareader role for the SharePoint Team Services database in SQL Server.
To add your Windows user account to the db_datareader database role, follow these steps:
Run the PSComplus.exe Utility to Impersonate the Account for a COM+ ApplicationIf you choose to defer the portion of Microsoft Project Server Setup that configures a connection to Analysis Services or SharePoint Team Services, you must run the Microsoft Project Server COM+ Settings tool (PSComplus.exe). This tool provides the name of a user account (in the format of Domain\UserName) that is impersonated by a COM+ application to allow Microsoft Project Server to connect to the Analysis Services and SharePoint Team Services computer for Analysis Services (OLAP) access, SharePoint Team Services administration, and SharePoint Team Services database access.
PSComplus.exe is located in drive:\Program Files\Microsoft Project Server\Bin\1033, where drive is the drive on which Windows is installed.
To run PSComplus.exe, follow these steps:
For more information about how to install Microsoft Project Server and related components, see the Microsoft Project Server Installation Guide (Pjsvr10.chm). This file is located in the Docs folder on the Microsoft Project Server CD-ROM or in the drive:\Program Files\Microsoft Project Server\Help\1033 folder on the hard disk (where drive is the drive on which Windows is installed).
For more information about where to find the Microsoft Project readme files, click the following article number to view the article in the Microsoft Knowledge Base:
323018For more information about the minimum system requirements for Microsoft Project, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/323018/ )PRJ2002: Where to find the Readme files that are included with Microsoft Project and Microsoft Project Server
(http://support.microsoft.com/kb/321392/ )Minimum system requirements for Microsoft Project Server and Microsoft Project Web Access
(http://support.microsoft.com/kb/321382/ )PRJ2002: Minimum system requirements for Microsoft Project Standard and Microsoft Project Professional
For more information about installation and configuration of SharePoint Team Services, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/820774/ )How to install and configure SharePoint Team Services for Microsoft Project Server 2002 on Microsoft Windows Server 2003
Contact us for more help
Connect with Answer Desk for expert help.