no projects/tasks in my projects and my tasks

[Alex]

Hello,

I have a Project Server 2003 set up on remote location. My account has all
possible privileges in PWA. When I RDP to a computer in the remote network
(using my Active Directory account) and log to PWA (in terminal window), the
I see the projects and list of all tasks even if I'm not assigned to them.
That's fine.

Now, if I try to access PWA over internet (from my PC which is outside the
network where Project Server 2003 installed), it asks me for login/password,
I enter my Active Directory credentials and get access to PWA. However, now I
do not see anything in My Projects and My Tasks. It just loads the empty
grid, says "no projects" and redirects back to PWA home.
I use secure connection (HTTPS/SSL) and site is added to trusted sites.

In other words, if I'm accessing PWA from the same network, it works fine
and I can see all information saved on Project Server. If I'm accessing PWA
from Internet (using the same credentials), it still works fine but does not
display any projects/tasks.

Any help is appreciated. Thanks.

 

[Paul Conroy Designtech]

Have you opend up SQL through the firewall so it can be access from the
internet. Basically what happens is the front end service passes a
connection string back to the client so it can obtain the data direct from
SQL. If SQL is not accessible then you will see no data.

 

[Alex]

Thank you for the prompt reply.

Have you opend up SQL through the firewall so it can be access from the
internet. Basically what happens is the front end service passes a
connection string back to the client so it can obtain the data direct from
SQL. If SQL is not accessible then you will see no data.

 

[Alex]

It's me again
Opening ports didn't help, but I realized that PWA is accessing the SQL
Server using computer name, which is obviously not accessible from the
Internet. So I'm going to change it to an external IP or real domain name.
However, I cannot find where the connection string is saved and how could I
edit it. Any advice is appreciated. Thank you in advance.