Microsoft KB Archive/823529

= How to use the Site Editor tool to create multiple Microsoft Project Web Access Web sites for Project Server 2003 =

Article ID: 823529

Article Last Modified on 11/30/2007

-

APPLIES TO


 * Microsoft Office Project Server 2003
 * Microsoft Office Project Web Access

-





SUMMARY


This article describes how to use the Microsoft Project Server 2003 Site Editor tool (EditSite.exe) to make changes to your existing Web site configuration, to delete a Web site, or to add a new Web site.



IN THIS TASK

 * INTRODUCTION
 * MORE INFORMATION
 * Get started
 * Use the Site Editor tool to create multiple Microsoft Project Web Access Web sites for Project Server 2003
 * Edit Web site information for a single database
 * Edit Web site information for a partitioned database
 * Delete a Web site
 * Add a Web site
 * Synchronize the Windows SharePoint Services Web administrator accounts



INTRODUCTION
You can use the Site Editor tool (Editsite.exe) to create multiple Microsoft Project Web Access Web sites for Microsoft Office Project Server 2003. You can use the Site Editor tool to complete the following tasks:
 * Edit information for a single database
 * Edit information for a partitioned database
 * Delete a Web site
 * Add a Web site

back to top



MORE INFORMATION
After you use the Site Editor tool to configure Project Server 2003 for multiple Web sites, you can connect to one or more Microsoft Project Web Access Web sites on the same server. This environment is ideal for administrators who want to use different Microsoft Project Web Access Web sites for different groups of users.

Get started
Download the Site Editor tool from the Microsoft Web site. After you download the tool, use the Connection Information (ConnInfo.exe) tool to gather important account information. To do this, follow these steps:  Download the Site Editor tool (EditSite.exe).

To do this, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6dc2c83e-54e1-40a9-9bb8-2dd293226b6f&DisplayLang=en

 Before you use the Site Editor tool to create a new virtual directory (site) for Project Server 2003, you must determine the passwords for the MSProjectServer and for the MSProjectUser user accounts. Project Server 2003 stores information in the registry about the location of the Microsoft Project Server database, and about the accounts that are associated with Microsoft Project Server roles. You can use the Site Editor tool to make changes to these accounts, or you can use the Connection Information tool to update the information.

To use the Connection Information tool for a single database, follow these steps:  Run the Connection Information tool.

The ConnInfo.exe file is located in the \BIN\1033 folder of your Project Server 2003 installation. To download the Connection Information tool, visit the following Microsoft Web site:

http://go.microsoft.com/fwlink/?LinkId=20878

Note If you download and install the Connection Information tool on the server from the Microsoft Web site, you can find the ConnInfo.exe file in the following folder:

\Program Files\Microsoft Office Project Server 2003 Resource Kit\Toolbox\ConnInfo Utility

 Click Single database configuration. In the SQL Server text box, type the name of the instance of Microsoft SQL Server 2000 that contains the Project Server 2003 database. In the Database text box, type the name of the Project Server 2003 database.</li> In the MSProjectServerRole Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database.</li> In the MSProjectRole Member, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database.</li> Click Save, and then click Exit.</li></ol>

To use the Connection Information tool for a partitioned database, follow these steps: <ol style="list-style-type: lower-alpha;"> Run the Connection Information tool. The ConnInfo.exe file is located in the \BIN\1033 folder of your Project Server 2003 installation.

To download the Connection Information tool, visit the following Microsoft Web site:

http://go.microsoft.com/fwlink/?LinkId=20878

</li> Click Partitioned database configuration.</li> If you have partitioned only the View tables, click Standard 2-Way Deployment. Otherwise, click Custom Deployment.</li> Click the database that you want to configure from the drop down list that is located above Project Tables.</li> Click Project Tables to configure the database that contains the Microsoft Project tables and Security views.

Click View Tables to configure the database that contains the View tables. Click Web Tables to configure the database that contains the Microsoft Project Web Access tables and Cube tables.

Note If you click Standard 2-Way Deployment, Web Tables is not available in the list.</li> In the SQL Server text box, type the name or the IP address of the instance of SQL Server that contains the Project Server 2003 database.</li> In the Database text box, type the name of the Project Server 2003 database.</li> In the MSProjectServerRole Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database.</li> In the MSProjectRole Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database.</li> Repeat steps d through i for each database that you want to configure.</li> Click Save, and then click Exit.</li></ol> </li></ol>

