Non-AD-Admins cannot view project list or individual projects

[Alan Ross]

Windows 2K3, Project 2K3, Same box has AD and Exchange 2K3.

My AD accounts cannot view the project list in PWA unless they are members
of the domain admins group in AD. Even if they are members of the
administrators group in project server, they still get the message, "There
are no projects to display in this view. You either do not have permissions
to see any projects in this view or the projects you have permissions to view
have not yet been published. Contact your server administrator."

I followed all the directions in Article ID: 810596. I applied SP1 and the
post-SP hotfix.

The "view effective rights tool" shows that the users should have access...
especially the ones that I gave admin rights in project server.

This seems to imply an AD issue. But I ran filemon and it doesn't show any
access denied errors at the time I get the message (or the time immediately
prior).

To clarify, as a sys admin, my account in AD is a member of the domain
admins group. When I go to view a project or the project list in PWA, I have
no problems. However, none of my project managers (who are not members of
the domain admins group) can see the project list or any of the projects. If
I temporarily add them to the domain admins group, they can see everything.

The other thing I did was to try to set permissions to the program files >
project server 2003 directory to everyone - full control. But that didn't
make a difference either.

If you can figure this one out, I'd be impressed.

 

[Gary L. Chefetz [MVP]]

You don't give much to go on, but I might surmise that your problem is with
SQL Server configuration.

 

[Alan Ross]

I hope you're being sarcastic.

You don't give much to go on, but I might surmise that your problem is with
SQL Server configuration.

 

[Gary L. Chefetz [MVP]]

If you equate an attempt to help as sarcasm, OK then. You tell us what
you've done, but don't tell us enough about your setup other than you're
overly optimistic about the compatibility of Exchange and Project Server
running on the same box. Where is SQL server? I'll restate my original
comment:

It sounds like your issue is with SQL server. What's preventing the
connection to SQL?