Change port used by Project Pro to read/write projects to MS-SQL

[Kenneth Lau]

Does anyone know how to change the default port 1433 used by Project Pro to
comunicate with MS-SQL to another port? Port 1433 is blocked by the firewall.

Thanks.

Kenneth Lau

 

[Rolly Perreaux]

Does anyone know how to change the default port 1433 used by Project Pro to
comunicate with MS-SQL to another port? Port 1433 is blocked by the firewall.

Thanks.

Kenneth Lau

Hi Kenneth,

Question. Are you trying to communicate Project Pro to Project Server
from outside your firewall? Say, from a remote location?


--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Kenneth Lau]

Yes. Project server is inside the firewall and the project client users are
outside the firewall. The firewall is blocking port 1433.

I would like to change the project client to comunication with project
server on another port to bypass the firewall restriction.

Kenneth

 

[Rolly Perreaux]

Yes. Project server is inside the firewall and the project client users are
outside the firewall. The firewall is blocking port 1433.

I would like to change the project client to comunication with project
server on another port to bypass the firewall restriction.

Kenneth

Hi Kenneth,

Unfortunately Project Pro uses the hard coded ports 1433/1434 for SQL
connectivity.

More info on the ports
http://www.grc.com/port_1433.htm
http://www.grc.com/port_1434.htm

The solution for Project Server 2003 is to either VPN through the
firewall and into the network to be able to connect to the SQL server
hosting the Project Server database.
OR
Using Terminal Server or Remote Desktop Client to access the Project Pro
application to connect internally to the SQL server hosting the Project
Server database.

In Project Server 2007, this will change as Project Pro 2007 can use RPC
over HTTP to make the connection outside the firewall.

Good Luck

--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Ray McCoppin]

It is possible to use another port other than 1433 for the Project Server SQL
connection. First you have to change you SQL server to the other port number.

First configure the SQL server using a static port
http://support.microsoft.com/default.aspx?scid=kb;en-us;823938

Second change the Project Server SQL server connection string using format
bellow.
http://support.microsoft.com/kb/265808/en-us

Third If you WSS servers database is on the same SQL server change is
connection to use the port. By using the format "servername,port"

Hope this helps.