Create User Accounts

To install Project Server 2003, you must create the following user accounts:

  • A Microsoft Windows domain user account or local user account to allow Project Server 2003 to access Microsoft SQL Server 2000 Analysis Services. Use this account when you create an OLAP Administrator later in this chapter.

If you create a local user account, you must create identical accounts with identical passwords on each of the following computers in your deployment:

  • The computer running Analysis Services
  • The computer running the Project Server Front-End service
  • The computer running the Project Server View Processing service
  • A Windows domain user account or local user account to allow Project Server 2003 to access Microsoft Windows SharePoint Services. You can use a generic name for this account, such as MSProjServ, and set the password to never expire. You will use this account when you create a Windows SharePoint Services administrator, and you will specify this account on the Enter account information for Microsoft Windows SharePoint Services (continued) page in Project Server Setup.
  • A Windows domain user or local user account to allow the Project Server Front-End service to access the Views Staging shared folder on the computer on which the View Processing service is located. This account must be located on both the computer running the Project Server Front-End service and the computer running the Project Server View Processing service. During Project Server View Processing Setup, a Views Staging shared folder is specified and created. The Windows account that you specify is then assigned the required permissions to the folder.

 Note   This account is only required if you plan to install the View Processing service on a different computer than the computer on which you install the Project Server Front-End service.

  • A SQL Server account on the instance of SQL Server 2000 in which the Project Server database will be located. This account must belong to the Database Creators and Security Administrators roles. This account will only be used for the purposes of creating the Project Server database. It will not be stored and used after installation.

 Note   You can use your system administrator (sa) account or an existing account that is a member of the same roles. If your Windows account belongs to the appropriate SQL Server roles, you can use Windows authentication as long as you are not partitioning your database.

  • A SQL Server login for Windows SharePoint Services. This account must belong to the Database Creators and Security Administrators roles. This account will be used to create the Windows SharePoint Services database on the computer running SQL Server.

 Note   For more information about accounts needed to install and configure Project Server 2003, see Project Server Service Accounts in the Microsoft Office Project Server 2003 Medium-Scale Installation Guide.

 Note   These accounts will only be used by Project Server 2003.

To create a Windows domain user account

  1. Open Active Directory Users and Computers.
  2. In the console tree, right-click the folder in which you want to add a user account.
  3. Point to New, and then click User.
  4. On the New Object—User page, type the user's first name, initial, last name, and user logon name, and then click Next.

New Object - User dialog box.

  1. In the Password box, type a password, and in the Confirm Password box, retype the password.
  2. Clear the User must change password at next logon check box.

 Note   You must clear this check box or the account will not work properly with Project Server 2003.

  1. Select the Password Never Expires check box, and click Next
  2. Click Finish.

 Note   To perform this procedure, you must be a member of the Account Operators group, Domain Admins group, or the Enterprise Admins group in Active Directory directory service, or you must have been delegated the appropriate authority.

To create a local user account

  1. On the computer on which you want to create the account, open Computer Management.
  2. Expand Local Users and Groups.
  3. Right-click Users and click New User.
  4. In the User name box, type a name for the user (for example, ProjServ).

Type a new user name.

  1. In Description, type a description for the user account.
  2. In Password and Confirm password, type the user's password.
  3. Clear the User must change password at next logon check box.

 Note   You must clear this check box or the account will not work properly with Project Server 2003.

  1. Click Create.

To create a SQL Server 2000 account

  1. On the database server, open SQL Server Enterprise Manager.
  2. Expand the server group containing the server on which you want to add the account, and then expand the server.
  3. Expand Security, right-click Logins, and then click New Login.
  4. In the Name box, type a name for the SQL Server login (for example, ProjServSQL).

Type a login name.

  1. Under Authentication, select SQL Server Authentication.
  2. In the Password box, type a password.
  3. On the Server Roles tab, select the Security Administrators and Database Creators check boxes.

Server roles.

  1. On the Confirm Password page, in the Confirm New Password box, reenter the password, and then click OK.
  2. Click OK.

To create a SQL Server login for the computer running Windows SharePoint Services

  1. On the database server, open SQL Server Enterprise Manager.
  2. Expand the server group containing the server on which you want to add the account, and then expand the server.
  3. Expand Security, right-click Logins, and then click New Login.
  4. In the Name box , type a name for the SQL Server login. Use the form domain\username; for example, XABYTE2\ProjServ.

Type a login name.

  1. Under Authentication, select Windows Authentication.
  2. From the Domain list, select the domain in which the computer is located.
  3. On the Server Roles tab, select the Security Administrators and Database Creators check boxes, and click OK.

 Note   You can also configure this account to use SQL Server authentication, although Windows authentication is recommended. To configure this account using SQL Server authentication, see the previous procedure: To create a SQL Server 2000 account.

 
 
Applies to:
Deployment Center 2003