T
trj
I just thought I'd post a solution to a problem that I've been frustrated
with for months. Perhaps others will find this useful.
Problem: View Effective Rights in the Project Server 2007 Resource Kit
doesn't allow the user to swich databases if there are multiple databases on
the server. There is also a message about this problem at
http://technet.microsoft.com/en-us/library/cc197528.aspx. that states:
Caution:
There is a known issue for the tool in which the list of databases returned
for the “Check permissionâ€, “for userâ€, and “on project†fields will
automatically populate using the first database found alphabetically. The
workaround is to restore the Project Server databases that you want to use
the tool on, naming them with an initial letter that appears earlier in the
alphabet than the default database populated. Alternatively, you can delete
all of the Project Server databases that appear alphabetically before the one
you wish to utilize.
Solution: Both the project server and database names seemed to be stored in
this path on the user's PC:
Documents and Settings\
[Your user folder]
Local Settings\
Application Data\
Microsoft_Corporation\
ViewEffectiveRights.exe_StrongName_[*]\ (* is lots characters. You'll see
what I mean)
12.0.0.0\
user.config
The databaseis in the "DbName" section.
The server is in the "DbServerName" section.
Just edit user.config and change the database name when you want to run the
tool against a different database.
Example:
<setting name="DbName" serializeAs="String">
<value>YourDBName_Published</value>
</setting>
<setting name="DbServerName" serializeAs="String">
<value>YourServerName</value>
</setting>
Just replace YourDBName_Published with your Project 2007 database name.
You can also replace YourServerName with your Project SQL Server name.
Save user.config. That's all there is to it.
Run ViewEffectiveRights again and it should default to the new database you
set up in user.config. There's no need to save/restore or rename databases.
with for months. Perhaps others will find this useful.
Problem: View Effective Rights in the Project Server 2007 Resource Kit
doesn't allow the user to swich databases if there are multiple databases on
the server. There is also a message about this problem at
http://technet.microsoft.com/en-us/library/cc197528.aspx. that states:
Caution:
There is a known issue for the tool in which the list of databases returned
for the “Check permissionâ€, “for userâ€, and “on project†fields will
automatically populate using the first database found alphabetically. The
workaround is to restore the Project Server databases that you want to use
the tool on, naming them with an initial letter that appears earlier in the
alphabet than the default database populated. Alternatively, you can delete
all of the Project Server databases that appear alphabetically before the one
you wish to utilize.
Solution: Both the project server and database names seemed to be stored in
this path on the user's PC:
Documents and Settings\
[Your user folder]
Local Settings\
Application Data\
Microsoft_Corporation\
ViewEffectiveRights.exe_StrongName_[*]\ (* is lots characters. You'll see
what I mean)
12.0.0.0\
user.config
The databaseis in the "DbName" section.
The server is in the "DbServerName" section.
Just edit user.config and change the database name when you want to run the
tool against a different database.
Example:
<setting name="DbName" serializeAs="String">
<value>YourDBName_Published</value>
</setting>
<setting name="DbServerName" serializeAs="String">
<value>YourServerName</value>
</setting>
Just replace YourDBName_Published with your Project 2007 database name.
You can also replace YourServerName with your Project SQL Server name.
Save user.config. That's all there is to it.
Run ViewEffectiveRights again and it should default to the new database you
set up in user.config. There's no need to save/restore or rename databases.