View Effective Rights Tool

[Neil]

We have Project Server 2003 SP2A installed and have installed this tool, all
that is returned is the screen saying 'results' and no results are shown when
we try to run it. There is no error in the SQL logs.
We are not using 'projectserver' as our system anymore but 'projectserver'
still exists in the registry.
TIA
Neil.

 

[Ben Howard]

Hi Neil,
Obvioulsy you need to make sure the tool is installed correctly for the
correct instance of Project Server.
Secondly, have you checked that the 3 stored procedures are still declared
in the QyLibStd.txt files
27160 @MSP_WEB_ER_GetAllProjectPermissions
27161 @MSP_WEB_ER_GetAllResourcePermissions
27162 @MSP_WEB_ER_GetAllGlobalPermissions

The SP2 updates/replaces the QYLibSTD.SQL file, you need to add again these
3 lines in the file after applying the SP2a..

 

[Neil]

Hi Ben,
Thanks for the reply,
Yes, the 3 SP's are in the sylibstd.txt file.
The PDSExentensions entry in the registry is in 'projectserver' and not our
current instance, shoud it be?

I get the View Effective rights menu option, so apart from that how can I
tell if the tool is installed correctly?

thanks
Neil.

 

[Ben Howard]

Hi Neil,
The registry needs to point to the correct instance otherwise the PDS
extension won't work, which I guess is what you are seeing. So you'll need
to add another registry entry, or potentially you could try modifying the
current one if the ProjectServer instance has been deleted. The creation of
a new reg key is well documented in the Project Server 2003 res kit as part
of the effective rights tool install.