back to top

Use the Site Editor tool to create multiple Microsoft Project Web Access Web sites for Project Server 2003
After you install the Site Editor tool, follow these steps to configure your Web site:
 * 1) Start Microsoft Windows Explorer, locate the Site Editor tool, and then double-click the EditSite.exe file.
 * 2) The EditSite.exe file is a self-extracting file that will create the following three files in the \Program Files\Microsoft Office Project Server 2003 Resource Kit\Toolbox\Edit Site Utility folder:
 * 3) * Edit Site Utility.doc
 * 4) * EULA.txt
 * 5) * Setup.msi
 * 6) Double-click Setup.msi to install the Site Editor tool. To complete the following steps, you must run the Site Editor tool on the computer where Project Server 2003 is installed. Additionally, you must be an administrator on the computer that is running Project Server 2003, and on the computer that is running the Microsoft Project Server Views Notification Service and Microsoft Windows SharePoint Services, if applicable.

Note You must have Microsoft .NET Framework version 1.1 installed on the computer where you run the Site Editor tool.
 * 1) After the Setup program is complete, double-click the EditSite.exe file that is located in the \Program Files\Microsoft Office Project Server 2003 Resource Kit\Toolbox\EditSite folder.

back to top

Edit Web site information for a single database
To edit the Web site information for a single database configuration, follow these steps:
 * 1) Click the Web site that you want to edit in the Virtual Directory list.
 * 2) In the Site Information area, update the DSN Name value, the Query Timeout value, and the Session Manager value.
 * 3) In the Database Information area, click to select the Single Database Configuration check box.
 * 4) In the SQL Server text box, type the name of the instance of SQL Server where the Project Server 2003 database is located for this Web site.
 * 5) In the Database text box, type the name of the Project Server 2003 database for this Web site.
 * 6) In the MSProjectServer Role Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database for this Web site.
 * 7) In the MSProject Role Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database for this Web site.
 * 8) Click Save.

back to top

Edit Web site information for a partitioned database
To edit the Web site information for a partitioned database configuration, follow these steps:
 * 1) Click the Web site in the Virtual Directory list.
 * 2) In the Site Information area, update the DSN Name text box, the Query Timeout text box, and the Session Manager text box.
 * 3) In the Database Information area, click to select the Partitioned Database Configuration check box.
 * 4) If you have partitioned only the View tables, click to select the 2 Way Deployment check box. Otherwise, click the Custom option.
 * 5) Click the database that you want to configure.
 * 6) Click Project Tables to configure the database that contains the Microsoft Project tables and Security views. Click View Tables to configure the database that contains the View tables. Click Web Tables to configure the database that contains the Microsoft Project Web Access tables and the Cube tables.

Note If you click Standard 2-Way Deployment, Web Tables is not available in the list.
 * 1) In the SQL Server text box, type the name of the instance of SQL Server that contains the Project Server 2003 database for this Web site.
 * 2) In the Database text box, type the name of the Project Server 2003 database for this Web site.
 * 3) In the MSProjectServer Role Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database for this Web site.
 * 4) Under MSProject Role Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database for this Web site.
 * 5) Repeat steps 5 through 10 for each database that you want to configure.
 * 6) Click Save.

back to top

Delete a Web site
You can use the Site Editor tool to delete a Web site. To do this, follow these steps:
 * 1) Click the Web site in the Virtual Directory list that you want to delete.
 * 2) Click Delete.

The Site Editor tool deletes the virtual directory and the registry information that is associated with the Web site. However, the Site Editor tool does not delete the ODBC connection registry keys, because the ODBC connection might be used for other purposes.

back to top

Add a Web site
You can use the Site Editor tool to add a Web site. To do this, follow these steps: <ol> Create a database for the new Web site. For more information about how to create a Project Server 2003 database, see Chapter 6, &quot;Deploy the Database&quot; in the Microsoft Office Project Server 2003 Installation Guide.

Note To download the Microsoft Office Project Server 2003 Installation Guide, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/office/projectserver/bb310640.aspx

</li> <li>Run the Site Editor tool (EditSite.exe).</li> <li>Click Add.</li> <li>Click the Site Information tab.</li> <li>In the Site Name text box, type the name that you want to use for the new Web site.</li> <li>Make sure that you use the correct information in the Project Server directory text box.</li> <li>After you provide the Web site name, the DSN Name text box is automatically populated with a name for the new DSN.

