Project Pro 2003 - Connection to PS 2003

Lucas Campos

unread,

Oct 14, 2003, 4:27:52 PM10/14/03

to

Hi,
Does Project Professional 2003 still uses odbc to connect to Project Server
2003 (like PP 2002 did)?
If the answer is "no", How does it connect? Is it save now to access PS via
PP over Internet or we need to open SQL Server port also?
Resources about this topic will be welcome

Thanks a lot

LucasC

Lars Hammarberg

unread,

Oct 14, 2003, 6:54:21 PM10/14/03

to

Apart from all the authentication and ProjectServer security groups etc. the
bottom line is that when saving/opening Project "files" in Professional,
you're using ODBC directly to the SQLServer (via the MSProjectUser
account) - so, yes - port 1433 or whatever is used for your sqlserver has to
be open in the firewall.
That said - the best solution would rather be to use a Terminal Server
access, preferably using certificates or the like and start a
ProjectProfessional session in TS. This will also remove any communication
bottlenecks. There's a LOT of data being moved from client to server and the
other way around...

/Lars Hammarberg
www.camako.se

"Lucas Campos" <ms...@rmya.com.ar> wrote in message
news:O%23HOAHpk...@TK2MSFTNGP12.phx.gbl...

Lucas Campos

unread,

Oct 15, 2003, 10:21:04 AM10/15/03

to

I expected Project (pro and Server ) 2003 change this in order to connect
via internet without opening SQL ports in the firewall

Thank you

LucasC

"Lars Hammarberg" <lars.ha...@nospam-camako.se> escribió en el mensaje
news:ugYngYqk...@TK2MSFTNGP10.phx.gbl...

Tester Man

unread,

Oct 15, 2003, 4:02:21 PM10/15/03

to

You mean via HTTP? That would be nice.

"Lucas Campos" <ms...@rmya.com.ar> wrote in message

news:%23GIPtey...@TK2MSFTNGP11.phx.gbl...

Lucas Campos

unread,

Oct 15, 2003, 4:09:24 PM10/15/03

to

That's right.

"Tester Man" <te...@test.com> escribió en el mensaje
news:OjJjLc1k...@TK2MSFTNGP10.phx.gbl...

Gary L. Chefetz

unread,

Oct 21, 2003, 3:49:48 PM10/21/03

to

Lucas:

You truly expected a complete overhaul in 15 months?

--

Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

"Lucas Campos" <ms...@rmya.com.ar> wrote in message

news:#GIPteyk...@TK2MSFTNGP11.phx.gbl...

Lucas Campos

unread,

Oct 21, 2003, 4:35:24 PM10/21/03

to

Not really :-)

"Gary L. Chefetz" <gary-at-chefetz.org> escribió en el mensaje
news:OEdL%23xAmD...@tk2msftngp13.phx.gbl...

Gary L. Chefetz

unread,

Oct 24, 2003, 9:20:50 AM10/24/03

to

Let's hope P12 takes us there.

--

Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

"Lucas Campos" <ms...@rmya.com.ar> wrote in message

news:#1ed4LBm...@TK2MSFTNGP10.phx.gbl...

Mike Walters

unread,

Nov 13, 2003, 2:35:11 PM11/13/03

to

I have port 1433 open in my firewall and I have cliconfg.exe setting
set for TCP/IP only. I still get a SQL connection Failed. Under the
server dropdown it had my server name. When I change it to the IP
address it works just fine. Can I change the ODBC Default setting to
use my IP not the server name?

thanks
Mike

"Lars Hammarberg" <lars.ha...@nospam-camako.se> wrote in message news:<ugYngYqk...@TK2MSFTNGP10.phx.gbl>...

Gary L. Chefetz

unread,

Nov 13, 2003, 5:49:36 PM11/13/03

to

You can spoof it by adding an entry into the LMHOSTS file

--

Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

"Mike Walters" <Mi...@walterscentral.com> wrote in message
news:1ede8f1e.03111...@posting.google.com...