Hi ssanderlin,
I've installed the EditSite Tool on my Project Server 2003 and did the things following to the instructions below:
Reset the DSN.
1. If you are running Project Server 2003, start the EditSite tool. If you are running Project Server 2002, start the Site Editor tool.
2. In the DSN Name box under Site Information, rename the existing DSN by adding a number to the end of the name.
For example, if you are running Project Server 2002 and the name of the DSN is PC10DSN, rename the DSN to PC10DSN1.
3. Click Save, and then click Yes when you are prompted to delete the old DSN.
4. When you receive the message that the changes that you made are saved, click OK.
5. In the DSN Name box under Site Information, change the name of the DSN to the original name. To do this, remove the number that you added to the end of the name so that the DSN uses the original name of the DSN.
For example, if you renamed the DSN to PC10DSN1 in step 2, change the name to PC10DSN.
6. Click Save, and then click Yes when you are prompted to delete the old DSN.
7. When you receive the message that the changes that you made are saved, click OK.
8. To verify that connection parameters are configured correctly, click Test under Virtual Directory,
9. Click OK, and then click Exit.
But it's not work!!!! After reset DSN, I clicked "Update Now" to force the cube to build. 7 errors and 2 warnings are still shown on Application Event Logs. What should I do next ???
Jee