New Project Server 2003 install and PWA

[Chris Knight]

Okay, I know that I'm missing something simple, please someone let me know
what it is.

Situ: New small scale installation of Project 2003sp2a, WSS 2.0 (with sp2a
patch, Windows 2003R2, MSSQL 2005 (with Project DB install via KB917401, and
patched for SP2a) Project Pro 2003 for client side. With this setup I get
the following problem:

I cannot access/see Projects from PWA on any machine other then the server
running Project Server. I have added myself as a user with admin privs for
Project Server, and have assigned myself a few projects (published via
Project Pro 2003), and if I logon as a user on the Project Server server, and
I can log into the PWA and view Projects, assign Tasks, etc. If I logon to a
PC (w/ 2000 Pro, or XP Pro), use IE 6+ (no IE 7) to log into PWA, and then
chose Projects, I recieve the message that there are no projects to view and
kicks me back to home page, tasks gives an empty list of tasks and back to
the home page, updates gives a RecordCount is Null error, and Resources gives
an Error about too many resources or incorrect DSN.

Firewall is off on the Project Server server, the PC can access the SQL
server as well.

Any ideas?

 

[Rod Gill]

Hi,

Read http://support.microsoft.com/kb/917401/en-us for SQL Server 2005
support.

Do you have Project Professional SP2? You always need to keep Project
Professional and Project Server service pack levels in parallel. Some
patches require a matching patch in the client or server.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Chris Knight]

Hi Rod,

Thanks for replying. As noted I have used the KB that you mention to
create the Project Server DB unber SQL 2005. Yes, I am using Project Pro
2003sp2 for the client publish.

-Chris