To use a different DSN, type the name in the DSN Name text box.</li> <li>In the Session Manager text box, type the name of the computer that is running the Session Manager service.</li> <li>In the Web Site list, click the Web site that you want to use for the new Project Server 2003 Web site.</li> <li>If you are running Microsoft Windows Server 2003, click the application pool that you want the new Web site to use, in the IIS 6 Application Pool text box.</li> <li>To specify information for a single database configuration, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>On the Database Information tab, click Single Database Configuration.</li> <li>In the SQL Server text box, type the name of the instance of SQL Server where the Project Server 2003 database is located for this Web site.</li> <li>In the Database text box, type the name of the Project Server 2003 database for this Web site.</li> <li>In the MSProjectServer Role Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database for this Web site.</li> <li>In the MSProject Role Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database for this Web site.</li></ol>

To specify information for a partitioned database configuration, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>On the Database Information tab, click Partitioned Database Configuration.</li> <li>If you have partitioned only the View tables, click 2 Way Deployment. Otherwise, click the Custom option.</li> <li>Click the database that you want to configure. Click Project Tables to configure the database that contains the Microsoft Project tables and Security views. Click View Tables to configure the database that contains the View tables. Click Web Tables to configure the database that contains the Microsoft Project Web Access tables and Cube tables.

Note If you click 2Way Deployment, Web Tables is not available in the list.</li> <li>In the SQL Server text box, type the name of the instance of SQL Server that contains the Project Server 2003 database for this Web site.</li> <li>In the Database text box, type the name of the Project Server 2003 database for this Web site.</li> <li>In the MSProjectServer Role Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database for this Web site.</li> <li>Under MSProject Role Member area, type the user name and the password for the account that is a member of the MSProjectServer role in the Project Server 2003 database for this Web site.</li> <li>Repeat steps c through step g for each database that you want to configure.</li></ol> </li> <li>On the Windows SharePoint Services Information tab, click Set up Windows SharePoint Services and Project Server Integration.</li> <li>In the Admin URL text box, type the URL for the Windows SharePoint Services Central Administration page.</li> <li>In the Site URL text box, type the URL where you want to create Windows SharePoint Services Web sites for projects.</li> <li>In the Site Admin NT Account text box, type the name of the Windows SharePoint Services Web site administrator account.</li> <li>In the Admin Name text box, type the name of the Windows SharePoint Services Web site administrator account.</li> <li>In the Admin e-mail text box, type the e-mail address for the Windows SharePoint Services Web site administrator.</li> <li>If you use Windows SharePoint Services in an extranet, click Extranet.</li> <li>To prevent users of the new Web site from connecting to Windows SharePoint Services Web sites that belong to other Project Server 2003 Web sites, click Hosted Organization.</li> <li>Optionally, provide the user account, the name, and the e-mail address for a second Windows SharePoint Services configuration in the corresponding text boxes.</li> <li>Click Create.</li> <li>Restart the Project Server Views Notification Service.</li></ol>

Note In deployments where the Project Server Views Notification Service is installed on a different computer than the Front-end service, you must restart the Views Notification service on the computer that runs the Project Server Views Notification service, and the computer that runs the Front-End service. To restart the Project Server Views Notification Service, follow these steps:
 * 1) Click Start, and then click Administrative Tools.
 * 2) Double-click Services.
 * 3) In the Name column, right-click Project Server Views Notification Service, and then click Restart.

back to top

Synchronize the Windows SharePoint Services Web administrator accounts
After you complete the steps in this article, you must synchronize the Windows SharePoint Services Web administrator accounts. To do this, follow these steps:
 * 1) Log on to Microsoft Project Web Access for the new Web site.

Note By default, the administrator password is blank when the Site Editor tool creates a new Web site.
 * 1) Click the Admin tab.
 * 2) In the left pane, click Manage Windows SharePoint Services.
 * 3) In the left pane, click Synchronize administrator groups.
 * 4) Click Synchronize Web Administrators.

For more information about how to install, configure, deploy, and administer Project Server 2003, visit the following Microsoft Web site to obtain the Microsoft Office Project Server 2003 Online Books (Resource Kit):

http://technet.microsoft.com/en-us/office/projectserver/bb310640.aspx

back to top

Additional query words: utility tool

Keywords: kbhowto kbinfo kbmisctools kbserver kbclientserver KB823529

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.