|
|
|
|
Project Central Info Installing Project Central for use with SQL ServerFollow these instructions to install Microsoft Project Central configured for mixed authentication. I recommend this configuration for a variety of reasons that are not covered in this document. As you become familiar with Project Central, you’ll be able to determine how authentication will work in your organization, and this can be reconfigured at any time.
Install SQL Server
Install SQL Server following the directions for SQL Server Installation. Decide whether to customize the database installation by creating a database manually or whether to go with the Microsoft defaults, which are created by the scripts provided on the Project2000 CD.
To create a default database and table installation for a SQL Server:
1. Within SQL, create an account (mysqlaccount) giving it the Sever role of database creators and assigning it to the dbo owner role on the Master Database. Make the password (mysqlpassword) whatever you want. (note any name and password combo is fine)
2. From Windows, go to the MS-DOS Prompt.
3. Change directories to the CD-ROM drive, and on the Microsoft Project CD, go to the folder \Pjcntrl\Isapi\1033 (or the appropriate folder for your language).
4. Run these scripts in the order specified. Running them out of order will cause your installation to fail. Type the following commands (user name and password created above is used in this example) to create a database and tables in the database and to insert default records for the tables:
osql -U mysqlaccount -i Crttable.sql osql -U mysqlaccount -P mysqlpassword -d Project_CentralDB -i Insdefsq.sql osql -U mysqlaccount -P mysqlpassword -d Project_CentralDB -i Insdefsi.sql
Note: the switches in the commands are case sensitive
5. Open SQL Enterprise manager after you have created the database and change the default database of the SQL account you created to the new Project_CentralDB which will now be available.
If you intend to store projects in a database, do the following:
Use SQL Enterprise manager or Query Analyzer to create an empty database for projects. Create a Project Database separate from Project_CentralDB, name it what you like
Add a SQL logon to be used by users storing projects to a database, make the new database its default database. Remember to give this account a server role of database creators, and assign it to the DBO role of your new database.
You can create as many logons as you want, but remember that you must create a corresponding DSN for each individual logon you create. Keep in mind that these must be created on both the client machine and Project Central Server. Make certain that each account you create is assigned to the DBO role.
Create Machine DSN on the Project Central Server
On the Project Central Server, go to Control Panel and locate the icon for Data Sources ODBC (label varies by operating system). Create a DSN pointing to the SQL Server database you created in the previous steps. Be certain that you clear the ANSI translation check boxes and test the connections upon completion. Do this for each SQL User/DSN name combination you intend to use to store projects to the database. There must be a corresponding DSN on the Project Central Server with the same username and password for each combination out in the field.
Install Project Central Server (assumes that IIS is already installed)
1. Insert the Microsoft Project CD into the CD-ROM drive.
2. Click Install Microsoft Project Central Server.
3. Enter your user name and organization, and then click Next.
4. Accept the license agreement, and then click Next.
5. In the Install Microsoft Project Central Server here box, specify where you want to install the server. The default location will be the drive that has the most disk space. If this is the c drive, then the default location will be c:\ProjectCentral. The location you specify will become the name of the new virtual directory that is created on the Web server.
6. Select the customize option.
7. Specify the database that was created in the previous steps as the Microsoft Project Central store; Project_CentralDb. Enter the username and password.
8. Once the connection to the database is verified, complete the installation.
Create Anonymous User Account
Add a domain account or local machine account with a password that never expires for use as the anonymous user account. Whether or not this must be a domain or local account is determined by how and where projects are stored. If projects or linked deliverables to be accessed through Project Central are stored on shares across the network or in a SQL database governed by domain security, then the anonymous user must be a domain account. If the shares are on the local machine, a local account will do. Make sure that the user password never expires. Do not use the default IUSR account.
Configure Web Sites for mixed authentication
1. Invoke the IIS Service Manager.
2. Right click on the Default Web Site and choose properties.
3. Click the Directory Security Tab and then under anonymous access and Authentication Control, click Edit.
4. Make sure that both Anonymous and NT Authentication are checked. Basic authentication should not be checked.
5. Select the Anonymous Access check box, and then click Edit for the Account used for Anonymous Access.
6. Specify the domain account and password you created for this purpose.
7. Be certain that the synchronize passwords box is unchecked and that the domain account specified has a password that doesn’t expire.
8. Repeat these steps for the Project Central virtual directory, which should inherit the user from the default database.
9. Note: when you change the Project Central virtual directory to allow anonymous access, you may get a dialog box asking if you want to override the security permissions for the files Isapi\Pjdbcomm.dll and Logon\Basicauth.asp. Do not select any of these files, and then click OK.
Change Security Permissions on Default.asp
1. From within IIS Service Manager click on Project Central (the virtual directory)
2. In the right pane, right-click on Default.asp, then choose Properties
3. Click on the File Security tab and then click Edit for Anonymous access and Authentication Control
4. Clear the Allow Anonymous Access check box
Final Steps
Both Project Central and the database are now ready for use. Verify this by calling the Project Central web site from your workstation. Logon as administrator and change the administrative password.
Verify that NT authentication is working
1. While logged on as administrator, choose Admin, Users, and choose add user.
2. Select Windows NT Authentication radio button and enter an account for yourself, using domainname\logonname format in the username box. Be sure to make yourself an administrator.
3. Enter other information and click save changes. The User should be added and verified with a message box.
Now, still logged in as you at your workstation, type the URL of the Project Central server. Verify that you are immediately authenticated to the Project Central homepage and that across the top, it reports that you are logged on as you in the upper right hand side.
DSN Creation and Verification
1. Create a System DSN on your machine using the SQL account you setup for storing projects and connecting to the empty project database.
2. Save your first project to the project database using the DSN
3. After your project has been saved to the database, in Project, from the Tools menu, choose workgroup and select update project to web server. You will get an acknowledgement that the project was successfully updated to the web server.
4. Log on to Project Central as yourself, an administrator, and choose Manage Views from the Admin menu.
5. Choose Data Sources for Views and select the DSN you used from the grid and choose modify.
6. Update the DSN record with the username and password you used to create the DSN.
Use a combination of Specify Views, User Permissions for Views and Specify Categories to grant yourself permission to use detailed views. This can be done in a variety of ways (not covered here). Regardless of how you accomplish this, you should now be able to see the project in your portfolio and access detailed views from the menu.
That’s it, almost quick and fairly easy.
|
|
