Sharepoint and Project Server 2002

[Brandon]

Ok here is the situation...

When I setthe com+ with a domain admin account that acts
as a service account for the SQL server it works fine and
connects fine.

Sharepoint Team Services uses database authentication
using the SA account and it connects to the database and
works fine.

When I try to setup the Sharepoint Team Services in
Project 2002 when it attempts to connect to the database,
it fails.

Any ideas? Project Server 2002 must use a domain account
to connect to the sql database from what I understand and
cannot use database authentication.

Any info. would be appreciated.

 

[Gary Chefetz [MVP]]

Brandon:

Did you run proxycfg.exe?

--
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.

 

[heggers]

I have the very same issue as Brandon. I have also managed to set up
Team Services up ok and grant admin rights in COM+ and sql.

I have reinstalled Project Server and Team Services to no avail and
double checked rights and everything seems to be correct.

I also have ran Proxycfg and set it as ( proxycfg -d -p
fake_proxy_name:80 "*.server_name.com;<local>)

The servers and details are:

SERVER-1: Portal Server
SERVER-2: SQL, Team Services and Sharepoint

Server name: SERVER-2
SharePoint Web server port: 8080
SharePoint administration port: 6308
SharePoint database server name: SERVER-2
SharePoint database name: SERVER-2_LM_W3SVC_11_Collab2

Brandon:

Did you run proxycfg.exe?

-----Original Message-----

The account I created is a domain admin. I have added it
to the local admin group on both the SQL server and the
server running Project Server which also runs Sharepoint
Team Services.

The account has security admin rights and db_owner rights
on the database itself. When I run the pscomplus tool and
use that account it sets up the com+ properly. When I
setup the connection from the Sharepoint Team Services to
the sql database with the SA account it works fine. The
problem is when I go to setup the Sharepoint Team services
in Project server I get the following error

"Microsoft Project Server cannot read from the specified
SharePoint database."

The reasons could be:

1) (domain admin account) does not have read permission on
the specified SharePoint database.
2) The database server and database name are not correctly
specified.
3) The database server is down and cannot be accessed at
this time.

I made sure the domain admin account which I stated
earlier has the rights. I ran the proxy utility and that
completed but still not working still gives the error
message.

 

[Gary Chefetz [MVP]]

heggers:

You have similar symptoms, not necessarily the same problem. The string you
quote for proxycfg is incorrect; you're missing several quotes and I'll have
to take your word for your bypass list values. I wonder if the dash in your
server name is causing problems as well.

--
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.

 

[heggers]

Looking at the Proxycfg config, looks correct?

Flags = PROXY_TYPE_DIRECT | PROXY_T
Proxy Server = fake_proxy_name:80
Bypass List = *.server_name.com;<local>

btw, the *real* server names do not have any dashes in their names.

 

[Rich Feather]

Try this instead:

proxycfg.exe -d -p * "<local>;"

 

[John Miller]

I have a similar setup that ALL services are running on the same server.
Everything works except "Add a Web Server running Sharepoint Team Services"
When we try to add the server it gives the same error message:

"Microsoft Project Server cannot read from the specified SharePoint
database."

The reasons could be:

1) (domain admin account) does not have read permission on the specified
SharePoint database.
2) The database server and database name are not correctly specified.
3) The database server is down and cannot be accessed at this time.


We have gone through the setup twice ... maybe more.

Any ideas or help?

John Miller
Florida Department of Financial Services


Try this instead:

proxycfg.exe -d -p * "<local>;"

 

[Gary Chefetz [MVP]]

John:

Did you run the proxycfg utility? This must be run, whether you have a proxy
or not.

--
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.