Urgent!! How to change doclib's url in project server

[William Li]

Hi,

I'm now deploying project server for my customers, but I've met a problem I
cant resolve for 1 week!
The doclib url of all projects in my project server is mapped to the
intranet name of my project server.
However a lot of users will access doclib from internet which means the
doclib url must be mapped to project server's internet URL.

I tried to change the URL configuration in Project Server's "Management" ->
"Manage Windows Sharepoint Services" -> "Create sites under this Sharepoint
URL". But everytime I change the url from server's intranet url to internet
url, an error which says "cannot connect to that specified windows
sharepoint services" showed up.

Does anybody know how to successfully change the URL?

Thanks a lot in advance!!!

William

 

[Remco de Haan]

Hi William,

I have had a similar problem, and had to change the url. I have tried
everything but came to two solutions:

1. register everything again with editsite (but did not solve the problem in
all cases)
2. directly edit in the database. Do not know the exact name of the msp_
table anymore but can't be hard to find.
The url is spread over several columns (systemname, serverurl etc)

Updating this url solved my issue.

Regards,

Remco de Haan

 

[ecihewu]

Hi Remco,

I am having the same problem. I cannot find the msp_table you
mentioned. Is it possible that you can find the table name for us?

Thanks.

Wu

 

[Remco de Haan]

To all,

the table I mentiont is the msp_web_sts_servers

wsts_server_name = wss server hostname
wsts_server_web_port = wss port number
wsts_server_admin_port = wss admin port (wss central admin port)
wsts_server_managed_path = wss default document location

when the wss default document location url = host/sites then the
wsts_server_managed_path field contains only : sites

Best regards, Remco de Haan

 

[ecihewu]

Thanks for your quick reply. But I didn't exactly understand what you
said.

How to type internet URL in the table msp_web_sts_servers? Can you give
me an example?

I got doclib access problem when I typed the following :

wsts_server_name = test_server
wsts_server_web_port = 10243
wsts_server_admin_port = 0
wsts_managed_path = sites

BTW, i didn't find wsts_server_managed_path in this table.

Thanks for your help in advance.

 

[Remco de Haan]

Hi,

In a multi server setup the following whould be the case:

host 1: my_epm_server (full epm server or front end server)
host 2: my_wss_server (Windows Sharepoint Services host)

urls for wss:

cental admin: http://my_wss_server: 10243
default document: http://my_wss_server/sites

entry in the msp_web_sts_servers

wsts_server_name = "my_wss_server"
wsts_server_web_port = "80"
wsts_server_admin_port = "10243"
wsts_managed_path = "sites"

Note that the admin portnumber is generated in the wss setup (see iis
websites properties)
Note that the port 80 as a web port isd the default (but might be different
in your setup, see iis websites properties)
My EPM system is running sp2a (which might be the reason I do have the field)