Setup ProjectServer over the internet

D

Dave Lowndes

Apologies if this has been covered before.

We have set up Project Server on our network and configured the firewall to
allow internet access. Right now we can access PWA over the internet at
http://projects.ourcompany.com/ProjectServer/. I can also login using
Project Professional. However, when I try to check out a project I get this
error:

Connection failed:
SQLState: '01000'
SQL Server Error 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.

Are we heading oin the right direction and can resolve this or do we need a
completely different approach. Can any provide a link to definitive
information for securely setting up Project Server to run across the
internet and allow PWA access/remote checkout of projects (even when users
are not on the ProjectServer domain)? I've read about a "Citrix" solution.
Can someone provide me with more information on what this is and in
particular using a Citrix solution with Project Server?

Thanks

Dave

PS. Is there an archive of newsgroup messages which I can search through? I
can only download headers as far back as mid-October.
 
N

Nico Oosthuysen

Hi All,

I am having the exact same problem, although our scenario is a bit
different.

The server is sitting on a DMZ; people from the outside will need to connect
via PWA (and this is working fine), and people from the inside will need to
connect via PWA and Project Pro. By default, only Port 80 is open from the
DMZ to the inside - and thus PWA works properly.

However, when we try to connect with Project Pro, we get the same error as
Dave below. As far as i understand (and as my logic tells me), Project Pro
makes a direct connection to the SQL server via ODBC. This means that SQL
connectivity will need to be open to the server to work properly. So what
we have done is to open port 1433 from the inside to the DMZ, but still we
are having no luck and we are still getting the same error.

I have tested that the port is open by telnetting to the server on the
specified port.

I know that Terminal Services is the recommended solution, but it is not
really an option for us to use at this stage - as the only people who will
be connecting to the server with Project Pro is sitting on the inside, and
thus offer no security risk. The client is also unwilling to spend the
extra money that will be needed to get a proper terminal services server up
and running.

Please, if anybody has some information\assistance it will be GREATLY
appreciated.

Regards,
Nico Oosthuysen
 
S

Scott Carrie

Check out this link on MS:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;818047

Run the cliconfg.exe program and select TCP/IP and it
should solve your problem.

Regards,
Scott

-----Original Message-----
Hi All,

I am having the exact same problem, although our scenario is a bit
different.

The server is sitting on a DMZ; people from the outside will need to connect
via PWA (and this is working fine), and people from the inside will need to
connect via PWA and Project Pro. By default, only Port 80 is open from the
DMZ to the inside - and thus PWA works properly.

However, when we try to connect with Project Pro, we get the same error as
Dave below. As far as i understand (and as my logic tells me), Project Pro
makes a direct connection to the SQL server via ODBC. This means that SQL
connectivity will need to be open to the server to work properly. So what
we have done is to open port 1433 from the inside to the DMZ, but still we
are having no luck and we are still getting the same error.

I have tested that the port is open by telnetting to the server on the
specified port.

I know that Terminal Services is the recommended solution, but it is not
really an option for us to use at this stage - as the only people who will
be connecting to the server with Project Pro is sitting on the inside, and
thus offer no security risk. The client is also unwilling to spend the
extra money that will be needed to get a proper terminal services server up
and running.

Please, if anybody has some information\assistance it will be GREATLY
appreciated.

Regards,
Nico Oosthuysen
Dave Lowndes said:
Apologies if this has been covered before.

We have set up Project Server on our network and
Click to expand...
configured the firewall
to
allow internet access. Right now we can access PWA over the internet at
http://projects.ourcompany.com/ProjectServer/. I can also login using
Project Professional. However, when I try to check out
Click to expand...
a project I get
this
error:

Connection failed:
SQLState: '01000'
SQL Server Error 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.

Are we heading oin the right direction and can resolve
Click to expand...
this or do we need
a
completely different approach. Can any provide a link to definitive
information for securely setting up Project Server to run across the
internet and allow PWA access/remote checkout of projects (even when users
are not on the ProjectServer domain)? I've read about a "Citrix" solution.
Can someone provide me with more information on what this is and in
particular using a Citrix solution with Project Server?

Thanks

Dave

PS. Is there an archive of newsgroup messages which I
Click to expand...
can search through?
I
can only download headers as far back as mid-October.
Click to expand...


.
Click to expand...
 
Top