Error adding STS server in PWA

[Jamesf]

I am getting the following error trying to add the
SharePoint server into the Admin screen on PWA:

Microsoft Project Server cannot read from the specified
SharePoint database.

I have run stswiz.exe on the SharePoint site with no
problem and copied the information correctly.

I also ran the pscomplus.exe and configured the proper
accounts.

I also ran a network trace of the conversation between the
project server and the SQL server during the error.

The Project server requested the following select
statement from the SharePoint Database on the SQL server:

SELECT Projects.tp_ID as StsProjID from Projects INNER
JOIN DocMd on Projects.tp_WebRef = DocMd.UrlID WHERE
DocMd.Url = MS_ProjectServer_PublicDocuments

The SELECT statement executes properly and retuns the
correct value (2 in this case). That is the last
conversation between the servers before the error is
displayed.

This indicates to me that the pscomplus settings are
correct and the databases are accessible.

Any ideas on this?

 

[Gary Chefetz [MVP]]

James:

Is the STSAdmin account a member of the local administrators group on the
SQL server?

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com

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

 

[JamesF]

By STSAdmin do you mean the account specified by pscomplus?

If so, I have put in the domain/administrator account for
all 3 entries in pscomplus in an attempt to solve the
problem. The domain/administrator is a member of the
local administrators group on the SQL server.

If not, where is the STSAdmin account set?

James

 

[Gary Chefetz [MVP]]

James:

Well that's an odd account to choose. Take a look at the following KB
article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322235

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com

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

 

[Gary Chefetz [MVP]]

James:

If you insist on using the domain administrator account, make sure that
account has explicitly been added to the local administrator's group.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com

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