Cannot proerly connect to Project Server 2003 web access via VPN

Posted on 2007-08-09
Last Modified: 2013-11-15
In a nutshell:
PWA works perfectly when connecting on the local LAN, error conditions exist when connecting using VPN. I have verified this by 1) connecting locally and testing then 2) using the same LAN connection, connecting via our VPN server (Juniper).

o Project Server 2003 SP1
o NTLM authentication
o Tested with IE 6.0 and IE 7.0
o Also tested with Nortel VPN client with the same results.
o Tested with all firewalls disabled.

I can connect to the PWA home page no problem.

1. When I click Projects from the main menu, the following message flashes on the screen then I am returned to the PWA home page:
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 toview have not yet been published. Contact your server administrator.
(There are most definitely projects to display)

2. When I choose Tasks from the PWA main menu, an empty grid flashes on the screen and I am returned to the PWA home page.

3. When I choose Resources from the PWA main menu, I get the following message in an OKOnly dialog box:
An error occurred while trying to access the resources stored on the database. Either there are too many resources,or the Project Server may not have the correct DSN conFiguration. Contact the server administrator.
(The DSN is correct. I even tested it using IP addresses instead of names)

3. When I choose Updates from the PWA main menu, I get a "Loading data..." message flashes and I am returned to the PWA home page.

4. Risks, Issues, and Documents menu items work correctly.

Here's what I do know:

o All service packs and updates are installed.
o Security settings are correct - the testing was done with both standard user and admin rights.
o When I trace the IIS traffic and reproduce the error, I found that at the point of failure, the client is GETing the file /ProjectServer/styles/1033/PWAGrid.css. This file does not exist anywhere on the server, client, or Project Server installation DVD. Not as a zipped file, not in any CAB files, not anywhhere that I can find.
o When I trace IIS on a non-VPN connection, PWAGrid.css is never requested by the client.
o All addresses can be resolved (DNS) by both the server and the client.
o The supporting SQL Server (2000 SP4) is installed on the same box as Project Server 2003.

After week, this is making me crazy. I can't be the Lone Ranger here...someone else has surely run into this...

Question by:bmatsoukas
    LVL 5

    Assisted Solution

    Not sure if this will help, but I had problems with PWA from outside the local lan, turned out to be a name resolution problem. We fixed by ensuring all names were the same, and were resolvable internally and externally. Make sense? Project server resolves name or for instance, regardless of whether you are inside or outside the network.

    Author Comment

    Thanks, I will go through naming in detail and let you know.
    LVL 10

    Accepted Solution

    When same hi qualified MPS consultant  instaled MPS he didn't entered FQDN od SQL server
    , and client's aren't able resolve SQL server name.


    Author Comment

    t_swartz -- you were on the right track: the name was not resolving correctly. Why I don't know as I had no problem pinging the SQL server from Project Server using only the computer name. However the solution submitted by winzig was the fix. I went into SharePoint admin and changed the assignment of the content database server and the configuration database server to and it worked. Thank you both. You have no idea how painful this problem has been (or mayby you do :). Thank you, thank you, thank you.
    LVL 10

    Expert Comment

    You can't change name of the project server this way

    You have to use
    C:\Program Files\Microsoft Office Project Server 2003\BIN\1033\CONNINFO.EXE or
    C:\Program Files\Microsoft Office Project Server 2003\BIN\1029\CONNINFO.EXE (number depends on your language)

    to change name of the SQL server with project DB

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Let’s list some of the technologies that enable smooth teleworking. 
    After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
    After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now