Remote users can't publish project to Project Server - ODBC error

[wacNTN]

I have a user in another state who is connected over our private network. He
can enter the Project Server URL and Test Connection gives the thumbs up.

He can save his project in to Project Server fine but we don't see it in any
of the project server views. We do see it in the Delete project list on the
Clean up Project Server admin page so we know it's in the database.

I had him do a Collaborate->Publish->Project Plan and he gets the following
error:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Read (recv())

His project never becomes visible.

Is this some sort of network issue? latency, ports, etc.?

Any help or suggestions would be appreciated!

Walter

 

[Scott m Wagner - EPM Consulting Services]

I will say up front that if you are connecting over a WAN the recommendation
from Microsoft is to set up Terminal Services and Remote Desktop solution
(security and other advantages) but you are probably aware of that and wish
to configure it this way for this user.

On the End user machine
I would configure the:
SQL Server Client Network Utility
To do this:
Click Start\Run and in the dialog type cliconfg
Click the Alias tab
Click the Add button and fill out the information
Select TCP/IP
Put the name of the server in the alias box and the IP address in the Server
box
Ensure that it is pointing to the correct Port for SQL (1433 standard)
Click OK twice.
Restart the end user machine
Try to connect and publish.

Hope it helps,

Scott

 

[IISJUNKIE]

The tricky thing about connecting is the same thing you need to configure the
deployment to support. Keep in mind - PWA uses HTTP Port 80 traffic so
normal people just using the PWA interface can use this via SSL or VPN to
enter updates and general interaction to PWA.
Project Professional though can use BOTH the app and the PWA access all
inside the product so both Port 80 for the PWA & 1433 for the APPLICATION.
so since your VPN person is connecting outside of your network where your
server is then I would be willing to bet that port 1433 traffic is NOT
allowed through the firewall / router / and so on...
Another consideration: Project Professional requires at least 10k constant
connection at a mininum in order to operate correctly to connect to the
server, which means that the person connecting may be on like "basic broad
band cable" but may still experience issues if the connection speed drops or
fluctuates anywhere close.

If you need more help let me know, I'm doing the same thing but for people
connecting from TAIWAN and England so I could probably help you figure it out.

Regards,

I will say up front that if you are connecting over a WAN the recommendation
from Microsoft is to set up Terminal Services and Remote Desktop solution
(security and other advantages) but you are probably aware of that and wish
to configure it this way for this user.

On the End user machine
I would configure the:
SQL Server Client Network Utility
To do this:
Click Start\Run and in the dialog type cliconfg
Click the Alias tab
Click the Add button and fill out the information
Select TCP/IP
Put the name of the server in the alias box and the IP address in the Server
box
Ensure that it is pointing to the correct Port for SQL (1433 standard)
Click OK twice.
Restart the end user machine
Try to connect and publish.

Hope it helps,

Scott

I have a user in another state who is connected over our private network. He
can enter the Project Server URL and Test Connection gives the thumbs up.

He can save his project in to Project Server fine but we don't see it in any
of the project server views. We do see it in the Delete project list on the
Clean up Project Server admin page so we know it's in the database.

I had him do a Collaborate->Publish->Project Plan and he gets the following
error:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Read (recv())

His project never becomes visible.

Is this some sort of network issue? latency, ports, etc.?

Any help or suggestions would be appreciated!

Walter